How to Freeze Panes in Excel

Рет қаралды 426,759

Күн бұрын

🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
Learn how to freeze and unfreeze columns and rows in Microsoft Excel. Freeze a portion of the sheet to keep it visible while you scroll through the rest of the sheet. This is useful for checking out data in other parts of your worksheet without losing your headers or labels.
Watch how to freeze just the top row or the first column. Also, learn how to freeze any row and column.
Watch more Excel tutorial videos: • ❎ How to use Excel
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
As full disclosure, I work at Microsoft as a full-time employee.

Пікірлер: 188

@KevinStratvert 3 жыл бұрын

🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: kzfaq.info/sun/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

@1UgLyU 2 жыл бұрын

I can learn from you! You explained it perfectly and simple enough for me to grasp the info . Tysm!!

@antoinettefeazel2252 Жыл бұрын

I had to watch your video several times to get the knack of the freeze pain feature. What you didn' t explain is that you cannot have a header (or title) above the columns you want to freeze. I must have done mine about 6x before I figured this out. Then it works like a charm. Still love your videos nonetheless. Great job.

@Mick-qq1pi Жыл бұрын

I totally agree, just read your comment and realised I had the same issue, applied it again without my headers and it worked thanks Antoinette. Still love your videos Kevin.

@christopherstreet2214 Жыл бұрын

My split is doing something completely different

@renegaderandle8728 3 жыл бұрын

Thank you for not turning this into a lecture great vid.

@borpheus4651 Жыл бұрын

I can’t tell if you’re being facetious or not😂

@beroaiden9380 Жыл бұрын

I agree 😂

@alrhon50 Ай бұрын

Thanks that's been a big help. I knew I could do it, but had forgot how

@YM-sc1gz 2 жыл бұрын

Thank you...you did an awesome job explaining. the best I've seen

@meymk5669 2 жыл бұрын

Your tutorials are really helpful man

@hopesmith8007 3 жыл бұрын

Thank you. You explained it clearly.

@joseramos1962 3 жыл бұрын

Thanks Kevin ---- straight to the point

@askacatholiccom 3 жыл бұрын

Thanks, Kevin - I had watched a number video on how to freeze both the row and the column together and yours was the first one to provide something understandable and workable. Sadly, I still have Exell 2003 but plan to upgrade soon. Mike

@bjsalon 8 ай бұрын

Excellent work as usual. Thank you very much. This is such a very big help.

@randomrandy3059 3 жыл бұрын

Man, im coming from numbers on Mac, and Numbers is so user friendly it makes Excel feel very difficult to use. Now I know there are more functions and capabilities on excel which is why im crossing over. I like the challenge, and im thinking I need a Windows system as well as a Mac. So cool. Thank you for the video. I didnt understand how the hell this was supposed to work.

@samsonabraham9035 4 жыл бұрын

Thank you Kelvin. Your videos are so impressing... Kudos to you.

@KevinStratvert 4 жыл бұрын

Thanks for the note Samson!

@correspondingsecretary2554 2 жыл бұрын

Perfect! Just what I needed

@evianway 2 жыл бұрын

View/Freeze panes or freeze top row selection at 1:30 Thanks! your vids are the best,

@srirupaguha8496 2 жыл бұрын

Thank you! This is very helpful!

@Gtrjerry73 Жыл бұрын

Thanks! Very well explained.

@bradleysnyder6540 Жыл бұрын

Thank you! The need for the Splits button wasn’t obvious to me. A few clicks after your video and I am setup properly. Thank you!

@LeafsIn2024 8 ай бұрын

I really appreciated this. Thank you, Kevin!

@badriahbadriah1675 6 ай бұрын

Thank you Kevin. You helped me a lot.

@danny_surrff 3 ай бұрын

Thanks for the Info!

@MrVeer58 6 ай бұрын

Thanks for the information about the "thick line".

@csc616 Күн бұрын

Thank you! this is exactly what I needed

@lorenakademar5267 Жыл бұрын

Very useful video!! Thank you Kevin

@afsheen0408 Жыл бұрын

Thank you!! I needed to refresh my memory.

@niagaraadventureclub Жыл бұрын

Thank you, you just made my life much easier!

@AS-bx9pp 10 ай бұрын

Thank you somuch for very useful information you giving out. 👍

@skullogyse 2 ай бұрын

Thanks a lot! This was very helpful

@NoorKhan-cw4kl 10 ай бұрын

Video start at 1.30 thanks me later

@cocoalee2556 8 ай бұрын

syukran ,vanikam,gracias, terima kasih ,xiexie

@vikeneswarannedunchezhiyan6332 8 ай бұрын

Vanikam tu hello kak 😂 *vanekkam

@abhisheksinghp276 6 ай бұрын

1:30, mf

@yk5994 6 ай бұрын

thanks buddy

@youngreebs 4 ай бұрын

Lifesaver

@maraziziomar8997 2 жыл бұрын

Tyvm Kevin, great help

@JohnOliver100 Жыл бұрын

Very helpful. Thank you!

@maxtrinh9165 2 жыл бұрын

Thank you. Very good job.

@GetFit_W_Hassan 3 ай бұрын

it was helpful thanks!

@kammkam2630 Жыл бұрын

Thank you man!

@joyima2439 Жыл бұрын

This was helpful. Thank you.

@aka3945 Жыл бұрын

Thanks. I have been looking for this for long time

@dbush 2 жыл бұрын

Thanks that was fast and easy

@andreacardenas01 2 жыл бұрын

Thank you so muchhhhhhhhhhhhhhhhhhhhh! i have been going MADDDD trying to figure this out.

@jbb2650 9 ай бұрын

Thank you. Great explanation.

@Flaretale52 3 жыл бұрын

Thanks. I was really stumped prior!

@nicolesakwe1973 9 ай бұрын

Super helpful. Thank you.

@muffythemonster Жыл бұрын

Thanks so much!

@scotttuck8957 Жыл бұрын

Appreciate you sharing this info. I was lost in space and too proud to ask anyone at work. Didn't want to be labeled a DA.

@floydguel4238 6 ай бұрын

Thank you !!

@nirodhasenerath8417 8 ай бұрын

Thank you very much. This was very helpful.

@mixme749 9 ай бұрын

Thanks. It helps me a lot today.

@yannetbillion7893 Жыл бұрын

IT WAS HELPFUL. Thanks

@maribelru2011 Жыл бұрын

Thank you for the brevity ❤

@G254611 2 жыл бұрын

Thank you!

@mickeyrietveld9249 8 ай бұрын

very nice, thank you

@PrivateArmy666 Жыл бұрын

Thanks man. I was struggling to find this.

@teoriasindikato2804 3 жыл бұрын

big help thanks

@NohaAbdElAal Жыл бұрын

Thank you so much

@joseroque3436 2 жыл бұрын

You are the best!! thanks a lot

@asadrafik7547 3 жыл бұрын

Thank you dear kelvin

@arunnathe2697 2 жыл бұрын

Nice thankyou for the help

@sidzhottake Ай бұрын

great video and thanks from Korea! And congrats on 3 + million subs Kevin!

@funland5804 6 ай бұрын

Thank you for this valuable information ❤❤❤

@leadergeovanni7740 8 ай бұрын

Thank you so much! Just subscribed!

@MrMakosi 2 жыл бұрын

thank you my dude

@raysurx2010 Жыл бұрын

Excellent thanks!

@lolonabil3815 Жыл бұрын

Thanks a ton

@20LOL14 2 жыл бұрын

Thank you!! I need a class 🤦🏽‍♀️ How do you do this so that the header (top row) will show up at the top of each printed page?

@lovegodmyself 2 жыл бұрын

Thanks!

@pravoslavn 3 жыл бұрын

At Last ! A narrator who is professional enough that he does not say UH and GONNA ! Good job, Kevin !

@syedpanahalishahkazmi6960 3 жыл бұрын

It helped me.

@2326TOM Жыл бұрын

Thank you.

@nokwehbuthelezi6490 2 жыл бұрын

Thank you 😊

@jacquelinejackson5191 2 жыл бұрын

Thank you that was simple.................................YAY

@alzdsz 4 жыл бұрын

Hey Kevin I wanted to know if you could let me know if there was a way to hide something in excel using the function but if the other person tries to unhide it it won't really show up is there a way that way. Cause my friend knew it but i couldn't find a solution to it ?

@rajeshghosh9487 2 жыл бұрын

Thanks buddy❤

@foxboy7377 5 ай бұрын

Thanks bro.

@hassinabegum9943 2 жыл бұрын

excellent bro

@Turnpike617 Жыл бұрын

Thanks, Buddy

@BrickMuffin Жыл бұрын

Holy crap this is so helpful. Thanks mate

@bruzpremaxio6759 2 жыл бұрын

Thank you sir.. 👍

@paxlepham 5 ай бұрын

Thank you,

@radhiyasultana173 4 жыл бұрын

Your videos are really helpful....zajakallah

@KevinStratvert 4 жыл бұрын

thanks for the note Alux!

@steveobrien2785 Жыл бұрын

perfect!!

@danishbabar995 11 ай бұрын

Thanks 😊

@cochinito1 2 жыл бұрын

Kevin, this tutorial was the quick solution I was looking for. But I don't see that option on share point. I've noticed certain functions are not displayed, but they work after I set them on the application.

@isawul00k 2 жыл бұрын

Thank you

@buxvet 3 жыл бұрын

ty I used to know how to do it in older version, easy peasy

@emiercorpuz9554 2 жыл бұрын

Thank u 🙏

@ngocvu3326 2 жыл бұрын

thanks!

@GreenOilBike Жыл бұрын

Doesn't work for more than one row or Column - would have been good to have a tutorial on this. SN (PS seems to be the split feature which works to do this)

@antonythomas3088 2 жыл бұрын

Thank u... No wastage of time

@iqrarhussain7136 10 ай бұрын

great....!!!

@corybiagi8309 Жыл бұрын

thank you for helping be lie on my resume, one video at a time!!

@jezzabell1765 Жыл бұрын

Hi, Great vid. :) I’m wondering if you could do a tutorial on to share document hyperlink and send it to a ‘Teams’ chat? And then able to open from ‘Teams’. TIA

@therealiq 11 ай бұрын

thanx mate

@user-qj3bt7sv9z Жыл бұрын

thanks bro

@jemstv0126 Жыл бұрын

Thanks

@hildaroberts2307 4 жыл бұрын

Hi Kevin, could you please do a video on how to have someone talking in the corner of the video while at the same time in the background the computer screen is visible. I really enjoy your videos and I find them very helpful!

@KevinStratvert 4 жыл бұрын

Hi Hilda - thanks for the note! The following should show you what you're looking for: kzfaq.info/get/bejne/q7Joddqk2dfNoXk.html

@KhairiDarweesh 11 ай бұрын

Hi Kevin, I used some of Microsoft templates, and when I scroll down, the column headers are visible without freezing panes. How can you do that? For example, refer to the Grocery List template. You can see on that template and a lot of other MS templates that the headers replace with the A, B,C ...etc. while the example you showed here, you can still see the A, B,C ....etc.

@qt6120 Жыл бұрын

Done splitting. Thanks

@tomburull2499 10 ай бұрын

Thanks, how do I make a program in column A & B were I start with zero in row 1B and then add or subtract values in column A to give me an TOTAL in column B of gains and losses?