If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
shortcut for expanding/collapsing groups
Is there a shortcut to expand and collapse groups of rows or columns (the +/-
grouping sets that can be made)? Thx. -- Boris |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
shortcut for expanding/collapsing groups
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
disable Show in Groups | Deckard | General Discussion | 1 | September 1st, 2004 01:49 PM |
Office 2003 / Office XP Shortcut Bar | Marc Bressman | Setup, Installing & Configuration | 6 | June 26th, 2004 08:42 AM |
Office 2003 / Office XP Shortcut Bar | Marc Bressman | General Discussions | 6 | June 26th, 2004 08:42 AM |