Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
One-click hide or unhide rows & columns
Is there a way to hide or unhide rows and colums with a one-click feature
like the plus or minus sign that opens folders in a directory? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
One-click hide or unhide rows & columns
"Togowa" wrote:
Is there a way to hide or unhide rows and colums with a one-click feature like the plus or minus sign that opens folders in a directory? Try Data Group and Outline -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
One-click hide or unhide rows & columns
Only if you had your data grouped under DataGroup and Outline.
Otherwise CTRL + 9 hides selected rows. CTRL + SHIFT + ( unhides rows CTRL + 0 and CTRL + SHIFT + ) for columns A one click faeture would be a toggle macro assigned to a button. Sub togglethings() Selection.EntireRow.Hidden = Not Selection.EntireRow.Hidden ' Selection.EntireColumn.Hidden = Not Selection.EntireColumn.Hidden End Sub Gord Dibben MS Excel MVP On Sat, 22 Mar 2008 15:08:01 -0700, Togowa wrote: Is there a way to hide or unhide rows and colums with a one-click feature like the plus or minus sign that opens folders in a directory? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
One-click hide or unhide rows & columns
On Saturday, March 22, 2008 6:08:01 PM UTC-4, Togowa wrote:
Is there a way to hide or unhide rows and colums with a one-click feature like the plus or minus sign that opens folders in a directory? Group and Ungroup columns 1. Highlight Columns that are side by side. 2. In the Data tab, in the Outline group, click the group icon, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide / Unhide columns and rows | Excel Discussion (Misc queries) | |||
Hide/Unhide columns using button on top over relevant columns | Excel Discussion (Misc queries) | |||
Unhide rows when you click a cell | Excel Discussion (Misc queries) | |||
How to hide and unhide Rows & Columns | Excel Worksheet Functions | |||
How do I hide or unhide zero value columns/rows USING A MACRO? | Excel Discussion (Misc queries) |