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 !

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 !

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 !

Hi,

I assume your on Excel 2003 if so click

View|Toolbars and select the 'Drawing toolbar' which normally appears at the
bottom of the excel window. Select your shapes as I described then look for
the word 'Draw' on the toolbar and to the right of that you'll see a down
arrow. Click it and in the popup click

Align or Distribute - Align left

Mike

"eve" wrote:

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 !

I apologize, I should have specified that I am using Excel 2007 .There is a
View tab, but no drawing feature.

"Mike H" wrote:

Hi,

I assume your on Excel 2003 if so click

View|Toolbars and select the 'Drawing toolbar' which normally appears at the
bottom of the excel window. Select your shapes as I described then look for
the word 'Draw' on the toolbar and to the right of that you'll see a down
arrow. Click it and in the popup click

Align or Distribute - Align left

Mike

"eve" wrote:

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 !

InsertIllustrations CategoryShapes


Gord Dibben MS Excel MVP

On Thu, 12 Mar 2009 11:18:05 -0700, eve
wrote:

I apologize, I should have specified that I am using Excel 2007 .There is a
View tab, but no drawing feature.

"Mike H" wrote:

Hi,

I assume your on Excel 2003 if so click

View|Toolbars and select the 'Drawing toolbar' which normally appears at the
bottom of the excel window. Select your shapes as I described then look for
the word 'Draw' on the toolbar and to the right of that you'll see a down
arrow. Click it and in the popup click

Align or Distribute - Align left

Mike

"eve" wrote:

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 !