Selecting multiple columns for subtotals

C

CEG

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.
 
R

Ron Coderre

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
 
C

CEG

Much better than scrolling and clicking each one. It would be nice if they
would add a "select all" button, though. Thanks!
 
Top