To enable Freeze Panes again, you must unprotect the workbook: As shown in Figure 4, a colored background behind Protect Workbook indicates that protection is active. Why is my Freeze Panes button greyed out?įigure 3: The Windows option is permanently grayed out in Excel 20 due to changes in how windows are managed. A black line appears below the rows that are frozen in place.For example, if you want rows 1 and 2 to always appear at the top of the worksheet even as you scroll, then select row 3. Select the row below the rows you want frozen.How do I turn on freeze panes in Excel 2010? What to do when Excel wont work in Windows 10?.Why does my Excel workbook freeze when I open another window?.How can I freeze rows and columns in Excel?.What does freeze panes do in Excel 2010?.What is the shortcut to Unfreeze Panes in Excel?.How do you freeze panes in numbers on iPad?.
How do I freeze both rows and columns in Excel?.Why can’t I freeze multiple panes in Excel?.Why doesn’t freeze panes work in Excel?.How do I freeze multiple panes in Excel 2010?.Why is Excel not letting me freeze panes?.How do you freeze panes in Excel for iPad?.Why is my Freeze Panes button greyed out?.How do I turn on freeze panes in Excel 2010?.
0 kommentar(er)
