how to consolidate data in different excel sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have different worksheets in one excel file containing Numbers and
alphabets. i want to summarise them to one top sheet so that i can have a
consolidated data. how do i do it? please help
 
Select the cell on the top sheet in which you wish to collect summarise
(Total) the data from other work sheets. Press the SUM key and release.
While holding down the ctrl key select the various cells on the top sheet
and/or other worksheets in the file. When you have finished your selection,
release the ctrl key and press enter. The total of the information will now
be displayed in the selected cell on the top sheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to consolidate data from different files? 2
Vlookup from different sheets 2
Data Tools - Consolidate Excel 2007 11
consolidate multiple worksheets 13
Consolidate excel 2007 4
data consolidation 1
Consolidate Excel Data from multiple sheets into one 1
Pivot tables 3

Back
Top