| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to consolidate data in different excel sheets
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to consolidate data in different excel sheets
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. "Payal" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
| Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
| Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
| getting data from 2 excel sheets automatically | Excel Worksheet Functions | |||
Linear Mode
