Trivial Excel Problem

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

sliderule

Thread Starter
Joined
Aug 28, 2001
Messages
160
This will seem trivial to most of you, but I'm a style/appearance freak with regard to documents. Having barred my soul, here's my problem. I have a column of numbers, some in the six digit range and some mere single digits. I want the underscore of the bottom number (in the cell above the sum) to be as wide as the largest number in the column - purely for looks. If the bottom number is, say, a single digit, Excel just puts an underscore under that single digit and it ain't purdy. Any advice will be appreciated.
 
Joined
Oct 29, 2001
Messages
2,056
try putting the top border line in the sum cell instead of the one above it
although it sounds like you're using the underline feature - because a bottom border line in the last number cell (the one above the sum) should work equally as well
 
Joined
Aug 30, 2003
Messages
2,702
>> If the bottom number is ... a single digit, Excel
>> just puts an underscore under that

I believe that's pretty much how it works. jbcalg's "borderline" solution is recommended.

If you have "123456" in A1 and "789" in A2, you can turn font underline on for A2 and amend the content of the cell to

=" "&789

or something similar to kludge it (that's mutiple spaces, it just doesn't show up that way in here). But then =SUM(A1:A2) falls over. You'd have to use =A1+A2 instead. So I wouldn't recommend that at all, probably.

Rgds,
Andy
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top