| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unhiding and hiding rows | Excel Discussion (Misc queries) | |||
| Hiding/unhiding rows | Excel Discussion (Misc queries) | |||
| Hiding/Unhiding Columns | Excel Worksheet Functions | |||
| Hiding/Unhiding Columns | Excel Worksheet Functions | |||
| hiding/unhiding rows & columns with "+" and "-" buttons | Excel Discussion (Misc queries) | |||
Linear Mode
