View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Centering a picture in a worksheet

Using the rectangle tool on the Drawing toolbar, draw a rectangle that
goes from the left of column A, to the right of column C. Hold the Alt
key, while you draw it, and it will snap to the shape of the cells.

Then, select both your picture and the rectangle.
On the Drawing toolbar, click the Draw button
Click Align or Distribute Align Center

Then, delete the rectangle.

jfg wrote:
Hi,

I have Excel 2003. I have a picture spanning A1:B21. I would like to center
the picture between columns A and C. Is there a way of doing this other than
just eyeballing where the picture should be, approximately, and moving it
there with the mouse.

Thanks for any help you can give me.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html