One-click hide or unhide rows & columns

  • Thread starter Thread starter Togowa
  • Start date Start date
T

Togowa

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?
 
Togowa said:
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?
Click to expand...

Try Data > Group and Outline


---
 
Only if you had your data grouped under Data>Group 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
 
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?
Click to expand...

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,
 
Back
Top