View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default how could I indent numbers in Excel?

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????

silviah wrote:

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?


--

Dave Peterson