docs / articles / Freeze Rows & Columns in Excel: Ultimate Shortcut Keys

Freeze Rows & Columns in Excel: Ultimate Shortcut Keys

Sara Jul 09, 2026 2026-07-09 04:40:45

Ever found yourself scrolling through endless rows and columns in Excel, wishing you could freeze certain sections to keep them in view? You're not alone. Excel offers a handy feature to do just that, and learning the shortcut keys can significantly boost your productivity. Let's dive into how to freeze rows and columns in Excel using keyboard shortcuts.

How to Freeze rows in Excel - Excel for beginners
How to Freeze rows in Excel - Excel for beginners

Before we get started, ensure your Excel version is up-to-date. The methods discussed here work best with Excel 2013 and later versions, including Excel for Microsoft 365. Now, let's explore the step-by-step process along with the relevant shortcut keys.

How to Freeze Rows or Columns in Excel
How to Freeze Rows or Columns in Excel

Freezing Rows in Excel

Freezing rows in Excel allows you to keep specific rows visible while scrolling through the rest of the data. Here's how to do it using the shortcut keys:

How to Freeze Rows and Columns in Excel ❄️📊 | Step-by-Step Guide
How to Freeze Rows and Columns in Excel ❄️📊 | Step-by-Step Guide

1. First, select the row below the ones you want to freeze. For example, if you want to freeze rows 1-5, select row 6.

Using the Shortcut Key

Excel Tricks: How to Freeze Rows or Columns in Excel
Excel Tricks: How to Freeze Rows or Columns in Excel

2. Press Alt + A + F + F (where 'A' stands for 'A'lt, 'F' for 'F'reeze). This will bring up the 'Freeze Panes' dialog box.

3. In the dialog box, select 'Freeze Top Row' (or the number of rows you want to freeze) and click 'OK'. The selected rows will now remain frozen while you scroll through the rest of the data.

Using the Ribbon

Excel Keyboard Shortcuts Every Office User Should Know
Excel Keyboard Shortcuts Every Office User Should Know

Alternatively, you can use the 'View' tab in the ribbon to freeze rows:

1. Select the row below the ones you want to freeze.

2. Go to the 'View' tab, click on 'Freeze Panes', and select 'Freeze Top Row'.

How to Freeze, Unfreeze, and Lock Rows, Columns, and Cells in Microsoft Excel
How to Freeze, Unfreeze, and Lock Rows, Columns, and Cells in Microsoft Excel

Freezing Columns in Excel

Similar to freezing rows, you can also freeze columns to keep specific columns visible while scrolling horizontally. Here's how:

Tutorial 📹 | How to Freeze Panes in Excel
Tutorial 📹 | How to Freeze Panes in Excel
a computer screen with the text don't manually adjust columns like this
a computer screen with the text don't manually adjust columns like this
Freeze Cells in Excel
Freeze Cells in Excel
How to Freeze First 3 Columns in Excel (4 Quick Ways)
How to Freeze First 3 Columns in Excel (4 Quick Ways)
🚀 Insert & Delete Rows or Columns in Excel with ONE Keyboard Shortcut  You’ll Never RightClick Again
🚀 Insert & Delete Rows or Columns in Excel with ONE Keyboard Shortcut You’ll Never RightClick Again
How to freeze rows in excel
How to freeze rows in excel
How to Freeze Multiple Rows and or Columns in Excel using Freeze Panes
How to Freeze Multiple Rows and or Columns in Excel using Freeze Panes
Why the Delete Key Does Not Remove Columns in Excel
Why the Delete Key Does Not Remove Columns in Excel
Freeze or Lock Specific Rows and Columns when Scrolling in Excel
Freeze or Lock Specific Rows and Columns when Scrolling in Excel
How to Transpose data from rows to columns in excel
How to Transpose data from rows to columns in excel
Excel Quick Tips: How to Flip Cells & Switch Rows or Columns
Excel Quick Tips: How to Flip Cells & Switch Rows or Columns
Master Freezing Rows and Columns in Google Sheets – A Complete Beginner’s Guide! 📊
Master Freezing Rows and Columns in Google Sheets – A Complete Beginner’s Guide! 📊
Excel Shortcut Keys Cheat Sheet
Excel Shortcut Keys Cheat Sheet
Move Columns Fast in Excel
Move Columns Fast in Excel
How to Freeze Panes in Excel to Keep Rows and Columns Visible - NSF Technology
How to Freeze Panes in Excel to Keep Rows and Columns Visible - NSF Technology
Keyboard Shortcut to Freeze Panes in Excel (3 Shortcuts)
Keyboard Shortcut to Freeze Panes in Excel (3 Shortcuts)
HOW TO FREEZE MULTIPLE ROWS AND COLUMNS (EASY 2-STEP METHOD)
HOW TO FREEZE MULTIPLE ROWS AND COLUMNS (EASY 2-STEP METHOD)
Top 21 Excel Formulas
Top 21 Excel Formulas
Resize Rows and Columns
Resize Rows and Columns
How to Use ROW Formula in Excel
How to Use ROW Formula in Excel

1. Select the column to the right of the ones you want to freeze. For example, if you want to freeze columns A-D, select column E.

Using the Shortcut Key

2. Press Alt + A + F + L (where 'L' stands for 'L'eft columns). This will freeze the selected columns on the left while you scroll through the rest of the data.

Using the Ribbon

Alternatively, you can use the 'View' tab in the ribbon to freeze columns:

1. Select the column to the right of the ones you want to freeze.

2. Go to the 'View' tab, click on 'Freeze Panes', and select 'Freeze First Column'.

Freezing Both Rows and Columns in Excel

Sometimes, you might want to freeze both rows and columns at the same time. Here's how to do it using the shortcut keys:

1. Select the cell below and to the right of the area you want to freeze. For example, if you want to freeze rows 1-5 and columns A-D, select cell E6.

Using the Shortcut Key

2. Press Alt + A + F + A (where 'A' stands for 'A'lt, and the second 'A' stands for 'A'cross). This will freeze the selected area both horizontally and vertically.

Using the Ribbon

Alternatively, you can use the 'View' tab in the ribbon to freeze both rows and columns:

1. Select the cell below and to the right of the area you want to freeze.

2. Go to the 'View' tab, click on 'Freeze Panes', and select 'Freeze Panes'.

And there you have it! You're now well-versed in freezing rows and columns in Excel using both shortcut keys and the ribbon. Happy Excel-ing!