Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I extend underline across a whole cell w/o using the border
I am trying to figure out how to extend an underline across a whole cell
without using the border. I have cells that have it done, but when I try to change the information in them, it reduces the underline to just the text in the cell. |
#2
|
|||
|
|||
Try using single or double*accounting* underline.
Funny thing about this is, although it's called accounting, if you enter a number in the cell, the underline does *not* extend the full width of the cell. Text will make it go the full width. Also, entering a number with an apostrophe prefix, or *pre-formatting* the cell to Text, will allow it to fill the entire width when using numbers. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "R Morgan" <R wrote in message ... I am trying to figure out how to extend an underline across a whole cell without using the border. I have cells that have it done, but when I try to change the information in them, it reduces the underline to just the text in the cell. |
#3
|
|||
|
|||
RagDyer wrote
Try using single or double*accounting* underline. Funny thing about this is, although it's called accounting, if you enter a number in the cell, the underline does *not* extend the full width of the cell. Text will make it go the full width. Also, entering a number with an apostrophe prefix, or *pre-formatting* the cell to Text, will allow it to fill the entire width when using numbers. I've found, in XL2K at least, that accounting underlines do not extend the *full* width of the cell. -- David |
#4
|
|||
|
|||
The apostrophe combined with the single accounting underline did the trick.
Thank you very much. |
#5
|
|||
|
|||
R.Morgan,
Appreiate the feed-back David, In the 3 versions that I have access to: XL97 - XL2k - XL02 All work *exactly* the same way as I posted above! -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit! ------------------------------------------------------------------- "R Morgan" wrote in message ... The apostrophe combined with the single accounting underline did the trick. Thank you very much. |
#6
|
|||
|
|||
RagDyer wrote
David, In the 3 versions that I have access to: XL97 - XL2k - XL02 All work *exactly* the same way as I posted above! Hmm.., maybe I don't follow your definition of 'entire width'. I see a small gap left and right of the underline that doesn't meet the cell gridline. And if I format several cells in the same row, the underline is broken between entries no matter what I do. Ex: I type '22 in A1, format font underline as single accounting, drag-fill to G1, underline is not continuous, i.e., broken between cells. And... row height increases from 12.75 to 15.00. Oh, well, I was just curious about new ways to make things look the way I want. No bigee. -- David |
#7
|
|||
|
|||
Yes, your definition of "entire width" *doesn't* match my definition, *OR*
the OP's either, for that matter. You're odd man out.<bg -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "David" wrote in message ... RagDyer wrote David, In the 3 versions that I have access to: XL97 - XL2k - XL02 All work *exactly* the same way as I posted above! Hmm.., maybe I don't follow your definition of 'entire width'. I see a small gap left and right of the underline that doesn't meet the cell gridline. And if I format several cells in the same row, the underline is broken between entries no matter what I do. Ex: I type '22 in A1, format font underline as single accounting, drag-fill to G1, underline is not continuous, i.e., broken between cells. And... row height increases from 12.75 to 15.00. Oh, well, I was just curious about new ways to make things look the way I want. No bigee. -- David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
Can I use the contents of a cell to satisfy the result_vector arg. | Excel Worksheet Functions | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Excel - option to extend function in cell to column | Excel Worksheet Functions |