Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to auto hide and unhide columns using 1 and 2 icons
While working on a worksheet some of the columns set into auto hide and
unhide mode. Columns can be hidden or unhidden through 1 and 2 icons. Please explain the procedure to set such functions. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to auto hide and unhide columns using 1 and 2 icons
You should be able to record macros that will hide (or unhide) the currently
selected column. Then you can create icons for your new macros and place them on your toolbar. If you're looking for something more automated, that hides columns based on some values, you'll have to create a more complex macro that evaluates each column in the active sheet and then hides it (or not). If you could tell me more about what you're doing, perhaps post your file, I could probably help. -- -David D "R. Rebello" wrote: While working on a worksheet some of the columns set into auto hide and unhide mode. Columns can be hidden or unhidden through 1 and 2 icons. Please explain the procedure to set such functions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide / Unhide columns and rows | Excel Discussion (Misc queries) | |||
How do I hide and unhide the same columns without reselecting | Excel Worksheet Functions | |||
How to hide and unhide Rows & Columns | Excel Worksheet Functions | |||
Hide Unhide Hide again | New Users to Excel | |||
Excel 2002 Unhide Columns Shortcut?? | Excel Discussion (Misc queries) |