Is there a keystroke shortcut to Group and Outline in Excel?
 

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

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