Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]()
Copy the pertinent range on the sheet you want to subtract. Move to
theother sheet and select the top left corner of the same range. From the menu select EditPaste SpecialSubtract "jennifer" wrote in message ... I have two sheets in the same format. Is there a quick way to subtract the entire sheet one from the other or do I have to resort to just doing a subtract formula and copying to relevant cells? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
The Aarow keys move the entire sheet instead of to the next cell | Charts and Charting in Excel | |||
My entire sheet moves instead of the cursor. What to do? | Excel Discussion (Misc queries) | |||
Linking to an Entire Sheet | Links and Linking in Excel | |||
Referencing an Entire Sheet | Excel Discussion (Misc queries) | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |