Thread: Excel
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
eve eve is offline
external usenet poster
 
Posts: 23
Default Excel

Hi Mike,

thanks for replying. however I can't find Drawing anywhere, even in View. I
must confess i'm a bit of an Excel virgin LOL. What now?

Eve

"Mike H" wrote:

Eve,

Ensure the Drawing toolbar is visible using

View|Toolbars - Drawing

Click one of your shapes and drag it where you want it and then while
holding down the CTRL key click other that you want to align to select them
all. Then on the drawing toolbar click the small down arrow anf then

Align or distribute - Align left and your shapes will all line up perfectly.

Mike



"eve" wrote:

I am creating a worksheet in which I need to have a series of three circles
of the same shape and size beside the text I am using, as sort of a multiple
choice checklist. I have inserted the three circles into each individual
cell, but instead of trying feverishly to line them up as best as I can by
dragging them to the ideal destination, I would like to format them somehow
to line up perfectly with each set below the previous one in each row. I hope
that makes sense......HELP !