J
jasthorn
On an existing spreadsheet with a header, how do you premanently remove the
header?
header?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
If the header is not placed there by code, you should be able to just select the
sheet and View>Headers and Footers.
Delete the header and save the workbook.
If you want them gone from all sheets in the workbook, select all sheets before
View>Headers and Footers step.
If you are talking about deleting something from the Excel default built-in list
of headers, very little can be done.
You can change Author name in File>Properties
Gord Dibben MS Excel MVP
sheet and View>Headers and Footers.
Delete the header and save the workbook.
If you want them gone from all sheets in the workbook, select all sheets before
View>Headers and Footers step.
If you are talking about deleting something from the Excel default built-in list
of headers, very little can be done.
You can change Author name in File>Properties
Gord Dibben MS Excel MVP
J
jasthorn
I followed your instructions of deleting the header and saving the workbook.
I even changed the author to my name and still the header function is there.
Maybe I've identified it incorrectly - It's rows 1 and 2 never disappear
regardless how many rows I scroll down. What do you suggest next?
I even changed the author to my name and still the header function is there.
Maybe I've identified it incorrectly - It's rows 1 and 2 never disappear
regardless how many rows I scroll down. What do you suggest next?
G
Gord Dibben
I would suggest going to Window>UnFreeze Panes.
Sounds like you have rows 1 & 2 frozen.
Gord Dibben MS Excel MVP
Sounds like you have rows 1 & 2 frozen.
Gord Dibben MS Excel MVP
J
jasthorn
Gord -
Perfect. Your answer solved the problem. Thank you.
Perfect. Your answer solved the problem. Thank you.
G
Gord Dibben
Glad to hear you're sorted out.
Gord
Gord