Title header excel

Generic
August 27, 2006 at 01:51:24
Specs: WinXP Pro SP2, P4-3.2/512


Hi all,
I would like to enter a name in the column header, Like change A 1 to show the word Date,
Is this possible?

Thanks in advace


Avagoodweekend......


See More: Title header excel

Report •


#1
August 27, 2006 at 10:33:38

Not too certain what you are trying to do exactly, but if you want to change a cells content based on a word in another cell a formula like this will work.

This would look at the contents on A1 and if it is "Change" then it will place the word Date in whatever cell you enter the formula, otherwise it would say No Date.

=IF(A1="Change","Date","No Date")

Hope this helps...


Report •

#2
August 28, 2006 at 05:02:35

hawk is right. Your question is confusing. I will take a shot as well though. :)

You can enter the word "Date" in the field A1 and use it as a column header, or you can create a Page Header that contains the date, or other items, or certain rows can be a header for each page.

Life is more painless for those who are brainless.


Report •

#3
August 28, 2006 at 06:16:16

Hi Jennifer,

<<You can enter the word "Date" in the field A1 and use it as a column header,>>

How do I change the name of the column as above so that A 1 will have a column header.

thanks for the respose and sorry I did not make myself clearer

Avagoodweekend......


Report •

Related Solutions

#4
August 28, 2006 at 08:53:13

So what you want to do is rename the Column Headings? A, B, C, etc? and/or the row numbers? If that's what you're asking, you can't do that. As I said, if you want to enter the word "Date" in cell A1, then just type it in the cell, but you can't rename the column and row headings in the way you can rename a sheet.

Life is more painless for those who are brainless.


Report •

#5
August 28, 2006 at 15:11:47

Thanks for that Jennifer, I will use the freeze frame feature.

Avagoodweekend......


Report •

#6
August 28, 2006 at 15:45:19

Now I'm thoroughly confused. LOL

Life is more painless for those who are brainless.


Report •

#7
August 29, 2006 at 01:28:41

Sorry Jennifer,
That last post should read
I will use the freeze panes feature.

Select the line (Row or Column)below the one you want to lock at the top or side of your spreadsheed, select windows select freeze panes

Avagoodweekend......


Report •

#8
August 29, 2006 at 11:06:18

Okay. I get that, but what does the freeze pane feature have to do with renaming column headings?

Life is more painless for those who are brainless.


Report •

#9
September 7, 2006 at 18:40:11

He wants to always see the header. The original post should have said A, not A1.



Report •


Ask Question