HOW TO Freeze a Row in Excel (inc. Freeze Multiple Rows and Columns)

[@ExcelatWork]

Need a hand freezing, or locking a row in Excel so that you can still see it when you scroll? Let Sharyn help.

[@walteryoung8793]

I need help finding the freeze panes on my excel. It does not show the icin on the bar

[@Jasonbc25]

Thank you so much! I couldn't for the life of me figure out how to freeze a row that was not Row 1!!!! Game changer!!!

[@ExcelatWork]

You're welcome!! So happy it helped you!

[@donlandstl]

Thanks for this video! I used to be an intermediate user of Excel, but they've added so much new stuff and I've forgotten some of the basic stuff, so I feel more like a novice.

[@ExcelatWork]

You're very welcome! Yes, there is are so many new features in Microsoft 365! I'm glad you enjoyed my video 😊

[@dawnsherrer9848]

Freezing a row other than the top row was exactly what I needed to do! Thank you for this tip!!

[@ExcelatWork]

You're so welcome!

[@judemaigari2474]

Thanks so much for this. I have cracked my head to get this to no avail, but see how easy u made it for me. Thanks

[@ExcelatWork]

You are so welcome! I'm so glad it helped.

[@BlazeDRBlade]

Thank you so very much. I've been struggling with this for 20 minutes.

[@DROIDFARM]

Liked and subscribed! I love that you laughed about the ice on the icon, you seem so real! Your accent is NZ I think? I am not used to it but your fun character pulls me past my challenge! I love accents just when something is technical sometimes I struggle! The more I hear them the better I understand though! Please don't lose your accent or take it as a knock! You are such a fun teacher and I will be watching more! So many Excel teachers are like robots, thank you for being a fun human!

[@ExcelatWork]

THANK YOU so much Benjamin! I so appreciate your comment. I mostly get negative comments about my accent, so it is very uplifting to receive your kind comment 😊 Yes, I am from NZ. Well done! I'm so happy I was able to help you. Have a fantastic day! Sharyn

[@sjaw100]

Thank you so much. Dispels all those months of confusion.

[@ExcelatWork]

You're very welcome!

[@MYUTV100]

Good one. Please show how to freeze multiple columns in excel sheet.

[@ExcelatWork]

Hi Hami. Please visit my Blog post excelatwork.co.nz/2019/11/21/how-to-freeze-a-row-in-excel/ and make your way down to the topic heading 'How to freeze a row and a column at the same time'. You can follow the instruction on this page. As an extra tip though, if are wanting to put a lock against the first two columns only, you would select cell C1. Column C is the immediate column to the right of the columns you want frozen, and selecting row number 1 means you will not freeze any rows. I hope this helps. Take care. Sharyn

[@gregbrisk908]

Thank you so much , this helped my College coursework!

[@ExcelatWork]

Great to hear! You're so welcome!

[@kathybayham6229]

Very nice and helpful and fun to hear her Aussie accent.

[@ExcelatWork]

Glad you enjoyed it Kathy! Thank you so much so saying something nice about my accent (some people don't enjoy it 😢). Take care 🌼

[@Steggman]

Perfect. I needed to freeze top row and first column. Thank you.

[@ExcelatWork]

So glad it helped!

[@1bh2nd3md]

3:25 is exactly what I was looking for! Thank you.

[@ExcelatWork]

Fantastic. So glad it helped you.

[@rigelabanes699]

YOU are heaven sent. Thanks for sharing this.

[@ExcelatWork]

Wow, thank you! I'm so glad it helped you 😊

[@harshharsh1988]

Thanks Mam for sharing such a valuable information about freeze pane.

[@ExcelatWork]

My pleasure 😊

[@soundsoftheworldextended3022]

Thank you! Something so simple but yet was so hard for me to figure out.

[@ExcelatWork]

Glad it helped!

[@marcycampbell5730]

I have just recently taken a course on excel and this was not gone over and the first thing I needed was this you where so helpful

[@ExcelatWork]

I'm so glad it helped Marcy. Thank you for letting me know 😊

[@diva70smusic]

Best instruction yet for beginners. Thank you so much!!

[@ExcelatWork]

Thank you so much! I'm so glad it was helpful! 😊

[@Drea10art]

After I clicked "freeze top row". The top option stitches to "unfreeze". THAT'S why could find and figure this out. Thought it had one function, like the other two. Thank you so much!!

[@ExcelatWork]

So glad I could help Andrea. Thanks for letting me know 😊

[@wiredawg2005]

Thank you for this vid, I've done it before...like once, in the last 5 yrs or so. It was driving me nutz on how to do just that and I knew it was simple....Thx!!!! : )

[@ExcelatWork]

You're welcome! 😀

[@markbeckerman5159]

I am late to your videos,they have been a great help!!!

[@ExcelatWork]

So glad you like them!

[@bryantdarris]

Awesome, it even worked for me. Thank You, for being thorough.

[@ExcelatWork]

Ha ha, glad it helped Bryant! 😊

[@kriswalker1354]

Excellent. Best tutorial online. Thank you!

[@ExcelatWork]

Wow, thanks Kris! That is so nice. You've made my day!!

[@kengy1991]

I was wanting to know how to freeze my second row and this video was perfect!

[@ExcelatWork]

Fantastic! So happy it helped you.

[@luatala8008]

yes thats how i ended up here...other vid only showed top row freeze.

[@raychelleinjete4024]

This has been super! Thank you so much . Very clear for non techies.

[@ExcelatWork]

You're very welcome! Thank you so much for your feedback. Love it!!

[@bhtours5226]

This video is great, i've been trying to figure this out for a long time. Thanks alot

[@ExcelatWork]

So happy it was helpful to you. Thank you so much for letting me know.

[@lefatsiane2376]

thank you for this, very informative, but can you do the same (freezing panes) when using Google sheets?

[@ExcelatWork]

Hi Lefa. I believe you can. Please check out this page support.google.com/docs/answer/9060449?hl=en&co=GENIE.Platform%3DDesktop. I hope it helps 😊

[@smiles584]

I was going crazy trying to figure this out, thank you!!

[@ExcelatWork]

Fantastic it helped out! Have a great day and thanks for your comment :-)

[@tejinderkaur8745]

Thank you so much it’s very helpful. I always confused in it😊

[@ExcelatWork]

Glad it was helpful!

[@joeruriti8418]

Thank you very much. After headache with this; now get it.

[@ExcelatWork]

Fantastic! So happy it helped :-)

[@lifeoutsidethemachine3910]

Saved me a ton of time. Thank you!

[@ExcelatWork]

You're welcome! Thank you for letting me know :-)

[@nkosinkala2780]

Could you, please make a tutorial on creating an inventory management for a warehouse. Just a simple one for products coming in and going out without sales. How to add the number of products as row materials and process them, get them ready and dispatch them and keeping the record of stock. Thank you.

[@nearsky771]

Thanks for your sharing. Really helpful

[@ExcelatWork]

Glad it was helpful!

[@benazirinamdar4424]

extremely helpful. Thanks a ton

[@emmalungulesei9418]

Amazing help!! Thank you!!

[@ExcelatWork]

You're welcome!

[@unbalancedbynature3]

Fantastic tutorial! I'm creating a quick spreadsheet at work and could not figure out how to freeze the second row. :D

[@ExcelatWork]

Glad it helped!

[@jagneethi]

Thank you lady .. life saver 🍩

[@ExcelatWork]

You’re welcome 😊

[@jessicaehonor2024]

It was very helpful, thank you

[@ExcelatWork]

You're welcome!

[@ibrahimkiggundu302]

Thank you so much, this helped a lot I was so confused and getting annoyed trying to figure it out lol

[@ExcelatWork]

Yay! I'm so glad it helped! 😀

[@ysabethsweet3407]

THIS IS A LIFESAVER

[@ExcelatWork]

Yay! So great our video helped you. Thank you so much for letting us know 😊

[@raziabbas6888]

Thanks a lot. It really helped.

[@ExcelatWork]

Glad to hear that! Thank you!

[@walteryoung8793]

My version of excel does not have the top row or bar showing the freeze pane icon. I wonder if the newer excel has a different way of locating freeze panes?? Hitting View doesn't bring me this. On anold version I was able to see the choices you show on this video. Any thoughts?

[@walteryoung8793]

I do not see the link to get the pamphlet on improving yourself on excel

[@ExcelatWork]

Hi there. Hmmmm, I'm not sure why I'm sorry. I have the latest build of Excel and it is definitely there. It's also available in the Excel Online version. You could try typing 'Freeze Panes' into the Search bar at the top of the screen. This will help you locate the feature.

[@ExcelatWork]

It's available from here Walter. www.excelatwork.co.nz/subscribe-eawi/

[@walteryoung8793]

@@ExcelatWork thank you I will

[@kosarlatif5213]

very good explaing for people thanx alot

[@ExcelatWork]

Thanks and welcome

[@johncarpenter3665]

Extremely clear, and very helpful. Thank you!

[@ExcelatWork]

Thank you! Glad it was helpful!

[@golamnur9439]

excellent video. It has solved my problem.

[@ExcelatWork]

Great! So happy it helped 😀

[@ngcwelekazinancymalumko7572]

Thanks so much, I was really struggling on this

[@ExcelatWork]

You're welcome! So glad it helped.

[@citizenbobx]

I don't suppose you can do this when working an excel sheet when working in MS Teams?

[@ExcelatWork]

Hi there. If you are referring to the online version of Excel, then the answer is Yes, thankfully you an use Freeze Panes. You can find the option on the View tab 😊

[@zj9928]

very helpful ,thank you very much

[@ExcelatWork]

You are welcome! So happy it helped! 😊

[@arielventura83]

Thank you so much. From D.R.

[@ExcelatWork]

You're most welcome!

[@whatsupwithdjpodcast]

Thank you so much! You are a lifesaver!

[@ExcelatWork]

You're welcome!!!

[@Deaaaaaaaalove]

Super helpful!Thank you.

[@ExcelatWork]

Glad it was helpful! Thank you for letting me know :-)

[@ramakrishnavepuri331]

Thank you so much for this video....

[@ExcelatWork]

You are so welcome!

[@oatway47]

my excel only shows unfreeze panes, freeze top row, freeze first column - I want to freeze the top 2 columns but I don't have the option of "freeze frames" to make this possible. I would appreciate the help. thanks

[@ExcelatWork]

Hi Carlene. It looks like you may have Freeze Panes turned on already. Try selecting Unfreeze Panes and then your Freeze Panes options will be available so that you can reset and freeze the top rows. If it is the top 2 rows you want frozen, once you have selected 'Unfreeze panes' select cell A3 and then from the View tab select Freeze Panes, and then the top option from the list 'Freeze Panes'. I hope this works for you 😊

[@mohd.saffuanbinyakub-162]

THANKS FOR SHARING

[@ExcelatWork]

You are so welcome. Thanks for watching!

[@wintermorillo6567]

Great content!

[@ExcelatWork]

Thank you! Glad it helped.

[@musiccheetahjudge]

Is it possible to freeze a single column that is not the first column without bringing along the other columns to the right of it?

[@ExcelatWork]

Not within Freeze panes unfortunately. You could try the following steps to see if this works. 1. From the Data tab click 'New Window'. You will now have 2 windows displaying the same workbook. Now from the View tab click 'Arrange' > 'Vertical' > OK. You will now have the ability to scroll and view different parts of your worksheet in the separate windows. I hope this helps :-)

[@feroserehman5235]

A teacher affects eternity; she can never tell where her influence stops.

[@ExcelatWork]

Beautiful. Thank you!

[@parthoprotim3928]

I need freeze only like:13 row not freeze 1 to 12 rows. It's possible??

[@ExcelatWork]

Hi Partho. Scroll down your sheet until only row 13 is showing (i.e. rows 1 to 12 are now out of sight). Then use Freeze first row. I hope this is what you are needing. Best regards, Sharyn

[@MTTRON]

I see how you froze the top rows and left columns but when you scroll up the columns you froze will go up thus losing any headers. If while the column is frozen when you scroll left the Top (frozen) cells go left thus being hidden from view! My question is how do you FREEZE both the Columns and ROWS where they wont move at all. IE if Column 1 and Row1 are both frozen I don't want either row or column to move!

[@KhairulAlam20]

Thank you so much ma'am...

[@ExcelatWork]

Most welcome 😊

[@hector94]

Thank you so much!

[@ExcelatWork]

You're welcome!

[@ericwilkins4945]

Is there not a way to freeze multiple rows like row 1 and then freeze row 65?

[@citizenbobx]

And what if you don't want the sort to apply to it. How do I name the columns instead of just A B C?

[@ExcelatWork]

Hi there. You might like to check out Excel Tables. When you select your data and apply a Table over the data, as you scroll down the Table headings replace the letters in the columns, e.g. A, B C etc. Very handy! You might like to check this page out support.microsoft.com/en-us/office/create-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac664

[@sameeranuwan7414]

Thank You Very much..

[@ExcelatWork]

You are very welcome!

[@AmandaPersaud-q1r]

Omg thank youuu got it!

[@ExcelatWork]

Fantastic! You are so welcome!!

[@neddieable]

thank you big help for me

[@ExcelatWork]

Yay! You are so welcome!

[@P-Eric]

Thank you, eveyone is good at freezing the 1st only, but it's never what I need.

[@ExcelatWork]

So true! I'm so glad it helped.

[@kamakazie-kronos668]

Awesome thanks

[@ExcelatWork]

You are so welcome 😊

[@educationspot7196]

4.48 ...thanks

[@sam_mba.]

Thanks!

[@ExcelatWork]

You're welcome!

[@gladiator1888]

Thank you

[@ExcelatWork]

You're welcome!

[@famfatale2007]

Thank you!

[@ExcelatWork]

You're welcome!

[@adiithandhisrandomthings9010]

thx, u really saved my ass

[@ExcelatWork]

LOL! So happy it helped.

[@gauravjeengar7649]

Hey guys, i want to freez from A1 to D70, its not coming

[@ExcelatWork]

Hi there. If you are trying to freeze everything above and to the left of D70, select cell E71 and then from the View tab select Freeze Panes > Freeze Panes.

[@kraja3d]

thanks

[@ExcelatWork]

You're welcome!

[@LoremIpsumPeach]

How do you only freeze the 3rd row without freezing the ones on top? Why doesn't excel just have you highlight the rows/columns you want to freeze? This is such a weird way to design this feature - it makes no sense -_- classic microsoft....

[@ExcelatWork]

Hi Jennifer. Yes, that would be an awesome feature and makes a lot of sense 😀. Are you familiar with Tables? You could possible apply a Table over your data and then when you scroll down the Table headings are displayed where the column letters are normally displayed at the top of each column. This could solve your problem 👍 I hope this helps 😊

[@pmelcher9239]

go to 2:08

[@Hosamo7]

100 likes if possible

[@ExcelatWork]

Thank you! So happy it helped 😊

[@lyfesaquarium]

Thank you!!!

[@ExcelatWork]

You're welcome!

[@alvin2014]

Thank you!

[@ExcelatWork]

You're welcome!

[@IanRey35]

Thank you

[@ExcelatWork]

You're welcome

[@rinnie0933]

Thank you!!!

[@ExcelatWork]

You are so welcome! So happy it helped you 😊

[@missink1728]

Thank you 😊

[@ExcelatWork]

You're welcome 😊

[@2326TOM]

Thank You

[@ExcelatWork]

You're welcome!

[@aileenpimentel453]

thank you

[@ExcelatWork]

You're welcome