Quick wins for a faster PC:
Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Clear out junk files and repair common Windows errorsFree Scan →Fix a spreadsheet formula safely by first preserving the original, identifying whether the problem is an error, text, stale result, or wrong input, and then changing the smallest possible part of the formula. Edit one cell in place when formatting must remain untouched; use fill or copy only after deciding which references should move; and verify both the calculated result and the cell’s appearance afterward.
Start with a safe diagnosis
A displayed error is a symptom, not a diagnosis. The same visible problem can come from a deleted cell, a mistyped function, text stored where a number is expected, a missing equals sign, a circular reference, or a formula that is valid but points to the wrong inputs. Microsoft’s Excel guidance also warns that built-in error checking flags common patterns but cannot guarantee that every worksheet error has been found.
As an Amazon Associate I earn from qualifying purchases.
1. Preserve the original workbook
For a consequential workbook, save a separate copy before making structural edits. If the file is stored in a service with revision history, confirm that you can restore a known-good version. This gives you a recovery path if an attempted repair changes more cells or formatting than intended.
2. Record the application and symptom
Write down whether you are using Excel or Google Sheets, and whether it is the desktop, web, or mobile version. Then classify what you see:
#1 Best Overall
- [Ultra-Lightweight Ear Buds Designed for Small Ears] Each earbud weighs only 3.7g and features a compact, ergonomic in-ear design made especially for small ears. Secure, low-profile, and comfortable for workouts, all-day wear or overnight sleeping.The ultra-slim profile sits flush in your ear with no hard edges poking or rubbing, so you can even sleep on your side without discomfort.
- [Immersive Stereo Sound with TOZO OrigX Technology] TOZO OrigX tuning delivers clear vocals, balanced mids, and natural stereo sound for music, podcasts, and videos.
- [Long Battery Life for Daily Use] Get up to 7 hours of playtime on a single charge, with up to 32 hours total using the charging case—ideal for workdays, commuting, and extended listening sessions.
- [Bluetooth 5.3 & Stable Connection] Bluetooth 5.3 provides fast pairing, stable wireless performance, and reduced dropouts as you move around home or office.
- [Deep Bass with Clear Vocals] High-performance drivers produce punchy bass while keeping vocals clean and detailed for everyday listening.
- An error value such as
#REF!,#VALUE!,#DIV/0!, or#NAME?. - A formula displayed literally instead of a result.
- A stale or unexpected number with no visible error.
- A correct number in a cell whose number format, fill, border, or conditional formatting changed.
These cases require different repairs. Do not replace a formula merely because its displayed value looks surprising.
3. Inspect the formula text and its inputs
Select the cell and read the formula in the formula bar or input line. Confirm that it starts with =, that function names and separators are spelled correctly, and that parentheses are balanced. Check every referenced cell and whether each source contains the expected type of data. Compare the formula with a nearby cell that is known to work; compare the pattern of references, not just the displayed values.
Repair the smallest relevant part
Once the cause is known, change only what is necessary. Editing a single destination cell in place is usually the safest option when you need to preserve its existing formatting. Structural changes such as deleting rows, inserting columns, or pasting a range can affect many formulas and formatting rules at once.
Free tools Windows power users keep installed
One-click scans. No signup required.
Formula shown as text or not calculated
In Excel, a formula normally begins with =. A missing equals sign leaves an expression as text rather than calculating it. Check that the cell entry begins with the equals sign and that the destination has not been configured to treat formulas as text. The exact cause of text display can vary by workbook settings, so inspect the cell rather than assuming that adding = is always sufficient.
Sheet names that contain spaces
A worksheet name containing spaces or other non-alphabetic characters needs single quotation marks in a reference. For example:
Rank #2
- 【IP68 Waterproof Multifunctinal Smart Watch】Torjalph fitness activity tracker smart watch is IP68 waterproof technology ,you can wear it when swimming,handwashing,it's rain-proof which means that you perform multiple exercise modes outside without worrying about sweat or rain corroding your fitness smart watch,and this watch equipped with a 230 mAh large capacity battery magnetic charging ,and this sports activity tracker watch can be used 5-7 days If fully charged.
- 【Larger 1.83'' Full Screen Watch & Multi-dial Selection】1.83 inch full HD color touch screen smart watch for men / women provides excellent 240*284 resolution image quality ,This Bluetooth smart watch offers a better touch experience and remarkable immersion and ,more than 200 watch faces for you to choose from App"Da Fit ", you can change the dial style according to your mood to wear keeping the world on your wrist
- 【Accurate Activity Tracker Smart Watch 】sports watch activity tracker uses sweat and dust resistant breathable silicone strap, our Fitness Tracker Smart Watch for Android iOS Phones supports 12 sports modes,walking,running,bicycle,swimming,badminton,basketball,football,rope skipping. This bluetooth calls smart watch for men women is lightweight and stylish, bringing more convenient and relaxing sports experience while also providing more protection.
- 【Your 24 Hour Personal Daily Health Monitor】Fitness watch for women men full touch screen IP67 waterproof bluetooth smartwatch for Android iOS Phones with heart rate blood pressure monitor multifunction Andriod smart watch with steps counter sleep monitor sports fitness watch, monitoring blood oxygen saturation allows you to understand your physical condition in real time to track fitness progress ,to know your health status in time.
- 【More Functions Bluetooth Call Smart Watch】This fitness activity smart watch full screen for iPhone and Android phones includes a bunch of new features including:The bluetooth smart watch can hang up the phone, receive and display WhatsAPP /Text /Facebook /Twitter /Messenger reminder.Support sedentary reminder, alarm clock, stopwatch, timer,weather information,music control, remote camera control compatible with Android 5.0 and above or iOS 9.0 and above smartphones.
='Quarterly Data'!D3If the formula refers to another workbook, the workbook and sheet portions must remain in the external-reference syntax. A missing or invalid workbook name can produce #REF!, especially after a file has been moved or renamed.
Wrong data type
#VALUE! can indicate incompatible data types. Inspect the source cells for text that looks like a number, unexpected blanks, dates stored as text, or values returned by another formula. Correct the input or adjust the calculation only after deciding which type the business rule requires.
Crashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minuteWindows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallFixing #REF! without hiding the problem
Excel uses #REF! when a formula contains an invalid cell reference. Deleting a referenced cell, or pasting over it in a way that destroys the original reference, are common causes.
Recover from an accidental deletion
- Use Undo immediately if the deletion or overwrite was the last structural action.
- If Undo is no longer available, open your saved copy or revision history and identify the intended cell or range.
- Rebuild the formula with the intended references. Do not wrap the error in a function merely to make the cell look blank; that hides the broken dependency.
- Recalculate and compare the result with a known example or an independent calculation.
Prefer a resilient range when the logic calls for one
A formula that separately lists cells can be more vulnerable to an interior deletion than a continuous range. In Microsoft’s documented example, a range such as =SUM(A2:C2) can update more predictably when a cell inside the range is deleted than a formula that lists each reference separately. Use a continuous range only when every cell in that span belongs in the calculation; widening a range to avoid an error can silently include data that should be excluded.
Check for omitted neighboring data
An unexpected total may be a valid formula that stops one cell too early. Compare the formula’s referenced range with the populated cells immediately around it. Excel can flag formulas that omit adjacent populated cells, but treat the warning as a prompt to review the intended range, not as proof that the formula is wrong.
Rank #3
- [Low Noise High Fidelity] New bee guitar cord with 22AWG oxygen-free-copper center conductors provides enhanced signal transfer, the PVC insulation material and the high-density stranded copper double shield provide noise rejection for quiet operation
- [Ideal for Choice] New bee 1/4 straight and right angle metal connectors, ensures a secure connection in any instrument, pedal, or amp jack. L shape great fro on stage guitar stands
- [Wide Compatible] Suitable for mixer, power amplifier, microphone, effector, decoder, equalizer, electoronic organ, electric guitar, electric bass and other electronic equipments. Widely used in the installation of smart home, karaoke speaker, professional stage audio, etc
- [Easy Disassemble] Making incidental repairs quick and easy! Very nice, flexible cable
- [Dont Hesite to Order] 24 hours customer services and professional technology team are standing by
Control what changes when you copy a formula
Copying is safe only when you decide which parts of a reference should move. In both Excel-style notation and Google Sheets, A1 is relative: its row and column can change when the formula is filled. Dollar signs lock individual dimensions:
Do these 3 things before closing this tab:
1Clear out junk files and repair common Windows errors2Scan for outdated or missing drivers - takes under a minute3Repair Windows errors before they cause bigger problems| Reference | What moves when copied | Typical use |
|---|---|---|
A1 |
Column and row both move | A calculation that follows each row and column |
$A$1 |
Neither column nor row moves | A single fixed rate, date, or assumption |
$A1 |
Column A stays fixed; row moves | Copying down while always reading column A |
A$1 |
Row 1 stays fixed; column moves | Copying across while always reading a header row |
Set the locks before filling
Suppose a row calculates a quantity in column B multiplied by one fixed rate in cell $F$1. Entering =B2*$F$1 in the first row lets the B2 reference become B3, B4, and so on when filled down, while the rate remains in F1. If you use F1 instead, the rate reference will drift as the formula is copied.
Google Sheets documents using $ for absolute references and an F4 shortcut while entering a formula on supported desktop configurations. Shortcut behavior depends on the operating system, keyboard, and language. If F4 does not cycle the reference style, type the dollar signs directly.
Compare a working neighbor before filling
Look at the formulas on both sides of the damaged cell. A row or column that behaves differently may have one missing dollar sign, an off-by-one row, or a different sheet reference. Copy the formula pattern only after confirming that the neighboring row is the correct model.
Change formulas without changing formatting
A formula edit and a cell copy are different operations. Editing the formula in the destination cell changes the calculation while normally leaving that cell’s number format, borders, fills, and conditional-formatting setup in place. Copying or pasting a source cell can bring additional properties with it.
Rank #4
- Digital Family Calendar: BSIMB digital calendar wall touch screen puts an end to your chaotic life. Designed for busy families, the digital calendar keeps you organised and in step with your family. Assign different colours and tasks to each family member to make family scheduling easier and more intuitive.
- Easy Setup and Auto-Sync: Plug in, connect to WLAN and auto-syn your electric calendar in minutes. Digital wall calendar compatible with Google calendar, iCloud calendar, Outlook calendar, Cozi calendar and Yahoo calendar. Add events directly on the device or through the ecalendar app. Electronic calendar stays current whether you're at work or traveling—no manual updates needed.
- All-In-One Home Assistant: Smart calendar builds habits and encourage independence with personalised chores. Display daily meal plan to reduce the daily ‘What's for dinner?’ stress. To-do lists keep track of everything you want. Turning chores into valuable achievements with stars and rewards, making life easier and more enjoyable.
- Manage Anytime Anywhere: BSIMB electronic calendar for family stay connected with the powerful ecalendar app. Access and manage your digital wall calendar anytime, anywhere with free features like stars & rewards, photo screensaver, chore charts, meals plans, to-do lists etc. Electronic planner paid features like Magic Import tailor advanced tools for users with special needs.
- Stay in Touch with Loved Ones: Share photos or videos from your phone to electronic wall calendar with app, instantly update your life moment, and keep in touch with your family, especially those who are far away; you can also surprise your smart calendar digital wall by sending him a wish card; it's also great for keeping tech-illiterate elders in touch with the youngsters.
Choose the method that matches the goal
| Goal | Safer method | What to check |
|---|---|---|
| Correct one formula | Edit the destination formula in place | Reference text, result, and existing appearance |
| Repair repeated formulas down a column | Fill or copy a verified formula | Relative and absolute references in every row |
| Restore a formula broken by deletion | Undo the structural edit or rebuild the intended reference | Other formulas that depended on the deleted cell |
| Replace only displayed values | Use a values-only paste only when formulas are intentionally not wanted | Values-only paste removes formulas; it is not a formula repair |
| Investigate a dependency loop | Use circular-reference tracing tools | Whether the loop is intentional and whether another sheet is involved |
Conditional formatting can travel with a paste
Google Sheets documents that copying and pasting a cell or range also applies the source range’s conditional-formatting rules to the pasted area. After a repair that uses copy or fill, inspect the destination’s conditional rules as well as its number format, border, and fill. A formula can be correct while the visual highlighting now refers to the wrong rows or columns.
Google Sheets provides Ctrl+Shift+V for Paste values only on supported desktop configurations. This preserves the displayed values but removes formulas, so it is appropriate only when the destination is deliberately being converted to static values. It cannot repair a formula while retaining the formula logic.
Diagnose common Excel errors
| Symptom | Likely issue to inspect | Repair direction |
|---|---|---|
#REF! |
Deleted, overwritten, or otherwise invalid reference | Undo if possible, restore the structure, or rebuild the intended reference |
#VALUE! |
Incompatible data types in one or more inputs | Inspect source cells and correct the data or calculation rule |
#DIV/0! |
Division by zero or a blank denominator | Decide what a missing denominator means before adding a guard |
#NAME? |
Mistyped function or reference syntax | Check spelling, separators, and quoting of sheet names |
| Unexpected total | Range omits adjacent populated cells or includes unintended cells | Compare the referenced range with the actual data boundaries |
| Circular-reference warning | Formula chain eventually points back to itself | Trace the loop and remove the unintended dependency |
Handle division errors according to the business rule
Microsoft gives =IF(B1,A1/B1,0) as an example that avoids division by zero or a blank denominator. Returning zero is correct only when zero represents the intended meaning of a missing or zero denominator. In other models, a blank, an explanatory label, or a deliberate error may be more accurate. Do not suppress the warning without deciding what the result should mean.
Find and repair circular references
A circular reference is not the same as a broken cell reference. It occurs when a formula depends on itself directly or through a chain of other cells. The result may be an error, a warning, or an iterative calculation that appears to work while producing an unintended value.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Use Excel’s desktop auditing path
- Open the Formulas tab.
- Choose Error Checking, then Circular References.
- Select each listed address to jump to the cells in the loop.
- Use Trace Precedents and Trace Dependents to follow the arrows through the calculation chain.
- Edit the formula, move the calculation to a different cell, or remove the unintended dependency.
If the list appears clear but the warning remains, the loop may involve another worksheet or workbook. Desktop auditing tools are generally more complete than the corresponding web or mobile interfaces. Some financial and engineering models intentionally use iterative calculations; do not enable iteration merely to silence an unexplained warning.
Google Sheets controls that help with repairs
Google’s desktop keyboard help documents these shortcuts, although mappings vary by operating system, keyboard, and language:
| Action | Windows/Chromebook-style shortcut documented by Google | Use during repair |
|---|---|---|
| Undo | Ctrl+Z |
Reverse an accidental deletion, paste, or fill |
| Fill down | Ctrl+D |
Extend a verified formula pattern downward |
| Fill right | Ctrl+R |
Extend a verified formula pattern across columns |
| Paste values only | Ctrl+Shift+V |
Paste static results when formulas are intentionally excluded |
| Show formulas | Ctrl+`~ |
Reveal formula text across the sheet for pattern checking |
| Cycle reference styles while entering a formula | F4 |
Switch relative and absolute row/column locking where supported |
Google Sheets conditional-formatting rules often need absolute references, especially when one rule is intended to evaluate a fixed column or row. Review the rule’s references after filling or pasting, because copied rules are applied to the pasted range.
Optional assisted suggestions in Google Sheets
A Google Workspace Updates announcement dated June 22, 2026 describes a Gemini in Sheets capability that can analyze surrounding data structure and suggest an explanation and corrected formula for a formula error. Availability depends on the account and supported context. Treat any suggestion as a hypothesis: compare it with the workbook’s intended business rule, inspect every referenced cell, and verify the resulting value before accepting it. An automated suggestion cannot determine whether a zero, blank, or error is the correct business meaning for your model.
Verify both logic and appearance
A formula can be syntactically accepted and still be wrong. Verification should cover the calculation, the dependency, and the presentation.
- Re-read the formula. Confirm the sheet names, ranges, operators, and dollar signs.
- Check the inputs. Make sure the referenced cells contain the intended records and data types.
- Compare with a known case. Use a row whose result has been calculated independently or can be checked by hand.
- Inspect neighboring formulas. Look for an inconsistent row, omitted populated cell, or reference that moved unexpectedly.
- Inspect formatting. Confirm number format, decimal places, date display, borders, fills, and conditional-formatting rules.
- Recalculate or reopen if needed. A stale display can make a correct formula appear unchanged; confirm the workbook has updated.
- Save a new revision. Keep the repaired copy separate until the result has been reviewed.
Choose the repair approach by risk
Use an in-place edit when one formula is wrong and preserving the destination’s formatting is the priority. Use fill or copy when the same corrected pattern belongs across many rows or columns, but lock references first and inspect the pasted formatting. Use Undo or a revision restore when a structural deletion caused #REF!; rebuilding a formula is safer than masking the error. Use circular-reference tracing when the problem is a dependency loop, and keep intentional iterative models separate from accidental loops. An assisted suggestion can save time in Google Sheets, but it still requires a human check against the intended logic.
When to stop and gather more context
The title of a workbook, the exact formula, the application, and the platform all affect the correct fix. Pause before editing when the formula is ambiguous, the workbook feeds payroll, tax, financial reporting, laboratory results, or another high-impact process, or when several sheets and external files are linked. Capture the exact error text, the formula as shown, the names of the referenced sheets, and the last structural change. That information is more useful than repeatedly replacing formulas until the displayed value looks plausible.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
