Office Basics
Quick Reference Hub

Fix-It Database

26 real-world recurring workplace issues solved step-by-step. Filter by application or use instant search to find immediate troubleshooting steps.

Outlook fix

Repairing corrupted Outlook data files (.PST / .OST)

  1. Close Outlook completely. Press Win + R and run C:\Program Files\Microsoft Office\root\Office16\SCANPST.EXE.
  2. Click Browse to select your default `.pst` file (located under Documents/Outlook Files).
  3. Click Start to scan for internal cross-link errors, then click Repair once processing finishes.
OneDrive fix

Resolving OneDrive file sync lock conflicts

  1. Look for the red "X" or blue padlocks on files in File Explorer.
  2. Right-click the OneDrive cloud icon in your taskbar tray → Pause syncing → 2 hours.
  3. Open Task Manager (Ctrl + Shift + Esc), end Microsoft OneDrive, and restart it from the Start Menu.
Word fix

Deleting a stubborn blank page

  1. Turn on Show/Hide ¶ (Ctrl + Shift + 8) to see hidden page elements.
  2. If trailing paragraph marks exist, click before the last one and press Backspace.
  3. If caused by an ending table, change that trailing paragraph mark's font size to 1pt.
Word fix

Unlinking headers/footers between sections

  1. Double-click the header or footer on the page where changes must start.
  2. In the top ribbon, click Link to Previous to turn off synchronization with prior pages.
  3. Modify or remove header content without affecting preceding document sections.
Word fix

Starting page numbers on page 3

  1. Click at the top of page 3: go to Layout → Breaks → Next Page.
  2. Double-click footer on page 3 and disable Link to Previous.
  3. Go to Insert → Page Number → Format Page Numbers → Start at: 1.
Word fix

One landscape page in a portrait document

  1. Place your cursor at the start of the page to rotate.
  2. Insert a section break before and after it (Layout → Breaks → Next Page).
  3. Click inside that isolated section and select Layout → Orientation → Landscape.
Word fix

Stopping typing over existing text (Overtype mode)

  1. If new letters delete existing ones, press the Insert key on your keyboard once.
  2. To permanently disable it: File → Options → Advanced.
  3. Uncheck "Use the Insert key to control overtype mode".
Word fix

Fixing a table row that splits across pages

  1. Click inside the table row, then Table Layout → Properties → Row.
  2. Uncheck "Allow row to break across pages".
  3. To apply to the full table, select all rows prior to opening properties.
Excel fix

Hiding #N/A and #VALUE! lookup errors

  1. Wrap your formula inside an IFERROR or IFNA wrapper function.
  2. Type: =IFERROR(XLOOKUP(A2, D:D, E:E), "Not Found") or "" for blank.
  3. Copy down the grid — calculated cells will show clean text or blanks instead of error codes.
Excel fix

Converting numbers stored as text to actual numbers

  1. Select the column exhibiting green triangles in cell corners.
  2. Click the yellow error indicator icon that appears beside the selection.
  3. Select Convert to Number from the drop-down menu.
Excel fix

Combining columns without retyping

  1. In a new column, enter =A2&" "&B2 to join text string values.
  2. Copy the formula down the column grid.
  3. Copy the result column → Paste Special → Values to lock plain text.
Excel fix

Keeping leading zeroes (01234)

  1. Select cells before entering data, right-click → Format Cells → Text.
  2. For existing numbers: Format Cells → Custom → enter 00000.
  3. Custom formats preserve numerical value for calculations while keeping leading zeros.
Excel fix

Freezing header rows

  1. Click the cell directly underneath the header row you need to lock.
  2. Go to View → Freeze Panes → Freeze Panes.
  3. The header row stays fixed on screen during vertical scrolling.
Excel fix

Removing duplicate rows

  1. Select data range, then go to Data → Remove Duplicates.
  2. Specify which columns require exact matches to qualify as duplicates.
  3. Excel retains the initial instance and deletes subsequent duplicate rows.
Windows fix

Clearing stuck print queue jobs (Print Spooler)

  1. Press Win + R, type services.msc, locate Print Spooler and click Stop.
  2. Open File Explorer and navigate to C:\Windows\System32\spool\PRINTERS.
  3. Delete all files inside the folder, then return to Services and click Start on Print Spooler.
Windows fix

Fixing dual monitor resolution or display scaling

  1. Right-click empty desktop area → Display Settings.
  2. Select the misaligned monitor thumbnail at the top.
  3. Set Scale to 100% or 125% and Display Resolution to Recommended.
Windows hack

Multi-copying with Clipboard History

  1. Copy multiple items sequentially (Ctrl + C).
  2. Press Win + V where you want to paste.
  3. Select any previous item from the pop-up history buffer.
Windows hack

Screenshotting a specific area

  1. Press Win + Shift + S to dim the screen.
  2. Drag a rectangular crop box over the targeted screen region.
  3. The snip copies automatically to clipboard for instant pasting (Ctrl + V).
Windows hack

Locking two windows into split screen

  1. Press Win + ← on an active window.
  2. Select a second application thumbnail from the remaining half.
  3. Drag the center dividing line to resize both viewports simultaneously.
Windows hack

Batch renaming multiple files

  1. Select target files using drag-selection or Ctrl + click.
  2. Press F2, type base file title, and hit Enter.
  3. Windows automatically indexes items as Title (1), Title (2)...
PowerPoint fix

Embedding custom fonts so text doesn't shift on other PCs

  1. Open deck, click File → Options → Save.
  2. Scroll to bottom and check Embed fonts in the file.
  3. Select "Embed all characters" to ensure full editing support elsewhere.
PowerPoint fix

Fixing broken audio or video embeds

  1. Delete broken media frames resulting from unlinked source files.
  2. Re-insert via Insert → Video/Audio → This Device.
  3. Go to File → Info → Compress Media to embed media internally within `.pptx`.
PowerPoint fix

Aligning objects across multiple slides

  1. Place static elements in View → Slide Master layout templates.
  2. For individual elements, check X/Y coordinates in Format Shape → Position.
  3. Turn on View → Guides to establish alignment baselines across slides.
PowerPoint fix

Reducing large presentation file sizes

  1. Go to File → Compress Pictures, choose target resolution (150 ppi).
  2. Delete unused slide layouts and off-canvas hidden assets.
  3. Re-link or stream external high-definition video assets.
PowerPoint fix

Recovering unsaved work after crash

  1. Relaunch PowerPoint to inspect auto-triggered Document Recovery panes.
  2. Alternatively go to File → Info → Manage Presentation.
  3. Click Recover Unsaved Presentations to open local cache temp files.
No fixes match that search parameter — try searching for "print", "formula", "page", or "font".

Troubleshooting Tools & Scripts

SYSTEM UTILITIES
Print Spooler Reset Script

Automated Queue Cleaner (.BAT)

.BAT
Office Shortcut Master Matrix

Universal Hotkey Reference (.PDF)

.PDF

Visual Troubleshooting Guides

STEP-BY-STEP MEDIA