How to put names over columns and left-justify numbers or align decimal points

I already have made the spreadsheet and want to put names over the columns
without making a new row for the names. Is this possible? Like I don't wantt
A1 B1 etc. to change to A2 B2 etc. when I put the text above the columns.
Then I want to save it as an .htm file so that the tables will have headings
like what I have put over the columns. The columns will have to get a little
wider to accommodate the headings over them. I need to left-justify the
numbers in the columns or line up the decimal points vertically. This is not
currency, if that matters.

Ike wrote...
>I already have made the spreadsheet and want to put names over the columns
>without making a new row for the names. Is this possible? Like I don't wantt
>A1 B1 etc. to change to A2 B2 etc. when I put the text above the columns.

Not possible.

If you want text above your current row 1 contents, you have to insert
a row above it.

>Then I want to save it as an .htm file so that the tables will have headings
>like what I have put over the columns. The columns will have to get a little
>wider to accommodate the headings over them. I need to left-justify the
>numbers in the columns or line up the decimal points vertically. This is not
>currency, if that matters.

As for decimal point alignment, in Excel itself you count use custom
number formats like

0.0???;-0.0???;0.0???

to provide decimal point alignment with 1 to 4 decimal places as
needed. But this doesn't seem to come through in Excel's HTML output
when using proportionally spaces typefaces.

"Harlan Grove" <[email protected]> wrote in message
news:[email protected]...
> Ike wrote...
> >I already have made the spreadsheet and want to put names over the
columns
> >without making a new row for the names. Is this possible? Like I don't
wantt
> >A1 B1 etc. to change to A2 B2 etc. when I put the text above the columns.
>
> Not possible.
>
> If you want text above your current row 1 contents, you have to insert
> a row above it.
>
> >Then I want to save it as an .htm file so that the tables will have
headings
> >like what I have put over the columns. The columns will have to get a
little
> >wider to accommodate the headings over them. I need to left-justify the
> >numbers in the columns or line up the decimal points vertically. This is
not
> >currency, if that matters.
>
> As for decimal point alignment, in Excel itself you count use custom
> number formats like
>
> 0.0???;-0.0???;0.0???
>
> to provide decimal point alignment with 1 to 4 decimal places as
> needed. But this doesn't seem to come through in Excel's HTML output
> when using proportionally spaces typefaces.
>
How about a text box from the Drawing Tool-Bar?
Primitive but could work without changing cell references.

Ike wrote:
> I already have made the spreadsheet and want to put names over the
> columns without making a new row for the names. Is this possible? Like I
> don't wantt A1 B1 etc. to change to A2 B2 etc. when I put the text above
> the columns. Then I want to save it as an .htm file so that the tables
> will have headings like what I have put over the columns. The columns
> will have to get a little wider to accommodate the headings over them. I
> need to left-justify the numbers in the columns or line up the decimal
> points vertically. This is not currency, if that matters.
You can hide the column and row headings, then put the heading you want
in Row 1. Still, your data will start in Row 2, although there will be
no row numbers on the left to indicate this. If you have more than a
screenful of data, you'll want to freeze the first row so that the
headers always display.

Bill