I would like to align some entries in consecutive rows but can't see to do it
in Excel. I would like to be able to use an equivalent of the MS Word tabs
such that all entries are perfectly aligned in rows. Please help.

Thanks.

Depending on your data, one workaround is to use a custom format of
" "@
to force a set amount of spaces before your text, or you can use helper
columns with a formula similar to:
=REPT(" ",8)&A2
or
=A2&REPT(" ",8)

to force set indentation amounts.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jay" wrote:

I would like to align some entries in consecutive rows but can't see to do it
in Excel. I would like to be able to use an equivalent of the MS Word tabs
such that all entries are perfectly aligned in rows. Please help.

Thanks.

Hi Luke,

Thanks for the prompt response. Just trying to figure out how exactly I
would apply your suggestion. Do I put it under "custom" under format cell?
Sorry, not really an Excel user here. I also have Excel 2000 if that makes a
difference.

Thanks.

Jay

"Luke M" wrote:

Depending on your data, one workaround is to use a custom format of
" "@
to force a set amount of spaces before your text, or you can use helper
columns with a formula similar to:
=REPT(" ",8)&A2
or
=A2&REPT(" ",8)

to force set indentation amounts.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jay" wrote:

I would like to align some entries in consecutive rows but can't see to do it
in Excel. I would like to be able to use an equivalent of the MS Word tabs
such that all entries are perfectly aligned in rows. Please help.

Thanks.

If you're using the custom number format suggestion:
Select the range
Format|Cells|number tab|Custom category and type the custom format into that
Type box.

Jay wrote:

Hi Luke,

Thanks for the prompt response. Just trying to figure out how exactly I
would apply your suggestion. Do I put it under "custom" under format cell?
Sorry, not really an Excel user here. I also have Excel 2000 if that makes a
difference.

Thanks.

Jay

"Luke M" wrote:

Depending on your data, one workaround is to use a custom format of
" "@
to force a set amount of spaces before your text, or you can use helper
columns with a formula similar to:
=REPT(" ",8)&A2
or
=A2&REPT(" ",8)

to force set indentation amounts.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jay" wrote:

I would like to align some entries in consecutive rows but can't see to do it
in Excel. I would like to be able to use an equivalent of the MS Word tabs
such that all entries are perfectly aligned in rows. Please help.

Thanks.

--

Dave Peterson