formatting my cells

D

DKY

I'm trying to insert the following information into a spreadsheet
MASTER BATH------:
Tub--------------------:
Tub faucet------------:
Waste/Overflow-----:
Shower Base--------:
Shower faucet-------:
Lav Bowl-------------:
Lav Faucet-----------:
Stop/Supplies--------:
W/Closet--------------:
W/Closet stop--------:
T/Lever---------------:
Click to expand...

and I need to somehow format my cells in such a way that my text i
left justified and my dashes are right justified but at the same tim
my dashes are near my text. The problem is that some of these don'
line up for some reason I'll put a dash or remove a dash to line the
up with each other but it seems like their off by half a dash at som
points. Any ideas on how I can do this
 
R

Ron Coderre

If you use a Fixed Font instead of a Proportional Font your text shoul
line up correctly. A Fixed Font uses the same amount of space for eac
character. A Proportional Font self adjusts spacing to account for th
visual mass of characters relative to their neighbors.

Examples:
Courier New is a fixed font
Arial is a proportional font

Does that help?

Regards,
Ro
 
R

Ron Coderre

Without knowing what fonts you have....try this:

Put the same text in each cell in a column.
Example:
A1: aaaAAAXXXXXX123
A2: a-------------a

Format A1 and A2 with the Courier New font (as a baseline)
(Both cells should appear to be the same length since both contain 15
characters.)

Copy those pairs down for several cells
Format each other pair with a font you're interested in using.

It should be come fairly apparent which are Fixed Font or not.

Does that help?

Regards,
Ron
 
R

Ragdyer

How about trying a custom format that will *automatically* fill the
remaining spaces of your cell (after entering text) with the character that
follows the asterisk?

This would be for your request of a dash:

;;;@*-

OR, to fill with an asterisk:

;;;@**
 
Top