View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
wjohnson
 
Posts: n/a
Default shortcut for expanding/collapsing groups


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