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