How do I extend a underline across an entire cell?

When working on a financial statement, I was curious how to 1. Have a line
extend across an entire cell even if the number is only 2-3 digits and 2. How
to apply a double line under a number without using the = sign in the
following cell?

Select the cell you want to have underlined and go to: "Format->Cells" and choose the "Border Tab."

On the righthand side, choose the style of line you would like. On the left where the big white box is (it says "Text" in the middle), click the bottom to have that border style run across the entire bottom of the cell. Click "OK"

Hi Lindsay

Look on the formatting toolbar for Borders

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Lindsay" <[email protected]> wrote in message news:[email protected]...
> When working on a financial statement, I was curious how to 1. Have a line
> extend across an entire cell even if the number is only 2-3 digits and 2. How
> to apply a double line under a number without using the = sign in the
> following cell?

One way would be to use the cell
borders".....

Select the cell, Right-click > FormatCells > BorderTab > select either a
single or double "Style", color, and location.......

Vaya con Dios,
Chuck, CABGx3



"Lindsay" wrote:

> When working on a financial statement, I was curious how to 1. Have a line
> extend across an entire cell even if the number is only 2-3 digits and 2. How
> to apply a double line under a number without using the = sign in the
> following cell?

Look at Format -> Cells -> Borders.

"Lindsay" wrote:

> When working on a financial statement, I was curious how to 1. Have a line
> extend across an entire cell even if the number is only 2-3 digits and 2. How
> to apply a double line under a number without using the = sign in the
> following cell?

to apply either a single or a double line to an entire cell, use the Borders
button on your formatting toolbar...select the desired cell first, then click
on the Borders button, then click on the desired type of line you want to
apply to that cell or cells

gina

"Lindsay" wrote:

> When working on a financial statement, I was curious how to 1. Have a line
> extend across an entire cell even if the number is only 2-3 digits and 2. How
> to apply a double line under a number without using the = sign in the
> following cell?

Click on Format > Cells > Boarder

There you will find that you can apply a double line to the bottom of a
cell. That will display the double line under a number.
Also you can use a boarder to have a line extend across cells.

Hope this helps.
Michael S.

"Lindsay" wrote:

> When working on a financial statement, I was curious how to 1. Have a line
> extend across an entire cell even if the number is only 2-3 digits and 2. How
> to apply a double line under a number without using the = sign in the
> following cell?

Hello-

I think everything you are seeking can be found in Format>Cells>Border.

HTH |:>)

"Lindsay" wrote:

> When working on a financial statement, I was curious how to 1. Have a line
> extend across an entire cell even if the number is only 2-3 digits and 2. How
> to apply a double line under a number without using the = sign in the
> following cell?

I have a situation where I am creating a form that has a text field area to be filled in. The form needs to be set up so that text may be typed in or the page printed blank and the info written in by hand.

I need the field to have about 4 lines (as in drawn straight black lines) so that when printed out, a person can write on them by hand. I also, however, want to be able to type on these lines. Currently my solution is to have 4 cells stacked on top of each other with the bottom border of each cell turned on. This works, but it is annoying to have to tab down to each cell while typing in information (especially when going back and making corrections). I would ideally want to have the lines within ONE cell with word wrap turned on so that I could just type away and have it wrap without worrying about tabbing. However, I need to have drawn straight lines there.

An alteranative (and probably better approach) is finding a way of setting a different default overflow cell. By default, excel overflows data from one cell to the adjacent cell. Is it possible to set the overflow cell to be the cell below it?


Thanks in advance.

I know this is an age old thread, but it came up high on my search results, so I thought it would be worth updating with my findings.

Yes, accounting format will enable you to underline a whole cell, but how? Essentially it does it by filling the cell with spaces. We can do this manually by applying a custom format to the cell. Before the number (i.e., 0 or #), we put "* ". The * means repeat the next character (space) until the cell is full. This gives us the intended effect. So try "* #".

The accounting format includes this:

Please Login or Register  to view this content.

Of course the better and more common way is to just apply a border to the bottom of the cell (preferably to the top of the summing cell).