If you work with large spreadsheets in Microsoft Excel, you know how frustrating it is to scroll back and forth between different parts of the document. The Freeze Panes shortcut lets you lock specific rows and columns in place so you can see them at all times, no matter where you scroll. Here's how to use it.
First, open your Excel document and select the cell where you want to split the screen. For this example, we'll split the screen at cell B2. Then, click the View tab at the top of the window and click Freeze Panes in the Window group. You can also press Alt+W, then F to access this menu. A drop-down menu will appear. Click Freeze Panes.
Your screen should now be split. The top part of the screen will remain stationary, even as you scroll down the document. You can scroll to the right to see more columns, but the leftmost column will always be visible. To scroll back up, simply click the cell where you want to split the screen and press the Up arrow key on your keyboard. The top part of the screen will scroll up as well.
You can also freeze multiple rows or columns at once. To do this, select the cell that is below the row you want to freeze and to the right of the column you want to freeze. Then, follow the same steps as above. The screen will be split into four quadrants, with the selected cell in the bottom-right corner. You can scroll in any direction to see different parts of the document, but the selected cell will always be visible.
If you want to remove the split screen, simply click the View tab and click Freeze Panes again. Then, click Unfreeze Panes from the drop-down menu. You can also press Alt+W, then U to access this menu. The split screen will be removed and you can scroll freely around the document.
The Freeze Panes shortcut is a great way to keep track of different parts of a large Excel document. By freezing specific rows and columns, you can scroll through the document without losing your place. Give it a try the next time you're working with a large spreadsheet.