subtotals (85 coll): Is there an easyer way than ticking 85 boxes

[Guest]

Subtotal function: Is there an easyer way to select many collumns in a
preadsheet?:

In my 185 collumn worksheet i want to subtotal about half - in various
places in the sheet. In the 'suptotals chek bock I check each individual
collumn that i want a subtotal for. This takes ages, and also there is no
'select all' option. Does anyone know how to make the selection quicker?

 

[Bryan Hessey]

You can select multiple columns the normal Windows method of click the
shift-click then CTRL/click

Select the first column in a range, and shift-click the last column
hold CTRL and click for additional columns.

If you always select a variety of columns you can record a macro whils
doing this, then use the macro for future selections.

However, be aware that the CTRL/Click again does not release th
selection, so choose wisely.

Hope this helps

--

 

[Dave Peterson]

If the data is always laid out the same, record a macro when you do it
manually. Then rerun that macro when you need to do it again.

You may not need to tweak the code, but if you do, post back and I'm sure
someone will help.