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.

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.

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:

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

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

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'.

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




















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!