View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hopeful
 
Posts: n/a
Default 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?