Using Freeze Panes in Excel – 2018 Tutorial

About this tutorial:

Video duration: 3:11
Learn how to use the Freeze Panes feature in Excel to freeze rows or columns in Excel so that no matter where you go in a spreadsheet certain data remains visible. This is a very useful (and easy once you’ve learned it) feature in Excel. See below for more information about the bands mentioned in the video:
The Killers – Wonderful Wonderful:
Brandon Flowers – The Desired Effect:
Blaqk Audio -Material:
Covenant – The Blinding Dark:
Depeche Mode – Spirit:
Erasure – World Be…

Incoming search terms:

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

12 thoughts on “Using Freeze Panes in Excel – 2018 Tutorial

    Jenny Ng

    (February 10, 2019 - 12:36 am)


    Mark VanOuse

    (February 10, 2019 - 12:36 am)

    Lacks info on how to freeze at a particular column AND row that is NOT Row 1 or Column 1. That's what I'm looking for.


    (February 10, 2019 - 12:36 am)

    I wouldn't say "new" and "old" way… they are //different// ways. Specifically, Freeze Panes > Freeze Panes will allow you to freeze any row/column combination you want so that you can infinitely view how many top rows and how many left columns you want, depending on where you freeze.

    Signe Bøgelund-jensen

    (February 10, 2019 - 12:36 am)

    I am wondering if you have a tutorial on how to freeze panes vertically- not only the first row since I have very long spreadsheets and would like sometimes to hide various row various place on the vertical line- is it possible to hide multiple panes?

    Jonatha Gott

    (February 10, 2019 - 12:36 am)

    Thank you for making such clear explanations. Have anything on Match and Index?

    Muhammad Zharif Bin Ghazali

    (February 10, 2019 - 12:36 am)

    Great stuff. Thanks for the knowledge sharing. Just subscribe your channel.


    (February 10, 2019 - 12:36 am)

    completely beside the point but i need some help. I have a spreadsheet for tv shows and i wanted excel to put the month the tv show was seen in whenever the episodes watched=the total episodes. it worked at first but the month keeps changing every month?? could you please help me keep it as it is when it is first filled?

    Coralie Trovato

    (February 10, 2019 - 12:36 am)

    I just wanted to thank you for your amazing tutorials !! I used to FEAR excel 😂 now that I know all these cool stuff, I like to use it again. Thank you ❤️ your channel is one of the most helpful one !

    CHARLOTTE Anderson

    (February 10, 2019 - 12:36 am)

    This is very helpful. I was also able to use the same instructions for Google Sheets.

    Pepe La pew

    (February 10, 2019 - 12:36 am)

    So helpful, thanks a lot..

    CM Punk

    (February 10, 2019 - 12:36 am)

    Thanks i subscribed

    Rogerio Balbino

    (February 10, 2019 - 12:36 am)

    Thank you for sharing. This is so useful 😀

Leave a Reply

Your email address will not be published. Required fields are marked *