You're welcome, and thank you for the feed-back.

BTW ... In case you hadn't noticed, the cell is not limited to a single
character.

You could just as well have entered
<space-
Or anything else at all.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Edward Letendre" wrote in
message ...
The fill worked perfectly. That is the way it should look. I guess the
programmers of excel have never worked with the older spreadsheets like
quattro pro and lotus 123. Your tip was exactly what I was looking for.
Thank you very much.

Edward Letendre

"Ragdyer" wrote:

Another option is format using "Fill".

<Format <Cells <Alignment tab,
Expand the "Horizontal" box and click on <Fill, then <OK.

Now, any character entered into that cell will fill the cell from border
to
border.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
How about using the borders format to give that last cell (the one with
the 1
in it) a line as its lower edge? There is a one-click way to do that.

In the formatting toolbar, about the 3rd icon from the right end is
Borders
pull down. By default it is set to make the lower edge of a cell a
single
line. Choose the cell then click the Borders icon and you get a bottom
edge
line.

If you don't see the formatting toolbar, use View | Toolbars and choose
the
Formatting from the list.

If you specifically want dashed line for the bottom edge, choose the
cell
then use Format | Cells and set things up the way you want using the
Borders
tab of the dialog that appears. After you've set up the format of a
cell
the
way you want, you don't have to go through the whole Format | Cells and
use
of the Borders tab again - you can click a cell that is formatted the
way
you
want and then click the Format Painter (looks like a paint brush and is
in
the standard toolbar just to the left of the UNDO icon) and then click
on
the
cell that you want formatted like the first one - the formatting of the
first
will be applied to the second one also.

"Edward Letendre" wrote:

Actually I was just referring to the dashes or "-" that would fill the
cell
above the sum function. In my case, cells A1 to A5 would have the
numbers in
them, cell A6 would have the - filled to the width of the cell and
cell
A7
would have the sum total of cells A1 to A5. Thus what I need to know
is
how
do you format cell A6 so that it is full of dashes or"-" to show that
it
is
the end of the numbers and the sum value is below this cell. Help me
if
you
can.

Edward Letendre

"JLatham" wrote:

I believe what you're seeking is the Auto Sum feature. If you click
in an
empty cell at the bottom of a list of numbers like that, or even out
at one
end of a row of numbers, and click the Auto Sum icon and press
[Enter]
you'll
get a formula giving the total of those numbers in the cell.

The Auto Sum icon looks like the Greek letter Sigma, which is like a
capital
M turned on edge, or a capital E with a bent edge on the left.

"Edward Letendre" wrote:

In other spreadsheet programs, you would create a spreadsheet with
the
following information, row by row

21
10
15
15
1

then you would request a sum of the rows and wth some formatting
it
would
look like this:

21
10
15
15
1
--
62

where the - is, you would use \- and press enter to fill the
single
cell.

Can this be done in any and or all versions of excel and how is
this
done.