Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding columns without usimg a macro
Is there a way of hiding columns with a single button, without using macros.
If I want to enter data about apples, only columns 2-6 need completing so 7 - 12 can be hidden. If I want to enter data on oranges then 7 - 12 need to be visible but 2-6 can be hidden. I was thinking of something I could click to hide, unhide a set number of columns. I remember seeing a spreadsheet that appeared to use sub totals along the columns which appeared to hide & unhide the columns when selected. Any thoughts. Thanks Mick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Split Window in Same Place Even If Columns Added or Hidde | Excel Discussion (Misc queries) | |||
"Text to Columns" for many columns in Excel 2003 | Excel Discussion (Misc queries) | |||
format macro | Excel Discussion (Misc queries) | |||
macro to hide columns | Excel Worksheet Functions | |||
Hiding Columns | Excel Discussion (Misc queries) |