This article explains how to freeze panes in Excel to make sure that certain columns on your worksheet are always visible. By locking a column, it will always remain visible on the screen even when you scroll the sheet to the right or left.
Steps
Step 1. Open the Excel file you want to edit
You can choose to open it directly from Excel by clicking on the menu File and choosing the option You open or you can click on the document icon with the right mouse button directly from the "File Explorer" window.
This method works on Windows and on Mac for the following versions of Excel: Excel for Office 365, Excel web, Excel 2019, Excel 2016, Excel 2013, Excel 2010, and Excel 2007
Step 2. Select a cell located on the right of the column that you want to always make visible
This way the column in question will always be visible even if you move to another place in the worksheet.
To select multiple cells at once, hold down the key Ctrl or Cmd while clicking with the mouse on the cells you want to include in the selection.
Step 3. Click on the View tab
It is located on the Excel ribbon at the top of the program window or on the menu bar at the top of the screen.
Step 4. Click the Freeze Panes icon
A drop-down menu will appear. You will have the option to freeze specific panes or the first row and first column.
Step 5. Click on the Freeze Panes item
This will lock the box next to the columns you have selected.
