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

[Ike]

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.

 

[Harlan Grove]

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.

 

[GSalisbury]

Ike wrote...

Not possible.

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


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.

 

[Bill Sharpe]

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