Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel Page Break Won’t Remove? How to Fix ItIf an Excel page break won’t remove, first check whether it is a manual break or an automatic one: select the row…
- Excel Page Breaks: Why There Are Too Many and How to FixIf Excel says there are too many page breaks, the worksheet has reached its page-break capacity, or its print setup is generating…
- Excel Page Break on Row: How to Set and Fix ItTo put a page break above a specific row in Excel for Microsoft 365 on Windows, select that row by clicking its…
- Excel Page Break Not Going Away? Fix Persistent LinesIf an Excel page break will not go away, first switch to View > Normal; if the line still appears, turn off…
- Excel Page Break Not Removing? How to Fix ItIf an Excel page break will not go away, first check whether it is a manual break or an automatic page boundary:…
- Excel Page Breaks for Printing: Set, Preview, and FixTo control where a printed worksheet splits, open View > Page Break Preview, then drag a blue page-break line to the desired…
- Excel Not Responding: Fix Margins That Do Not Fit a PageIf Excel says the margins do not fit the page and then stops responding, first give it a moment, then check the…
- Excel Not Responding After Copy and Paste? Fix ItIf Excel says “Not Responding” after you copy and paste, first give it a little time: a large paste or recalculation can…
- Excel Freeze Panes Not Working? Fix Common Excel IssuesIf Excel won’t freeze panes, first switch to View > Normal, click the cell just below and to the right of the…
- Excel Not Inserting Page Breaks? Fix the Print SetupIf Excel is not inserting a page break, first switch to View > Page Break Preview, select the row below or column…
- Excel Named Range Error? Causes and FixesAn Excel named range error usually means the name is invalid, unavailable in the current worksheet or workbook, or points to cells…
- Excel Named Range Not Working? Fix the Common CausesIf an Excel named range is not working, check that the name exists, has the right workbook or worksheet scope, and refers…
- Excel Merged Cells Not Showing in Filter? Fix the DataExcel filters do not treat a vertically merged cell as though its value were repeated in every row: the value exists only…
- Excel Keeps Not Responding When Copy Paste?If Excel keeps showing Not Responding when you copy and paste, first wait briefly, then press Esc once and try copying a…
- Excel Is Not Responding: How to Save Your WorkIf Excel is not responding, wait briefly for it to finish, then try Ctrl+S once on Windows (or Command+S on Mac). If…
- Excel Insert Row Shortcut Not Working? Fix ItIf Excel’s insert-row shortcut is not working, first exit cell-editing mode, select the row or cell where the new row should go,…
- Excel Insert Row Not Working? Fix the Common CausesIf Excel will not insert a row, select the row number where you want the new row, then choose Home > Insert…
- Excel Insert Page Break Not Working? Fixes That HelpIf Excel’s Insert Page Break command is unavailable or the break does not appear where you expect, first select the correct row…
- Excel Circular Reference: Find the Cell and Fix ItIn Excel for Microsoft 365 on Windows, choose Formulas > Error Checking > Circular References, then click the listed cell to jump…
- Excel Hyperlink Not Opening? Fix Common Link ProblemsIf an Excel hyperlink is not opening, first check whether Excel requires Ctrl+click, then verify the link’s destination and your default app…
- Excel Hyperlink to Another Sheet Not Working? FixesIf an Excel hyperlink to another sheet is not working, check that the destination sheet exists and is visible, then recreate the…
- Excel Group Rows Not Working? Fix the Common CausesTo group rows in Excel for Microsoft 365 on Windows, select the row numbers, then choose Data > Outline > Group. If…
- Excel Goal Seek Not Working? Fix These Common ProblemsIf Excel Goal Seek is not working, first confirm that the Set cell contains a formula linked to the By changing cell,…
- Excel Freeze Panes Wrong Selection? How to Fix ItIf Excel freezes the wrong rows or columns, first choose View > Freeze Panes > Unfreeze Panes, then select the cell one…
- Excel Freeze Panes Not Working? Fix the ViewIf Excel Freeze Panes is not working, switch to Normal view, select the cell below and to the right of the rows…
- Excel Freeze Panes Not Working on Selection? Fix ItIf Excel Freeze Panes is not working on your selection, first select the cell immediately below the rows and to the right…
- Excel Freeze Panes Not Working? Fix the Common CausesIf Excel Freeze Panes is not working, first choose the cell just below the rows and to the right of the columns…
- Excel Freeze Panes Not Available? Fix ItWhen Freeze Panes is unavailable or grayed out in Excel for Microsoft 365 on Windows, first exit cell-editing mode by pressing Enter…
- Excel Freeze Panes Not Freezing Selection? Fix ItExcel Freeze Panes does not lock the cell or range you select; it keeps the rows above and columns to the left…
- Excel Freeze Panes Freezes Too Many Rows? Here’s the FixExcel Freeze Panes freezes too many rows when the active cell was below the row you meant to keep fixed: Excel freezes…