How to Freeze Top 3 Rows in Excel

Instructions on how to freeze the top 3 rows on Excel:

Step 1: Highlight the first two rows. Right click on it and hide it.
Step 2. Under Menu go to View, Freeze Panes, then select Freeze Top Row.
Step 3. Now, unhide the first two rows. And there you have it.

[cavuk]

This is the only example on you tube of doing this task that was shown and explained easy, thank you SO much this was driving me insane.

[yangyang]

Very smart way to make it work, thanks!

[binitamehta]

Thank you so much, this is literally the best and easiest.

[tatyanak]

Thank you! The only trick that worked!

[ozanyasindogan]

Nice work but how excel does not allow to do it in simpler way.. Very lacking

[wolfgangdarquea]

not even Microsoft videos has this trick hahahah thank you! very much appreciated!

[Osie]

thanks, exactly what I was looking for

[neamkanbour-anwar]

Nice work. I find it so bizarre that Excel only allows for the top row to freeze! Thanks for your trick!

[jeremywebb]

Great "trick". Just stupid that Excel does not allow you to specify how many rows to freeze in the first place.

[dustin]

Is there a way to just freeze row 3 only in your scenario?

[julienpounders]

Is there any way to freeze the top 3 rows in addition to freezing the side two columns? Thank you.

[zzigiss]

But after that when you freeze the first column, the top rows unfreeze

[kenj]

I had to select the whole sheet and THEN unhide.