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

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?

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

You can select multiple columns the normal Windows method of click then
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 whilst
doing this, then use the macro for future selections.

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

Hope this helps

--


hopeful Wrote:
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
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=535171

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

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.

hopeful wrote:

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?

--

Dave Peterson