Excel

Resolved · Urgent Priority · Version 2016

Wed 7 Aug 2019, 16:45 Delegate Jessie said...

Jessie has attended:
Excel Intermediate course

Excel

Can i use consolidate for data in different workbooks?

Wed 7 Aug 2019, 18:02 Trainer Dennis said...

Excel consolidate

Hi Jessie

Yes, you can consolidate from multiple workbooks. The easiest way to do this is to open all the workbooks, then when entering the data range simply select each workbook and the data to be consolidated in the same way you would if the data was in the workbook. Complete the process as normal

Wed 14 Aug 2019: Automatically marked as resolved.

Excel tip:

How to select certain data in an Excel 2010 workbook

If you want to select the correct data set in a page full of data, the most accurate and efficient way of doing this is to use the ''Shift and Click'' technique.

For example: If you want to select all data in cells A2 to E10, then click on cell A2, hold down the Shift key and click on cell E10 and all the data you want to see is highlighted.

Keep holding down the Shift key and you can move from cell E10 to any other cell in the spreadsheet.

View all Excel hints and tips

Excel

Excel

Excel consolidate

Excel articles

Excel tip:

How to select certain data in an Excel 2010 workbook