Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel Not Responding: How to Fix ItIf Excel says Not Responding, first give it a few minutes to finish any calculation or file operation, then try opening Excel…
- Goal Seek Cell Must Contain Value Error in ExcelIn Excel, the Goal Seek message “Cell must contain a value” usually means the cell in the By changing cell box is…
- Flash Fill Error in Excel? Causes and FixesA Flash Fill error in Excel usually means the feature did not recognize your example pattern, is turned off, or guessed the…
- Excel Won’t Let Me Freeze Panes? Fixes to TryIf Excel will not let you freeze panes, first switch to View > Normal, finish editing any cell, and make sure you…
- Excel.exe Not Responding? Fix Excel Freezes on WindowsIf Excel.exe says “Not Responding,” give Excel a few minutes if it may be calculating, then check whether the freeze affects one…
- Excel Won’t Insert a Page Break? Fix the Common CausesIf Excel won’t insert a page break, select the row below or column to the right of where the split should go,…
- Excel Won’t Add a Page Break? Fix It in Print SetupIf Excel won’t add a page break, select the row below the intended horizontal break (or the column to the right of…
- Excel Flash Fill Not Working? Fix It and Use It ProperlyIf Excel will not Flash Fill, enter one or two examples in the output column, select the next cell, and press Ctrl+E…
- Excel Unable to Remove a Page Break? Find the Right FixIf Excel will not remove a page break, first check whether it is manual or automatic: select the cell just below a…
- Excel Text to Columns With Dates: Fix Date FormatsTo convert text dates in Excel, select the cells, choose Data > Text to Columns, move through the wizard to Step 3,…
- Excel Stop Circular Reference Warning? Fix or Allow ItTo stop an Excel circular reference warning, first remove the formula loop using Formulas > Error Checking > Circular References to find…
- Excel Spreadsheet Hyperlinks Not Working? Fixes to TryIf Excel spreadsheet hyperlinks are not working, first check that the link’s address is correct and that the destination still exists; then…
- Excel Solver Too Many Variable Cells? Fix the 200-Cell LimitExcel’s built-in Solver add-in allows up to 200 changing variable cells in a model. If your model needs more, reduce the number…
- Excel Solver Not Working? Fix Setup and Model ErrorsIf Excel Solver is not working, first make sure the Solver Add-in is enabled in desktop Excel, then check that your objective…
- Excel Solver Not Opening? Fix the Add-InIf Excel Solver is not opening, enable its add-in in desktop Excel: go to File > Options > Add-ins, select Excel Add-ins…
- Excel Shortcut Keys Not Working? Fix the Common CausesIf Excel shortcut keys are not working, first check whether you are editing a cell, using Excel for the web, or pressing…
- Excel Set Print Area Not Working? Fix the Common CausesIf Excel’s print area is not working, select the intended cells and choose Page Layout > Print Area > Set Print Area,…
- Excel Scatter Plot Not Using X Values? Fix ItIf an Excel scatter plot is not using your intended X values, change the chart to an XY (Scatter) chart, then check…
- Excel Scatter Plot: Connect Dots, Choose Lines, Fix IssuesYes. To connect points in an Excel scatter plot, choose a scatter chart type with lines: select Insert > Insert Scatter (X,…
- Excel Remove Duplicates Not Working? Fix the Real CauseIf Excel’s Remove Duplicates command appears not to work, select the full table, choose Data > Remove Duplicates, and check that the…
- Excel Protect Sheet Not Working? Causes and FixesIf Excel sheet protection seems not to work, first check that the sheet is actually protected and that the cells you expect…
- Excel Protect Sheet From Being Viewed? The Real FixNo: Excel’s Protect Sheet feature stops or limits edits; it does not prevent someone from viewing the sheet’s contents. To keep a…
- Excel Print Area Too Small? Fix Scaling and MarginsIf an Excel printout is too small, first check the print scaling: in Windows Excel, open File > Print and change the…
- Excel Print Area Won’t Clear? Fix Stuck Print SettingsIf an Excel print area will not clear, select the affected worksheet and choose Page Layout > Print Area > Clear Print…
- Excel Print Area Not Working? Common FixesIf Excel is printing the wrong cells or ignoring a print area, select the intended range and choose Page Layout > Print…
- Excel Page Breaks Won’t Clear? Fix Persistent LinesIf Excel page breaks won’t clear, first select the affected worksheet and choose Page Layout > Breaks > Reset All Page Breaks.…
- Excel Page Breaks Won’t Reset? Fix View and Print SettingsTo reset page breaks in Excel for Microsoft 365 on Windows, select the worksheet, choose View > Page Break Preview, then choose…
- Excel Page Breaks Messed Up? How to Fix Print LayoutIf Excel page breaks are messed up, switch to View > Page Break Preview to see what is controlling the pages, then…
- Excel Page Breaks: How to Insert, Remove, and Fix ThemAn Excel page break determines where worksheet content moves onto the next printed page. In Microsoft Excel for Microsoft 365 on Windows,…
- Excel Page Break Won’t Move? Fix the Common CausesIf an Excel page break will not move, switch to View > Page Break Preview and drag the break line to a…