AutoShape Positioning?

K

Ken

Excel 2000 ... I have a spread sheet created by a co-
worker which contains (perhaps 60) AutoShapes. The
AutoShape's Properties - Object Positioning is set
to "Move & Size with Cells" ... I wish this to be "Do Not
Move or Size with Cells".

Above said ... is there a way to globally accomplish this
for all 60 AutoShapes or must each AutoShape be selected &
set independently?

Please tell me there is a global way ... Thanks ... Kha
 
C

cdb

If you press Ctrl and Shift you can then click on each one and add it to the
selection, then you will only have to change the properties once (although
the clicking may be a bit time consuming it should still be quicker)
 
D

Dave Peterson

There's an arrow icon on the Drawing toolbar that'll let you lasso as many
shapes as you can see, too.

Shrink the zoom to as small as possible and maybe get lots more!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top