| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting multiple columns for subtotals
Is there a quicker way to select columns to include subtotals in? I have a
spreadsheet with 50+ columns. Clicking each one individually is tedious. -- CG |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Selecting multiple columns for subtotals
See if this gives you any satisfaction:
When selecting the columns for subtotals, you can use the Up/Down arrows to change columns and the Space Bar to select/de-select By doing that, you could zip right through those columns in a couple seconds. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "CEG" wrote: Is there a quicker way to select columns to include subtotals in? I have a spreadsheet with 50+ columns. Clicking each one individually is tedious. -- CG |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Selecting multiple columns for subtotals
Much better than scrolling and clicking each one. It would be nice if they
would add a "select all" button, though. Thanks! -- CG "Ron Coderre" wrote: See if this gives you any satisfaction: When selecting the columns for subtotals, you can use the Up/Down arrows to change columns and the Space Bar to select/de-select By doing that, you could zip right through those columns in a couple seconds. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "CEG" wrote: Is there a quicker way to select columns to include subtotals in? I have a spreadsheet with 50+ columns. Clicking each one individually is tedious. -- CG |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Justify text across multiple columns | Excel Discussion (Misc queries) | |||
| Multiple columns in a pivot table | Excel Discussion (Misc queries) | |||
| splitting 1 column of data into multiple columns | Setting up and Configuration of Excel | |||
| drop down list multiple columns | Excel Discussion (Misc queries) | |||
| Drop-down selection fills data across multiple columns | Excel Discussion (Misc queries) | |||
Linear Mode
