Selecting multiple columns for subtotals

[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.
--
CG

[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


"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

[CEG]

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