How do I extend a underline across an entire cell?

[Guest]

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?

 

[Ron de Bruin]

Hi Lindsay

Look on the formatting toolbar for Borders

 

[carlyman]

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"

 

[Guest]

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

 

[Guest]

Look at Format -> Cells -> Borders.

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

Hello-

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

HTH |:>)

 

[postitnote100]

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.