Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
jocapo
 
Posts: n/a
Default Is there a keystroke shortcut to Group and Outline in Excel?


  #2   Report Post  
Posted to microsoft.public.excel.misc
Bryan Hessey
 
Posts: n/a
Default Is there a keystroke shortcut to Group and Outline in Excel?


Do you mean a range of cells or a group of shapes?

To outline a range of cells, rightmouse, Format Cells, and set a
Border. To group a range of cells, Insert, Name, Define, and assign a
group name.

To group a set of shapes, CTRL / select all shapes required, then
rightmouse, Grouping, Group.
The only method I know of to outline a group of shapes is to draw a
square shape of correct size, set Transparency to 100%, Send to Back,
and select it with the other shapes to Group.

Does this help?

oh, the answer to your original question was 'no'

--

jocapo Wrote:



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=534322

  #3   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default Is there a keystroke shortcut to Group and Outline in Excel?


Is this what you're looking for?:

Select entire Rows or Columns to be grouped
Then
Hold down the [Shift] and [Alt] keys and press either:
Right Arrow to demote the row/column
or
Left Arrow to promote the row/column

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=534322

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
Sheet protection and "Group and Outline" OkieViking Excel Discussion (Misc queries) 9 May 22nd 07 05:17 PM
Group & Outline and Recalculation BrianH Excel Discussion (Misc queries) 3 April 20th 06 09:19 AM
Group and Outline Settings -Problem Courtney Excel Discussion (Misc queries) 0 April 10th 06 10:00 PM
How to Use Group and Outline function when locked sheet Denis Excel Worksheet Functions 0 July 22nd 05 04:18 PM
Can't group pivot table items by month in Excel scott_ensley Excel Discussion (Misc queries) 1 February 1st 05 09:41 PM


All times are GMT +1. The time now is 10:17 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"