How to freeze columns in Excel ?
|
Excel
|
5 months ago
|
Excel
6 Steps
This document will guide you through the steps of freezing columns in Excel. Freezing columns keeps them visible while you scroll through your data, making it easier to navigate large spreadsheets. You'll learn how to freeze one or multiple columns, as well as how to unfreeze them when you're done.
How to freeze columns in Excel ?
|
Excel
|
Excel
6 Steps
1
Open Excel and open the workbook you want to work on.
Ensure you are on the correct sheet where you want to freeze the columns.
2
Click on the letter at the top of the "Column" you want to freeze.
This selects the entire column. For example, if you want to freeze Column A, click on the "A" header.
3
Navigate to the top menu and click on the "View" tab.
This tab contains options for changing how you view your spreadsheet.
4
Look for the "Freeze Panes" button in the Window group and click on it.
This will open a dropdown menu with freeze options.
5
From the dropdown menu, click on "Freeze First Column"
This option will freeze the first column (Column A) so it remains visible as you scroll horizontally.
6
Now, as you scroll through your worksheet, the frozen "Column" will remain visible.
By following these steps you can freeze columns in Excel
