Title header excel

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...

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.

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......

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.

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

Now I'm thoroughly confused. LOL Life is more painless for those who are brainless.