Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
moocowcreamer
 
Posts: n/a
Default how do you group and ungroup rows or columns in new Excel?

how do you group and ungroup rows or columns in new Excel?
  #2   Report Post  
George King
 
Posts: n/a
Default

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?

  #3   Report Post  
RagDyer
 
Posts: n/a
Default

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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HELP! How do you--> Lock a set of rows but also link worksheets to FRUSTRATED Excel Discussion (Misc queries) 6 December 29th 04 10:05 PM


All times are GMT +1. The time now is 03:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"