Тёмный
No video :(

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

Presentation Process
Подписаться 510 тыс.
Просмотров 48 тыс.
50% 1

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.msaf...
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.

Опубликовано:

 

22 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 37   
@TRMURRAYNY
@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.
@WAQAS12398
@WAQAS12398 2 месяца назад
Best Video Ever difficult to find Attractive thumbnail is important
@PresentationProcess
@PresentationProcess 2 месяца назад
Thanks for the feedback and suggestion! Much appreciated...
@anmoleducation9385
@anmoleducation9385 5 лет назад
Dear sir your every video is very good
@PresentationProcess
@PresentationProcess 5 лет назад
Thank you. Appreciate your feedback, Bipin.
@Gudakesha158
@Gudakesha158 Год назад
MR. Ram I wanna say thing Jai Shree Ram ji ki itne ache tarike se samjhaya na aapne.
@fanzhang6155
@fanzhang6155 3 года назад
Thank you, it is exactly what I am looking for!!!
@peaches20121962
@peaches20121962 Месяц назад
Great job Thanks
@PresentationProcess
@PresentationProcess Месяц назад
Thanks for watching!
@nenevidula
@nenevidula Год назад
explained so nicely. Thanks
@sureshsah7711
@sureshsah7711 3 года назад
Sir your English spoken skill is really fantastic.
@anthonybragg4844
@anthonybragg4844 3 года назад
Thanks - good explanation of what "split" meant.
@hamnamanzoor8259
@hamnamanzoor8259 7 месяцев назад
Really helpful.thanks
@wanyshen5864
@wanyshen5864 Год назад
Useful tutor. Thank you.
@Sabirali00139
@Sabirali00139 5 лет назад
Thank you sir for very useful tips
@MaheshKumar-en5yh
@MaheshKumar-en5yh 2 года назад
Boss, Kudos to ur awesome info.
@RahulKumar-ly6ly
@RahulKumar-ly6ly 3 года назад
Thanks sir very helpful video
@PresentationProcess
@PresentationProcess 3 года назад
Most welcome
@tanvirhasan977-t
@tanvirhasan977-t Год назад
I am a big fan with you lovely sir 😘
@shubhrajit2117
@shubhrajit2117 5 лет назад
Mind-blowing!
@PresentationProcess
@PresentationProcess 5 лет назад
Thank you!
@classyal8035
@classyal8035 3 года назад
LETS GOOO, thank you so much Glory 2 God!
@rap4trains
@rap4trains Год назад
Can you freeze panes at the bottom of the sheet to always see the totals of the columns?
@kiranbabukk6673
@kiranbabukk6673 2 года назад
THANK YOU SO MUCH
@ogechianiakor8492
@ogechianiakor8492 2 года назад
Thank you really
@PresentationProcess
@PresentationProcess 2 года назад
Most welcome
@sanjaysinghchauhan8830
@sanjaysinghchauhan8830 Год назад
Great
@sonalim3944
@sonalim3944 3 года назад
Very informative
@mastermelro9591
@mastermelro9591 5 месяцев назад
Thank you
@sureshsah7711
@sureshsah7711 3 года назад
I liked your video also subscribed.
@TheWholeBurrito
@TheWholeBurrito 4 года назад
thank you sir!
@LadyK_
@LadyK_ 7 месяцев назад
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???
@ajayyadav2699
@ajayyadav2699 4 года назад
Very helpful sir 👍🏼
@pampaiahrajaa5381
@pampaiahrajaa5381 4 года назад
Very useful sir
@winvictorywin5612
@winvictorywin5612 4 года назад
Thanks 🙏
@azizmedia01
@azizmedia01 5 лет назад
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
@PresentationProcess 5 лет назад
Hi, thank you for writing! You can contact us via contact form on our website - presentation-process.com
Далее
How to use Autofill in Excel
15:07
Просмотров 62 тыс.
would you eat this? #shorts
00:29
Просмотров 1,3 млн
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Custom View in Excel
4:55
Просмотров 34 тыс.
Excel Copy Paste Tricks
11:49
Просмотров 437 тыс.
How to Freeze Panes in Excel
3:36
Просмотров 431 тыс.
9 Useful Excel Pivot Table Tips everyone should know
16:33
would you eat this? #shorts
00:29
Просмотров 1,3 млн