View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default 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