View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default One-click hiding/unhiding of many non-adjacent columns/rows?

Glad I could help

"Jeff Wow" wrote:

Thanks, that did the trick.

Jeff

"Mike H" wrote:

Hi,

Record a macro of yourself doing it then assign a shortcut to the macro.

Mike

"Jeff Wow" wrote:

Is it possible to set up a spreadsheet so that with one click you can
hide/unhide a large number of rows or columns? I have a complex spreadsheet
in which I have to regularly hide about half of the columns (interspersed
with the cols remaining visible, of course, not one big adjacent set of cols)
to make a weekly report for a customer.