how could I indent numbers in Excel?

S

silviah

I would like to indent numbers in a table in Excel. Is that possible and how?

I would like to have 1 .......
2................
3..............
4..............., etc
Is there a formula for it?
 
D

Dave Peterson

You can use alt-enters to force new lines in a cell. Then you can use space
characters to pad the left hand side.

If your list is in separate cells, you could put the number of characters to
indent in a helper column and use another helper column for display:

=rept(" ",a1)&b1

There is one more option. You can indent each cell using Format|cell|alignment
tab. That's either a manual effort or some sort of macro with you specifying
the number of characters to indent (another helper column???).

=====
Excel really doesn't make a very good word processor. Maybe putting the list in
MSWord and using its outlining features would be better????
 
Top