One-click hiding/unhiding of many non-adjacent columns/rows?

J

Jeff Wow

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.
 
M

Mike H

Hi,

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

Mike
 
Top