Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I add cells on different worksheets in excell
Having trouble adding same cell on different worksheets can anyone help
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I add cells on different worksheets in excell
If the sheets you want to include are in a contiguous group:
=SUM(Sheet1:Sheet5!A1) If the sheets are random: =SUM(Sheet1!A1,Sheet5!A1,Sheet7!A1) -- Biff Microsoft Excel MVP "reidser" wrote in message ... Having trouble adding same cell on different worksheets can anyone help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I add cells on different worksheets in excell
I am not really sure what exactly do you mean but if you mean that you want
to add a column or a row in the same place in several sheets you should active the place that you want to add row or column in the first sheet and then press Ctrl and hold it and click on the other sheets that you want to add and then go to menu: Insertrows or columns. Hope this works for you otherwise you gotto give more explanation. -- Farhad Hodjat "reidser" wrote: Having trouble adding same cell on different worksheets can anyone help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referenceing worksheets in excell 2003 | Excel Discussion (Misc queries) | |||
Excell worksheets | Excel Worksheet Functions | |||
excell worksheets | Excel Worksheet Functions | |||
headers on excell worksheets | Excel Discussion (Misc queries) | |||
Excell budget worksheets | New Users to Excel |