Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel computer training london - how do i consolidate

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel computer training london - How do I consolidate data

excel computer training london - How do I consolidate data

ResolvedVersion Standard

Carole has attended:
Excel Intermediate course

How do I consolidate data

As above

RE: How do I consolidate data

Hi Carole

Thank you for your question.

The idea behind consolidating data is to make a summary spreadsheet from data on seperate spreadsheets. It is important that each spreadsheet has the same column headings and row headings.

1. Select a cell where you want your consolidated data to begin appearing from (i.e. the top-left corner of where the consolidated data will go).

2. Go to Data-Consolidate.

3. Choose which function you want to use for the consolidation.

4. From the Refence area, select the first range of cells to be included in the consolidated data, including the row and column headings.

5. Click Add.

6. Repeat steps 4 and 5 until you have selected and added all the data ranges to be consolidated.

7. Tick the 'Top row' and 'Left column' boxes, and tick 'Create links to source data' if you wish the consolidated data to be linked to the data from each sheet.

8. Click OK.

I hope this helps.
Amanda

Excel tip:

Quickly select a block of data

To quickly select a block of data make sure your active cell is somewhere whithin the block of data and then press Ctrl+* or Ctrl+Shift+8.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.