Why is my freeze panes option greyed out?

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. As shown in Figure 4, a colored background behind Protect Workbook indicates that protection is active.

How do I freeze selected panes in Excel 2010?

To freeze columns:

  1. Select the column to the right of the columns you want frozen.
  2. Click the View tab.
  3. Click the Freeze Panes command.
  4. Select Freeze Panes.
  5. A black line appears to the right of the frozen area.

Why is rows to repeat grayed out?

If the [Print Titles] button is locked (greyed out), it may be because you are currently editing a cell or you have chart selected. If the “Rows to repeat at top” spreadsheet icon is locked, it may be because you have more than one worksheet selected within your workbook.

Can you freeze both columns and rows in Excel 2010?

Freeze columns and rows Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Select View > Freeze Panes > Freeze Panes.

How do I unlock freeze panes in Excel?

You’re scrolling down your worksheet (or scrolling to the side), but part of it is frozen in place. This is probably because at some point you decided to freeze the panes. To fix this, click View > Window > Unfreeze Panes.

Why does freeze panes not work in Excel?

The causes of this issue are when your Excel worksheet is in the page layout view, when Windows protection is turned on and also when the Excel sheet is protected by the earlier versions of Excel. Because of all this issues, Excel Freeze Panes Not Work properly.

How do I freeze the first 3 rows in Excel?

To freeze rows:

  1. Select the row below the row(s) you want to freeze. In our example, we want to freeze rows 1 and 2, so we’ll select row 3.
  2. Click the View tab on the Ribbon.
  3. Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.
  4. The rows will be frozen in place, as indicated by the gray line.

How do I get rid of grayed out cells in Excel?

Remove cell shading

  1. Select the cells that contain a fill color or fill pattern. For more information on selecting cells in a worksheet, see Select cells, ranges, rows, or columns on a worksheet.
  2. On the Home tab, in the Font group, click the arrow next to Fill Color, and then click No Fill.

How do I freeze multiple panes in Excel?

How to freeze multiple columns in Excel

  1. Select the column (or the first cell in the column) to the right of the last column you want to lock.
  2. Go to the View tab, and click Freeze Panes > Freeze Panes.

Why are columns greyed out in Excel?

You may have also set the column widths so small that they are not hidden but near impossible to select, if this is the case again highlight all the cells using the previous method, right click on any header and this time try Column Width, set to 5 or 10.

Why is series greyed out in Excel?

The fill series option can’t be used (grayed out) when cells are unlocked and sheet protection is on.