I can’t see the first row unless I scroll up. Now if I scroll down 1 row then I can see from Row 2 to 22. It depends on your display size, row/column size also whether your worksheet is zoomed in or out. Usually, in general settings, we can see 21 rows and 21 columns in our display. The term freeze pane in excel indicates your row, column or sometimes both stay visible and in the same place whether you scroll or not. How to Freeze Multiple Rows and Columns in Excel #ExcelTutorial #ExcelTips #ExcelBeginner #ExcelatWork Sharyn’s using the desktop version of Excel for Office 365 as part of the Office 365 Business Premium subscription. Try this with Excel 2007, 2010, Excel 2013, Excel 2016, Excel 2019 and Excel for Office 365. 🔔 Become an Excel at Work Insider (100% free) and be FIRST TO KNOW about new videos, blogs and special offers: 🤍 Your free self-assessment tool where you can gauge your current skill level in Excel and create your very own personal learning plan 🤍 📥 FREE GUIDE: Grab your copy of our 'STEPS to becoming proficient in Excel' guide.

Learn how to Freeze Panes and Unfreeze Panes so that you can control exactly what you see on your screen.Ġ2:28 How to remove Freeze Panes using Unfreeze in ExcelĠ2:42 How to freeze multiple rows in ExcelĠ4:48 How to freeze multiple rows and columns in Excel The Excel feature, Freeze Panes, allows you to lock parts of your screen so that they don't disappear when you scroll down or across in your worksheet. Learn how to freeze the top row or freeze multiple rows in Excel so that row headings stay visible as you scroll, and how to freeze columns in Excel including columns other than just column A. How to Fixed Header Line in Excel, How to Fixed first Column in Excel, How to Fixed First Row in Excel using freeze panes option, whenever need you can also unfreeze panes in Excel.

You can fixed Multiple Rows or fixed Multiple Columns in Excel.

If you want to fixed rows or fixed columns in MS Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 then this video tutorials for you. Video also describes how to fixed multiple rows and columns in Microsoft Excel 2007/2010/2013/2016 using freeze panes option. Learn How to Freeze Multiple Columns and Rows in Microsoft Excel, how to freeze multiple columns in Excel, how to freeze multiple rows in Excel, how to freeze and unfreeze multiple rows and columns in Excel, How To Lock Row and Column in Excel, How To Lock Rows and Columns in Excel, How To Fix Row in Excel, How To Fix Column in Excel, How to Freeze Row and Column in Excel, How to Freeze Rows and Columns in Excel, this video tutorial is showing How to freeze panes to keep column and row headings visible regardless of scrolling.

How to freeze top 3 rows in excel