microsoft office training excess - consolidation

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft office training excess - Consolidation

microsoft office training excess - Consolidation

resolvedResolved · Low Priority · Version Standard

Darren has attended:
Excel Intermediate course

Consolidation

How do you consolidate files?

RE: Consolidation

Hi Darren

My interpretation of the question you have asked is that you may be looking to one of of two different things, so I have made two suggestions below. If neither of my suggestions answers your question, please post to the forum again and let us know.

You can consolidate data from different worksheets by using the Consolidate feature, which you can find through the Data menu in Excel.

If you wish to put several worksheets that are in different files into the same Excel file, then you can move sheets from one file to another by right-clicking on the sheet tab of the sheet you want to move, then selecting Move or Copy from the menu.

From the To book: dropdown arrow, select the file you wish to move the sheet to. Please note that if you wish to move the sheet to a file you have already created and saved, you will need to have this file open so that the name of that file appears in the dropdown list.

Then click OK.

This should move the sheet to the Excel file you selected using the dropdown arrow.

Thanks for your question
Amanda


 

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips


Server loaded in 0.08 secs.