Repair guides and buying advice — Page 36
Understand the fault. Check the fit. Make a better-informed choice for your technology.
1,602 guides · Page 36 of 45
Windows startup and recoveryWindows update installation while using an external display: diagnostic checks
For Windows update installation while using an external display, start by recording the exact symptom and comparing one controlled change. Check whether the computer is running but displaying its picture on another…
Read guide →
BackupRestore an older file with File History without overwriting work
If File History contains the needed version, inspect it and restore to another location first. This lets you compare it with the current file without…
Read guide →
Office helpExcel columns split across pages: adjust the print layout
Review paper size, orientation, print area and scaling. Fitting a wide sheet to one page may make the text too small, so check readability as well as page…
Read guide →
Display and monitor troubleshootingUSB-C video output when text looks incorrectly sized: diagnostic checks
For USB-C video output when text looks incorrectly sized, start by recording the exact symptom and comparing one controlled change. Record resolution and scaling separately for each screen. Confirm the computer’s port…
Read guide →
Windows startup and recoveryWindows update installation with a newly connected peripheral: diagnostic checks
For Windows update installation with a newly connected peripheral, start by recording the exact symptom and comparing one controlled change. Compare startup with only essential, known-good peripherals connected. Record…
Read guide →
Files and backupSelect several files reliably using File Explorer checkboxes
Item checkboxes can help select multiple files before copying or moving them. Review the selection count before performing a bulk action.
Read guide →
Office helpExcel dates look wrong: distinguish formatting from stored text
First decide whether the cell contains a real Excel date or text that resembles one. Number formatting changes how a valid date is displayed; it does not reliably interpret ambiguous text dates.
Read guide →
Display and monitor troubleshootingUSB-C video output when the picture fails intermittently: diagnostic checks
For USB-C video output when the picture fails intermittently, start by recording the exact symptom and comparing one controlled change. Record the trigger, screen state and whether the display reports no signal.…
Read guide →
Files and storageShow file extensions before renaming or opening files
Displaying extensions helps identify the actual file type. Changing an extension by renaming does not normally convert the contents into another format.
Read guide →
Office helpExcel displays formulas across the sheet instead of their answers
Check whether Show Formulas is enabled. This view deliberately displays formula text so calculations can be inspected.
Read guide →
Display helpUse a Dell monitor's built-in test to investigate an image defect
A supported monitor self-test can help separate the display's own behavior from the computer's video output. Follow the procedure for the exact monitor model.
Read guide →
BackupThe 3-2-1 backup rule: a practical plan for home computers
The 3-2-1 rule means keeping three copies of important data, using two different storage types or independent media, with one copy away from the main location. A backup is useful only if you can restore it.
Read guide →
Office helpExcel entries look identical but do not match: inspect unwanted spaces
Leading, trailing or repeated spaces can make imported text inconsistent. Test cleaning in a helper column before replacing the source.
Read guide →
DisplayVertical lines on a laptop screen: panel, cable or graphics?
Compare the built-in screen with an external display and a model-supported screen self-test. Lines can come from the panel, display cable or graphics path; a driver update is not a universal fix.
Read guide →
Files and backupTime Machine has not backed up recently: check the selected disk
Confirm that the configured Time Machine destination is available and inspect the last successful backup. A connected drive is not necessarily the selected…
Read guide →
Office helpExcel formula shows as text or does not recalculate
Check whether the cell contains text, whether formula display is enabled and whether calculation is automatic. These are different causes of a result not…
Read guide →
Display helpWindows 10 Black Screen With Cursor
If you are searching for windows 10 black screen with cursor , you are usually looking for a quick explanation of the cause, what you can safely check yourself, and when professional repair is the…
Read guide →
Files and backupWill Windows System Restore recover a deleted document?
System Restore targets system configuration changes, not ordinary deleted-document recovery. Choose a file-recovery method that matches how the document…
Read guide →
Office helpExcel headings disappear when you scroll: freeze the correct rows
Freeze panes keeps chosen headings visible while the rest of the worksheet scrolls. Select the boundary carefully so Excel does not freeze the wrong section.
Read guide →
DisplayWindows display is sideways: restore the intended orientation
Check display orientation for the affected monitor. A rotated desktop can be a setting change rather than physical screen damage.
Read guide →
Files and storageWindows says an external drive is in use: close access before removal
Finish transfers and close files using the device before ejecting it. Do not pull the cable while a write is active.
Read guide →
Office helpExcel headings print only on the first page
Use print titles to repeat the required heading rows or columns on each printed page. Freezing panes affects scrolling, not printed headers.
Read guide →
Office helpExcel highlights the wrong cells: inspect conditional-formatting rules
Check the rule's condition, applied range and priority. The visible colour can be driven by a rule rather than a manually selected fill.
Read guide →
Office helpExcel lookup returns #N/A: verify the actual lookup value
Confirm the requested value exists in the searched range and uses a compatible data type. Similar-looking entries may contain different characters or spaces.
Read guide →
Office helpExcel PivotTable shows Count instead of Sum: fix the source types
If a PivotTable counts amounts rather than adding them, inspect the source column for text and mixed values. Then choose Sum in Value Field Settings and refresh the PivotTable.
Read guide →
Office helpExcel prints only part of the worksheet: inspect the print area
A saved print area limits which cells print. Check it when the preview omits rows or columns that are visibly present in the sheet.
Read guide →
Office helpExcel refuses to sort a range containing merged cells
Find merged cells inside the intended sort range before rearranging data. A report layout with merged headings is not always suitable as a sortable table.
Read guide →
Office helpExcel rejects a cell value: fix the data-validation problem
When Excel rejects an entry, inspect the cell’s data-validation rule before removing it. The rule may require a list choice, a number range, a date or a formula-based condition.
Read guide →
Office helpExcel repeats one number instead of continuing your sequence
Give AutoFill a clear pattern and inspect its fill option. Copying a cell and extending a sequence are different operations.
Read guide →
Office helpExcel rows seem missing: clear the active filter first
A filter can hide records without deleting them. Inspect active filter controls before restoring backups or re-entering data.
Read guide →
Office helpExcel shows #DIV/0!: distinguish missing data from a zero result
Check the denominator when a formula divides by zero or a blank value. Decide what missing input should mean before choosing an error handler.
Read guide →
Office helpExcel shows #NAME?: check the formula vocabulary
Check function spelling, defined names and text quotation marks when Excel does not recognize part of a formula.
Read guide →
Office helpExcel shows #REF!: restore the intended reference
A #REF! error points to an invalid reference. Inspect recent row, column or sheet changes before rebuilding the formula.
Read guide →
Office helpExcel shows #SPILL!: inspect the output area
A formula returning several values needs room for its output. Check the reason Excel gives for the blocked spill before deleting neighbouring cells.
Read guide →
Office helpExcel sort moved names away from their records: preserve whole rows
Sort the complete related data range so each record stays together. Sorting one isolated column can separate values that belong to the same row.
Read guide →
Office helpExcel totals ignore imported amounts: check numbers stored as text
An imported value can look numeric while being stored as text. Convert only fields that represent quantities, then verify the totals.
Read guide →No matching guides. Try another device, symptom or purchase requirement.