I want to align some entries in consecutive rows like Word tabs
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.
|