If the worksheet is in the Page Layout view, switch to the Normal view because the Freeze Panes is not compatible with Page Layout view.
Why are my Excel options greyed out?
When the actions that you are attempting to perform in a worksheet apply to a protected cell or sheet, you will see grayed-out menus. You must unprotect the workbook, worksheet or cell to unlock the unavailable menus. If the worksheet is password-protected, Excel will not unlock the menus until you enter your password.
How do I unlock freeze panes in Excel?
To unfreeze panes, open your Excel spreadsheet. Select the View tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Windows group. Then click on the Unfreeze Panes option in the popup menu. Now when you move around in your spreadsheet, columns and rows should display as normal.
Why is my freeze pane greyed out?
Figure 2: Enabling the Windows option for Workbook Protection disables the Freeze Panes command. Figure 3: The Windows option is permanently grayed out in Excel 2013 and 2016 due to changes in how windows are managed. To enable Freeze Panes again, you must unprotect the workbook: Choose Review.
Why can’t I freeze multiple panes in Excel?
Freeze rows or columns You cannot freeze rows and columns in the middle of the worksheet. The Freeze Panes command is not available when you’re in cell editing mode (that is, you’re entering a formula or data in a cell) or when a worksheet is protected. To cancel cell editing mode, press Enter or Esc.
How do you unfreeze cells in Excel 2007?
Why Cannot scroll down in Excel?
Re: My excel spreadsheet won’t scroll down You can normally toggle Scroll Lock off and on by hitting the Scroll Lock key on your keyboard. If you don’t have a scroll lock key on your keyboard do this… That should bring up the on-screen keyboard, click on the “scroll lock” key to toggle off that option.
How do you freeze panes on Microsoft Excel?
Freeze Panes in Excel: Instructions To freeze panes in both columns and rows in a worksheet, select the cell below the row and to the right of the column to freeze. Click the “View” tab in the Ribbon. Then click the “Freeze Panes” button in the “Window” button group. Then choose the “Freeze Panes” command from the drop-down menu.
How to freeze multiple panes in Excel?
Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
What does it mean to freeze panes in Microsoft Excel?
Freeze Panes. Freeze Panes is a feature in Microsoft Excel and other spreadsheet applications that allows a row or column to lock in place, making it always visible when scrolling vertically or horizontally through an open document.
How to remove panes in Excel?
The easiest way to get rid of the panes is to simply double-click on the divider bar you want to remove. (The divider bars appear in the right or bottom scrollbar areas.) Another easy way to get rid of panes is by choosing the Remove Split option from the Window menu. ExcelTips is your source for cost-effective Microsoft Excel training.
