View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
jfg jfg is offline
external usenet poster
 
Posts: 44
Default Centering a picture in a worksheet

Thank you, Debra. Your response is exactly what I was looking for.

The very best to you,

jfg

"Debra Dalgleish" wrote:

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