close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()