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
This video is created by Ramgopal from Presentation Process in Excel 2016 for Office 365. Visit Presentation-Process.com for more.
*Link to get Microsoft Office 365:*
microsoft.msafflnk.net/c/1877...
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.

[@WAQAS12398]

Best Video Ever
difficult to find
Attractive thumbnail is important

[@PresentationProcess]

Thanks for the feedback and suggestion! Much appreciated...

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

[@fanzhang6155]

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

[@nenevidula]

explained so nicely. Thanks

[@hamnamanzoor8259]

Really helpful.thanks

[@wanyshen5864]

Useful tutor. Thank you.

[@anthonybragg4844]

Thanks - good explanation of what "split" meant.

[@Gudakesha158]

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

[@anmoleducation9385]

Dear sir your every video is very good

[@PresentationProcess]

Thank you. Appreciate your feedback, Bipin.

[@sureshsah7711]

Sir your English spoken skill is really fantastic.

[@MaheshKumar-en5yh]

Boss, Kudos to ur awesome info.

[@tanvirhasan8132]

I am a big fan with you lovely sir 😘

[@TheWholeBurrito]

thank you sir!

[@kiranbabukk6673]

THANK YOU SO MUCH

[@classyal8035]

LETS GOOO, thank you so much Glory 2 God!

[@Sabirali00139]

Thank you sir for very useful tips

[@sonalim3944]

Very informative

[@shubhrajit2117]

Mind-blowing!

[@PresentationProcess]

Thank you!

[@sureshsah7711]

I liked your video also subscribed.

[@RahulKumar-ly6ly]

Thanks sir very helpful video

[@PresentationProcess]

Most welcome

[@ajayyadav2699]

Very helpful sir 👍🏼

[@mastermelro9591]

Thank you

[@rap4trains]

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

[@sanjaysinghchauhan8830]

Great

[@pampaiahrajaa5381]

Very useful sir

[@winvictorywin5612]

Thanks 🙏

[@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???

[@ogechianiakor8492]

Thank you really

[@PresentationProcess]

Most welcome

[@peaches20121962]

Great job
Thanks

[@PresentationProcess]

Thanks for watching!

[@azizmedia01]

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.

[@PresentationProcess]

Hi, thank you for writing! You can contact us via contact form on our website - presentation-process.com