ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   IS there any short cut key to select all shapes (https://www.excelbanter.com/excel-programming/436792-there-any-short-cut-key-select-all-shapes.html)

Max

IS there any short cut key to select all shapes
 
Hi,
In powerpoint if we need to select shapes we do cntrl+A or we drag the
cursor so that shapes are selected
In excel if i am using shapes what is the command to select all shapes at
once,else i need to go to each one and select holding shift.
Thanks
max

Jacob Skaria

IS there any short cut key to select all shapes
 
Try

Press F5 and select 'Special' and select 'Objects' OK


If this post helps click Yes
---------------
Jacob Skaria


"max" wrote:

Hi,
In powerpoint if we need to select shapes we do cntrl+A or we drag the
cursor so that shapes are selected
In excel if i am using shapes what is the command to select all shapes at
once,else i need to go to each one and select holding shift.
Thanks
max


Jacob Skaria

IS there any short cut key to select all shapes
 
If you mean to select using code try

Activesheet.Shapes.SelectAll

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Try

Press F5 and select 'Special' and select 'Objects' OK


If this post helps click Yes
---------------
Jacob Skaria


"max" wrote:

Hi,
In powerpoint if we need to select shapes we do cntrl+A or we drag the
cursor so that shapes are selected
In excel if i am using shapes what is the command to select all shapes at
once,else i need to go to each one and select holding shift.
Thanks
max



All times are GMT +1. The time now is 02:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com