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

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.

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

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.

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

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.

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.

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

That did it, thanks.

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