How to freeze multiple panes in excel office 365
#HOW TO FREEZE MULTIPLE PANES IN EXCEL OFFICE 365 HOW TO#
The following steps show how to protect critical data while allowing users to enter information in only the fields you want them to access.
Whatever it is, people should just keep their hands off it!įortunately, Excel makes it possible to prevent people from changing things. Maybe it’s equipment part numbers, or a shipping-cost calculation.
No matter which Cell is activated, by using this command the First Row of the Spreadsheet will remain visible while scrolling down in the Spreadsheet. If we have used the command Freeze Panes then we can use the command Unfreeze Panes.įreeze Top Row: Keep The Top Row Visible While Scrolling Through The Rest Of The Worksheet. Unfreeze Panes: Unlock All Rows And Columns To Scroll Through The Entire Worksheet. By using this command, depending which Cell is activated in the Spreadsheet, the Rows above the activated Cells and the Columns at the left of the activated Cell will remain visible while scrolling Down and scrolling Right in the Spreadsheet. Once I select the command Freeze Panes the drop-down menu appears with the following commands available to use and which are the following:įreeze Panes: Keep Rows And Columns And Columns Visible While The Rest Of The Worksheet Scrolls (Based On The Current Selection). This Is Useful For Checking Out Data In Other Parts Of Your Worksheet Without Losing Your Headers Or Labels. Then I must select the View Tab and locate from the right the area of the ribbon named Window as shown below.įrom the Window area of the Ribbon, I select the command Freeze Panes where here I am notified with the following: Freeze A Portion Of The Sheet To Keep It Visible While You Scroll Through The Rest Of The Sheet. That is why I need to activate the Cell A2.
In this Spreadsheet, I need to Freeze the First Row of Spreadsheet, so when I scroll down through the Data, the First Row will always be visible. In the image below, I have opened a Microsoft Excel Workbook which contains different Spreadsheets. If You Want To Learn How To Freeze Panes in a Microsoft Excel Spreadsheet, read the post that follows. It Freezes a Row or Column, so this way it is always displayed even if we navigate up and down through the Spreadsheet. This is how we can lock specific Rows and Columns. In Microsoft Excel and in an area of a Spreadsheet or Worksheet, we can keep an area visible while we scroll to another area.