microsoft excel training london - consolidating multiple worksheet

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 excel training london - Consolidating multiple worksheets

microsoft excel training london - Consolidating multiple worksheets

resolvedResolved · Low Priority · Version Standard

Bowen has attended:
Excel Advanced course

Consolidating multiple worksheets

What is the quickest way of consolidating multiple worksheets into one worksheet so that I can then begin to make the data consistent and thereafter make use of pivot tables?

RE: Consolidating multiple worksheets

If your data has identical structure on each worksheet, you can then use the consolidate feature.

If worksheets have different structures, then decide on a format that they can all fit into, and manually transfer the information.

Pivot tables work best with unique data fields.


 

Excel tip:

Moving between Worksheets without using the mouse

Use the 'Ctrl+PgDn' and 'Ctrl+PgUp' keys.

'Ctrl+PgDn' will move to the right and 'Ctrl+PgUp' will move to the left one worksheet at a time.

View all Excel hints and tips


Server loaded in 0.09 secs.