Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 97
Does anyone know if it is possible to select multiple cells from 2 different
Pivot Tables? I have 2 pivot tables, each with a Total and would like to select the Totals from the 2 Pivot Tables. I know this can be done with Office 2003 and when selected, the SUM of the cells appears in the bottom right of the spreadsheet. |
#2
|
|||
|
|||
I don't have xl97 to test this on, but if your pivottables are on one
worksheet, then select the first range and ctrl-click to select the second range. If you don't see the sum, try rightclicking on the statusbar near those embossed boxes and select Sum. Tools|Options|View Tab|Make sure Status bar is checked. jjonesa wrote: Does anyone know if it is possible to select multiple cells from 2 different Pivot Tables? I have 2 pivot tables, each with a Total and would like to select the Totals from the 2 Pivot Tables. I know this can be done with Office 2003 and when selected, the SUM of the cells appears in the bottom right of the spreadsheet. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
html to excel | Excel Discussion (Misc queries) | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Merge from Excel to Excel | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
Shortcut file fails to open | Excel Discussion (Misc queries) |