how do you group and ungroup rows or columns in new Excel?
how do you group and ungroup rows or columns in new Excel?
|
On the menu:
Data - Group & Outline - Group (or Ungroup) You can add buttons to a toolbar to do the same thing: View - Toolbars - Customize Click the Commands tab Click 'Data' in the left window In the right window, scroll down to the Group button and drag it to a toolbar. Do the same with the Ungroup button. "moocowcreamer" wrote: how do you group and ungroup rows or columns in new Excel? |
OR
<Shift <Alt <RightArrow to group, AND <Shift <Alt <LeftArrow to ungroup. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "George King" wrote in message ... On the menu: Data - Group & Outline - Group (or Ungroup) You can add buttons to a toolbar to do the same thing: View - Toolbars - Customize Click the Commands tab Click 'Data' in the left window In the right window, scroll down to the Group button and drag it to a toolbar. Do the same with the Ungroup button. "moocowcreamer" wrote: how do you group and ungroup rows or columns in new Excel? |
All times are GMT +1. The time now is 03:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com