In this lesson, I’m going to be showing you how to:
- Understand what Freeze panes mean
- FREEZE panes (columns or rows) in Excel
- Is it possible to freeze a row and column at the same time
- Can you freeze multiple rows and columns at the same time
Go ahead, open the video below and watch the tutorial at your own pace:
If I have not covered everything in this lesson, please leave a comment or your question below and I will get back to you. (you may have to scroll down past other lovely peoples comments)
Enjoyed this tutorial? Then please don’t forget to Like & Share with your family and friends on all the social media platforms, such as Facebook, WhatsApp and Instagram 🙂
Watch this tutorial directly on our YouTube channel and Subscribe
Thanks for watching!
Do you want to learn to create your own website?
If you want to LEARN to create your own website like ours, then CLICK HERE to join a learning platform for FREE and learn at your own pace with video tutorials. Once you’ve joined, we will see you on the other side to help you out too.
CLICK HERE to read our review about this amazing learning platform, if you want to know more.
When you’re ready move onto:
Lesson 26: Use the AUTOSUM button to quickly ADD up cells in Excel | What is the Autosum Button in Excel?
Or go back to:
Lesson 24: How to SORT data in ASCENDING order in Excel
Lesson 23: Best techniques to widen columns & adjust the height of rows in Excel
Lesson 22: How to RENAME a worksheet in Excel
Lesson 21: How to COPY cells from one spreadsheet to another spreadsheet in Excel
Lesson 20: How to select multiple NON-ADJACENT cells in Excel | What are the benefits?
Lesson 19: What is a Workbook and Worksheet in Excel | What is the difference between a workbook and worksheet in Excel?
Lesson 18: What is a Formula and Function in Excel | What is the difference between a formula and function in Excel?
Lesson 17: How to PRINT the spreadsheet SHOWING the formulas and functions in Excel
Lesson 16: What is Page Orientation in Excel | Change Portrait orientation to Landscape in Excel
Lesson 15: Format the Font colour in Excel | Shade a range of cells to any colour in Excel
Lesson 14: How to insert a HEADER in Excel? | How to insert an AUTOMATIC FILENAME in the header?
Lesson 13: How to Format cells as Currency, Date, Percentages and apply Decimal Places to numbers in Excel
Lesson 12: Wrap Text in Excel | Break Text to Multiple Lines | Shrink to Fit
Lesson 11: Merge & Center in Excel | Merge Across | Merge Cells
Lesson 10: How to use the INSERT FUNCTION command in Excel
Lesson 9: Simple Subtraction Formula in Excel
Lesson 8: Using the COUNT and COUNTIF function to count ONLY the cells, which contains TEXTUAL data
Lesson 7: Count & CountA function in Excel | Difference between Count and CountA function in Excel
Lesson 6: MIN & MAX function in Excel | Find the Minimum and Maximum value within a range in Excel
Lesson 5: Average Function in Excel | What does Average mean
Lesson 4: Multiplication Formula in Excel | Replicate or Copy Formulas in Excel
Lesson 3: Formatting Cells in Excel | Make a Spreadsheet look visually attractive
Lesson 2: SUM function in Excel | Entering Text & Numbers | FREE Series of Microsoft Excel Lessons
Lesson 1: Introduction to Microsoft Excel | Excel Interface | FREE Series of Microsoft Excel Lessons (pdf guide included)
Hope you are enjoying your learning 🙂
Habib Ali – ICT Tutor
This is one tip that has made my Excel so much easier! Tables are also a good way to keep the headers of your columns visible when scrolling down. Thanks for the great tip.
You’re very welcome Gareth. Take care 🙂
Habib (ICT tutor)
Hello Habib,
I have saved a link to your website on my desktop, as I consider it the best reference to learn Excel. I shared it with some of my friends who use excel too.
Wishing you great success
Rania
Thank you Rania, you are our regular visitor on our site and YouTube channel. We are very happy to help you always and your friends and family. Carry on sharing our site and YouTube with everybody you think will benefit from. Take care 🙂
Habib (ICT tutor)
I’m so grateful that I have all your tutorials to learn about excel! Each and one of them are very detailed and easy to understand. You have an amazing website that will always continue to grow as you’re helping people!
Thank you so much Aminah – I want to help and educate as many people all over the world as I can 🙂
Habib (ICT tutor)
Hi Habib,
Wow! I loved this tutorial. It’s going to come in real handy for all my worksheets.
I use Excell for all my year-end reports and being able to freeze certain rows and columns is going to help tremendously.
Now I wish we could do this with Google docs, lol.
Thank you again, you’re a wonderful teacher.
Suzanne
Thank you and you’re very welcome 🙂 Google docs is a free software and hence it’s not got to the level of Microsoft yet.
Habib (ICT tutor)
I really enjoy learning from you, I would never understand this if I tried to learn it on my own from books. You make it very easy to follow and understand, I can’t wait to read your next lesson.
Jeff
Thank you Jeff, and it is my pleasure. New lessons are already up on my website and YouTubeYouTubeYouTube channel 🙂
Habib (ICT Tutor)
Hey Habib,
That was very helpful, I’m going to bookmark this page to refer back to because I know I won’t be able to remember it all. Very informative.
Thanks,
Tyler
Thank you Tyler. Bookmarking is a good idea, then you can come back as often as you want. Also feel free to watch each lesson a few times for the knowledge to sink in.
Habib (ICT Tutor)
Excellent! That one was new to me! So, after freezing the panes in Excel, can I save them in a new document? I want to practice this, so that I can use this more often.
Yes Christine, you can save them into another spreadsheet after freezing the relevant rows and columns in excel. Take care
Habib (ICT Tutor)