How to add text above cells?

[Uncle Max]

Excel 2010

I would like to use the numbers down the left side as days of the month.

I would like to add descriptions (Of operations) above the cells.

I would like to add a descriptive title header above everything. (Operations performed for the month x)

When someone opens the SS, I would like the information to be in view, rather than when it’s printed out only.

I am told this cannot be done.

I refuse to believe that.

 

[Gord Dibben]

You cannot change the column titles from A, B, C etc.

If you want titles in view, you must use the cells of row 1 and freeze that row
in view.

The row numbers also cannot be changed.

Use column A cells for days of the month by typing a date in A2.

In A3 enter =A2+1

Drag/copy that down as far as you wish.


Gord Dibben MS Excel MVP

 

[Uncle Max]

Thanks for the response.

Since it was a "data" table with nothing to do with numbers, I made a table
in Word and that worked our fine.



---------------------------------------------------------------------------------------------------------------

"Gord Dibben" wrote in message

You cannot change the column titles from A, B, C etc.

If you want titles in view, you must use the cells of row 1 and freeze that
row
in view.

The row numbers also cannot be changed.

Use column A cells for days of the month by typing a date in A2.

In A3 enter =A2+1

Drag/copy that down as far as you wish.


Gord Dibben MS Excel MVP

 

[WallyWallWhackr]

Excel 2010

I would like to use the numbers down the left side as days of the month.

I would like to add descriptions (Of operations) above the cells.

I would like to add a descriptive title header above everything. (Operations performed for the month x)

When someone opens the SS, I would like the information to be in view, rather than when it’s printed out only.

I am told this cannot be done.

I refuse to believe that.

Take a look at my time tracking workbook.
PS: The blood pressure and ESD workbooks are nice too.

It has fields that fill in based on data you place in other cells.

I know it does not directly address you column and row naming issue,
but when you turn off the row and column and grid, you see only the names
you have given any specific row or column.

http://office.microsoft.com/en-us/t...-expenditure-log-job-tracker-TC030008309.aspx