Excel Freeze Panes (Freeze | Split Panes | Hide/Unhide)

Excel Freeze Panes
: Learn how to lock a row or column so they don't move while you scroll through the Excel sheet.
What is covered in this Excel tutorial:
==============
1) How to Freeze Panes
- How to Freeze top Row to keep the header row visible
- How to Freeze the first Column
- How to freeze more than 1 row and column
- How to freeze rows and columns at the same time.
- How to Unfreeze panes

2) How to Split Panes
- When to use Split Panes
- How Split Panes work
- How to Split Panes for Rows and for Columns
- How to Split Panes for both Rows and Columns at the same time
- How to remove the split.

3) How to Hide/ Unhide Columns or Rows
- How to unhide with Mouse click
- How to Hide Rows as well as Columns

#ramgopalexcel
**Link to get Microsoft Office 365:**

Disclosure: The above link is an affiliate link, meaning, at no additional cost to you, I will earn a commission if you click through and make a purchase.

[WAQAS]

Best Video Ever
difficult to find
Attractive thumbnail is important

[TRMURRAYNY]

Thank you so much!!! I have very basic skills in Excel since it was not a a major portion of my job. With remote work from home, I suddenly found myself having to do monthly billing reports on Excel and going from the first column (names of children) to the end of the month almost killed me! My ED showed me how to split but it was not helping to get to the very end of the sheet. I found your video and now I'm able to use Hide. Tried it out on my billing form and it worked perfectly. Definitely going to look at more of your videos as the quarantine continues in the U.S. Again, you are a lifesaver. Stay safe and healthy.

[anmoleducation]

Dear sir your every video is very good

[sureshsah]

Sir your English spoken skill is really fantastic.

[Gudakesha]

MR. Ram I wanna say thing
Jai Shree Ram ji ki
itne ache tarike se samjhaya na aapne.

[fanzhang]

Thank you, it is exactly what I am looking for!!!

[anthonybragg]

Thanks - good explanation of what "split" meant.

[classyal]

LETS GOOO, thank you so much Glory 2 God!

[LadyK_]

My "Freeze top row"and "Freeze column" options do not offer a drop down. Do we know why not? How do I freeze a second row without additional freeze options???

[raptrains]

Can you freeze panes at the bottom of the sheet to always see the totals of the columns?

[azizmedia]

Dear sir, i am very happy for ms all videos.please give me your personal email.
Thank you for your videos.
May Allah bless you and yiur family.