Is there a shortcut to expand and collapse groups of rows or columns (the +/-
grouping sets that can be made)?
Thx.
--
Boris
Is there a shortcut to expand and collapse groups of rows or columns (the +/-
grouping sets that can be made)?
Thx.
--
Boris
Hide/collapse the rows and columns you don't want displayed - then go to the "Views" then Select "Custom Views" - then select ADD - give the view a name and then each time you select that view it will happen automatically.
You might make a "Custom View" and call it "ALL" before you start "hideing rows and columns - then you can easily get back to the full view of the spreadsheet.
well the quick collapse/expand is easy enough for me with the numbered level
buttons that show up in the upper left. I was actually talking about being
on any given row or column and being able to say expand/collapse with one
keystroke, as opposed to having to take off my hands from the keyboard (I
work very quickly with keys in Excel) and use the mouse to go over to the
left/top and have to click open/close the groupings.
--
Boris
"wjohnson" wrote:
>
> Hide/collapse the rows and columns you don't want displayed - then go to
> the "Views" then Select "Custom Views" - then select ADD - give the view
> a name and then each time you select that view it will happen
> automatically.
> You might make a "Custom View" and call it "ALL" before you start
> "hideing rows and columns - then you can easily get back to the full
> view of the spreadsheet.
>
>
> --
> wjohnson
> ------------------------------------------------------------------------
> wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
> View this thread: http://www.excelforum.com/showthread...hreadid=495416
>
>
The original post was years ago, but searching for this solution still brings up this post, so here is the updated solution for anyone still searching.
In Excel 2010, the Alt shortcut keys would be Alt+AH to hide grouped details, and Alt+AJ to show details.
Alt + A + J to Expand
Alt + A + H to collapse
Alt + A + J to Expand
Alt + A + H to collapse
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks