ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Double Underline / Bottom Border (https://www.excelbanter.com/excel-discussion-misc-queries/71363-double-underline-bottom-border.html)

Rose

Double Underline / Bottom Border
 
I have a person using Office 2003 and she has a small problem with excel.
The double underline produces only a single line. She can't use the double
accounting line with an apostrophe because the cells have formulas in them
and the cell is longer than the number and she wants the lines across the
whole cell. Is there any way to get a double line all the way across the
bottom of the cell even when the cell is larger than the number in it?

Thanks so much,
Rose

Kevin B

Double Underline / Bottom Border
 
Remove any border formatting in the cell and then, while the cell is still
selected, click on FORMAT in the menu and select CELLS. If necessary click
on the BORDERS tab.

In the box where you indicate where to place the line, click on the line
area below the word "Text" and in the Line Style panel, select the
double-underline format.

Click OK to exit.
--
Kevin Backmann


"Rose" wrote:

I have a person using Office 2003 and she has a small problem with excel.
The double underline produces only a single line. She can't use the double
accounting line with an apostrophe because the cells have formulas in them
and the cell is longer than the number and she wants the lines across the
whole cell. Is there any way to get a double line all the way across the
bottom of the cell even when the cell is larger than the number in it?

Thanks so much,
Rose



All times are GMT +1. The time now is 12:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com