Justifying Text in a cell

  • Thread starter Dave Bennett, JSF, VDOT, Virginia
  • Start date
D

Dave Bennett, JSF, VDOT, Virginia

I am trying to figure out how to do an unusual justification of text in a
cell.

I have a personnel roster that lists an employee's name and employee number
in the same cell; the boss wants it this way so I can not seperate the name
and employee number.

I want to have the empoyee name justified to the left border of the cell and
the employee number justified to the right border of the cell, so that when
the sheet is printed, everything lines up nice and neat.

Is there a way to do this in Excell? I know that in Word, you can do this,
but I can not figure it out in excel.

Any information anyone can provide is greatly appreciated.
 
S

Sheeloo

The only thing I can think of is inserting enough blanks between the name and
the number to total up to the cell width
 
D

Dave Bennett, JSF, VDOT, Virginia

I initially tried that, but most fonts do not have an even character spacing
i.e. the default Times New Roman, so the employee numbers do not align
correctly on the right hand side.

The ones that do have even characte rspacing i.e. courrier new, lucendia
typewriter, overflow the cell size, or have to be sized so small that reading
is difficult when printed. I can't adjust the cell size, or I would do that.
I also can not think of any other even spaced fonts that will be of an
easily readable size.

Thanks for the reply.
 
N

nr

I have a personnel roster that lists an employee's name and employee number
Two suggestions:
1) Get a new boss!
2) For your printing, create two additional columns, one with the
name, the other with the employee number. You could hide them when
not printing, or delete after the printing.
 
S

SU123

you can try this. Format the cell to be fully justifyied and after you have
typed in your info press alt+enter, that should work

i.e. format - justified
A Smith 1234 '[atl enter] enter
 
S

Sheeloo

SU123 - Great idea, thanks. It works great if you have two entries in the
cell...
Dave - Hiding the extra columns after printing is also a good idea. You can
record a MACRO to hide/unhide and print to save effort. Also you should
convince your boss. He might have some concern which you need to address. He
is probably concerned with employee name, by mistake, getting associated with
wrong id in case you add or delete a cell


SU123 said:
you can try this. Format the cell to be fully justifyied and after you have
typed in your info press alt+enter, that should work

i.e. format - justified
A Smith 1234 '[atl enter] enter


Dave Bennett said:
I am trying to figure out how to do an unusual justification of text in a
cell.

I have a personnel roster that lists an employee's name and employee number
in the same cell; the boss wants it this way so I can not seperate the name
and employee number.

I want to have the empoyee name justified to the left border of the cell and
the employee number justified to the right border of the cell, so that when
the sheet is printed, everything lines up nice and neat.

Is there a way to do this in Excell? I know that in Word, you can do this,
but I can not figure it out in excel.

Any information anyone can provide is greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top