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
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,
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.