[HELP] editing a header in excel

**Cessh** · 11-26-2013, 05:04 PM

Hello guys,

I need to edit a header in an excel file i found. When i opened the excel file, the header its not visible, its hidden in the upper rows. I cant seem to find a way to make those rows visible, not even using the normal unhide rows button. But i know there is a header there, because when i try to print the file, the header appears. Below is the screenshot. The header is hidden in rows 1-7. But i don't know how to access it.

Untitled.jpg

This is the screenshot when in print preview.

Untitled.jpg

Do you know how to unhide it so that i can edit the words in the header? thanks for the help.

**TMS** · 11-26-2013, 05:13 PM

It's not very easy to work with pictures, especially if you scribble all over them.

You don't say if the sheet is protected. It may be that you can just select all the cells by clicking on the grey box at the intersection of the column header letters and the row numbers. Then format | Unhide rows. And also Unfreeze Panes on the View Ribbon.

Regards, TMS

**Cessh** · 11-26-2013, 08:26 PM

Damn!!! thanks youu. Unhide rows did not work. It was Unfreeze pane that worked. The rows was not hidden, it was froze. I should've notice that, such a simple thing. Again, thanks alot mate!!!

**TMS** · 11-26-2013, 08:32 PM

You're welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.