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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to select data in non adjacent rows of a column automatically 5
Hiding / Unhiding Sheets 1
Run-time error 1004 while conditionally hiding rows as a result ofworksheet protection 2
Printing: fit to 1 page 2
I cannot delete the extra rows or columns in Excel 2007 2
Enabling option „Format rows“ to hide/unhide rows using VBA-code? 0
Hiding and Unhiding Rows.. Unhide does not work.. 3
Freeze multiple rows/columns in Excel 2007 7

Top