How to Freeze Panes in Excel (freeze rows and columns) #shorts

Learn how to use Freeze panes in Microsoft Excel to freeze a row in Excel when scrolling. This way you can keep an area of a worksheet visible while you scroll to another area of the worksheet. You can freeze the top rows in Excel, freeze multiple panes and columns. You get to lock your cells to keep them always visible as you scroll through your larger datasets in Excel.

🚩Let’s connect on social:

👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel

[ajs]

On a related theme, if you've converted your worksheet to an Excel "table, " then when you scroll down, the "A, B, C" changes to the column's name. No need to freeze rows when you're working in Table mode.

[HowToAnalyst]

Great tip! I use ALT W F F to do this quickly.

[prishasrivastava]

That's actually quite useful! Thanks :)

[sachingore]

Madam, I am a big fan of yours. There is a lot to learn through your channel today and will continue to learn in the future. Thank you very much.

[JYue]

This short helps so much! Finally know how to lock row and column at the same time😍

[LUXNS]

You've helped me master excel, Thank you very much!

[arifsayyed]

Thank you for the video.

Freeze Panes

[wingame]

Finally one from the myriad of Leihla's excel lessons that's familiar to me! Thanks for all other 99.99% tips & lessons!

[Dhiyaneshwar_Vlogger_]

Pro key! Go to the search bar and type freeze panes! And then watch your results!

[andrewcharlesmoss]

I prefer using an Excel Table, as it displays the table column names in the column headers when you scroll down.

[abdulsaidmkamara]

Thanks Leila as always ! Would like you to do something on Named ranges :-) if you did a video can you link it here as that would be helpful.

[jlim]

oh thats why I wasnt freezing the first column! It's the 2nd cell from left.

[kyrahello]

Awesome! I have been freezing top row then if I want another row frozen, I then insert above said frozen row. Didn't know I could do it this way! Thank you!

[ItsMeAnn]

How do you freeze the top row AND the first column at the same time???

[melisparlar]

How can we create a select all button for two dependent combobox and put them into a listbox ? Like combobox1 : A, B, C and Combobox2 : A1, A2, B1, B2, B3, C1 and I want to create two columns on the list box like A A1 first row, A A2 second row etc.

[KimberlyMessina-sc]

What do you do if your drop downs don't give you the option of "freeze panes" only freeze top row, freeze first column or unfreeze? I can't find help with this anywhere?

[dharmmu]

Seriously now u will be teaching freeze unfreeze on this channel...so next video might be on sum.😆😆

[michelesanm]

Thank you!! I’m sure computer challenged!😅

[learnexcelwithnaveen]

Hello Mam
My self Naveen i am also excel trainer i love you videos. I want to know how are you making this shorts could you please make a video how to make shorts (screen recorder) and editing

[petr]

Unfortunately, the print does not respect the panes and hidden cells...