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
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-Proquot;CEGquot; wrote:
gt; Is there a quicker way to select columns to include subtotals in? I have a
gt; spreadsheet with 50 columns. Clicking each one individually is tedious.
gt; --
gt; CG
Much better than scrolling and clicking each one. It would be nice if they
would add a quot;select allquot; button, though. Thanks!
--
CGquot;Ron Coderrequot; wrote:
gt; See if this gives you any satisfaction:
gt;
gt; When selecting the columns for subtotals,
gt; you can use the Up/Down arrows to change columns
gt; and the Space Bar to select/de-select
gt;
gt; By doing that, you could zip right through those columns in a couple seconds.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;CEGquot; wrote:
gt;
gt; gt; Is there a quicker way to select columns to include subtotals in? I have a
gt; gt; spreadsheet with 50 columns. Clicking each one individually is tedious.
gt; gt; --
gt; gt; CG
- Jul 16 Mon 2007 20:38
Selecting multiple columns for subtotals
close
全站熱搜
留言列表
發表留言