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?

Hi Lindsay

Look on the formatting toolbar for Borders

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


"Lindsay" wrote in message ...
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"


--
carlyman
------------------------------------------------------------------------
carlyman's Profile: http://www.excelforum.com/member.php...o&userid=22440
View this thread: http://www.excelforum.com/showthread...hreadid=379743

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 FormatCellsBorder.

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.


--
postitnote100
------------------------------------------------------------------------
postitnote100's Profile: http://www.excelforum.com/member.php...o&userid=24585
View this thread: http://www.excelforum.com/showthread...hreadid=379743