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

microsoft office training excess - consolidation

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

microsoft office training excess - Consolidation

ResolvedVersion 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:

Shared Conditional Formatting

In a shared workbook, conditional formats applied before the workbook was shared will continue to work; however you cannot modify the existing conditional formats or apply new ones.

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.