I want to align some entries in consecutive rows like Word tabs

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

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.
 
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
 
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.
 
Back
Top