How to Freeze Rows and Columns at the Same Time in Excel

We have an Excel worksheet with information about a company. We’ll freeze the column header and the employee names so they stay on the screen while scrolling.

How to Freeze Rows and Columns at the Same Time in Excel

Method 1 – Using Freeze Panes to Freeze Columns

Steps:

  • Since we’re freezing columns up to column C, select the D column.

Freeze Rows and Columns at the Same Time in Excel Based on Columns

  • Select Freeze Panes from the View tab.
  • From the dropdown list, select Freeze Panes.

How to Freeze Rows and Columns at the Same Time in Excel

  • You can now scroll horizontally with these two columns always visible.

Read More: How to Freeze Multiple Panes in Excel


Method 2 – Applying Excel Freeze Panes to Freeze Rows

Steps:

  • We want to freeze the rows so the information for the first four employees shows, which ends at row 8. So, select row 9.

How to Freeze Rows and Columns at the Same Time in Excel

  • Select Freeze Panes from the View tab.
  • From the dropdown list, select Freeze Panes.

Freeze Rows and Columns at the Same Time in Excel Based on Rows

  • You can now scroll down with these 4 rows always visible.


Method – Adding a Freeze Button to the Quick Access Toolbar to Freeze Columns and Rows at the Same Time

Steps:

  • Click the down arrow from the top of the Excel file.
  • Click More Commands from the drop-down list.

How to Freeze Rows and Columns at the Same Time in Excel

  • Under Choose commands from, select Commands Not in the Ribbon.

Freeze Rows and Columns at the Same Time in Excel Using Magic Freeze

        

  • To freeze rows and columns, select the first cell after the row and column you want to freeze.
  • Click the Freeze Panes button and the columns and rows will be frozen at the same time.

How to Freeze Rows and Columns at the Same Time in Excel

Read More: How to Freeze Panes with VBA in Excel 


Method 4 – Splitting Panes to Freeze Rows and Columns Simultaneously

Steps:

  • We want to freeze the first two rows (information of the first two employees) of the worksheet. So, we will select row 7.

Using Splitting Panes to Freeze Rows and Columns at the Same Time

  • On the View tab, click Split.

How to Freeze Rows and Columns at the Same Time in Excel


Things to Remember

  • You can’t use Freeze Panes and Split Panes simultaneously.
  • You have to select the row(s) below the one you want to be frozen or the column right of the column(s) you need to be frozen.
  • If you want to freeze rows and columns at the same time based on a reference cell, the reference cell must be below the row and to the right of the column you want to freeze.

Download the Practice Workbook


Further Readings


<< Go Back to Freeze Panes | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
ASM Arman
ASM Arman

Abu Saleh Arman is a Marine engineer and Excel & VBA expert. He loves programming with VBA. He finds VBA programming a time-saving tool to manipulate data, handle files, and interact with the internet. He is very interested in Python, MATLAB, PHP, Deep Neural Networks, and Machine Learning, showcasing his diverse skill set. Arman holds a B.Sc in Naval Architecture & Marine Engineering from BUET, Bangladesh. However, he switched to a content developer, where he writes technical content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo