Excel Freeze Panes (Freeze | Split Panes

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

Рет қаралды 47,654

5 жыл бұрын

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.

Пікірлер: 37

@WAQAS12398 Ай бұрын

Best Video Ever difficult to find Attractive thumbnail is important

@PresentationProcess Ай бұрын

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

@TRMURRAYNY 4 жыл бұрын

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 3 жыл бұрын

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

@nenevidula Жыл бұрын

explained so nicely. Thanks

@anmoleducation9385 5 жыл бұрын

Dear sir your every video is very good

@PresentationProcess 5 жыл бұрын

Thank you. Appreciate your feedback, Bipin.

@hamnamanzoor8259 7 ай бұрын

Really helpful.thanks

@wanyshen5864 Жыл бұрын

Useful tutor. Thank you.

@anthonybragg4844 3 жыл бұрын

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.

@TheWholeBurrito 3 жыл бұрын

thank you sir!

@kiranbabukk6673 2 жыл бұрын

THANK YOU SO MUCH

@Sabirali00139 5 жыл бұрын

Thank you sir for very useful tips

@MaheshKumar-en5yh 2 жыл бұрын

Boss, Kudos to ur awesome info.

@sureshsah7711 3 жыл бұрын

Sir your English spoken skill is really fantastic.

@sonalim3944 3 жыл бұрын

Very informative

@sureshsah7711 3 жыл бұрын

I liked your video also subscribed.

@mastermelro9591 5 ай бұрын

Thank you

@shubhrajit2117 5 жыл бұрын

Mind-blowing!

@PresentationProcess 5 жыл бұрын

Thank you!

@ajayyadav2699 4 жыл бұрын

Very helpful sir 👍🏼

@tanvirhasan8132 Жыл бұрын

I am a big fan with you lovely sir 😘

@rap4trains Жыл бұрын

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

@sanjaysinghchauhan8830 Жыл бұрын

Great

@winvictorywin5612 4 жыл бұрын

Thanks 🙏

@classyal8035 3 жыл бұрын

LETS GOOO, thank you so much Glory 2 God!

@RahulKumar-ly6ly 2 жыл бұрын

Thanks sir very helpful video

@PresentationProcess 2 жыл бұрын

Most welcome

@pampaiahrajaa5381 4 жыл бұрын

Very useful sir

@ogechianiakor8492 2 жыл бұрын

Thank you really

@PresentationProcess 2 жыл бұрын

Most welcome

@LadyK_ 6 ай бұрын

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