Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a shortcut?
Hi,
Is there a short cut to adding up lots of different formulas from different worksheets? e.g. "='sheet 1'!F495+'sheet 2'!F495:H495+'sheet 3'!F495:H495+'sheet 4'!F495:H495+'sheet 5'!F495+'sheet 6'!F495 Athough i can use the auto fill for some cells the each worksheet has many hundreds of cells i need to add up in a 'totals' sheeet.......? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shortcut Keys -- quick find | Excel Discussion (Misc queries) | |||
Deactivate shortcut keys in excel.. | Excel Discussion (Misc queries) | |||
Isolating a Keyboard Shortcut | Setting up and Configuration of Excel | |||
how can you customize a shortcut menu in excel? | Excel Discussion (Misc queries) | |||
Shortcut menu does not have hyperlink on it | Excel Discussion (Misc queries) |