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?
|