How-To Guides — Justfixwindows
29 tutorials
These are different from our troubleshooting guides — instead of fixing something broken, these walk through how to actually do useful things in Excel and Word for everyday work.
How to Build a Simple Budget Spreadsheet
How to Pull Data From Another Sheet With XLOOKUP
How to Build a Pivot Table From Scratch
How to Freeze Rows or Columns So Headers Stay Visible
How to Use Conditional Formatting to Highlight Data
How to Create a Drop-Down List in a Cell
How to Create a Table of Contents That Updates Automatically
How to Use Track Changes for Team Reviews
How to Use Styles for Consistent Formatting
How to Do a Mail Merge for Letters or Labels
How to Insert Citations and an Auto-Generated Bibliography
How to Convert a Word Document to PDF Properly
How to Clean Up and Speed Up Windows (Full Walkthrough)
How to Actually Free Up Disk Space in Windows
How to Safely Clean Dust From Inside Your PC
How to Reset Windows Without Losing Your Files
How to Properly Uninstall Programs (Not Just Delete Them)
How to Speed Up Windows Boot Time
How to Set Up Automatic Backups in Windows
How to Create and Use a System Restore Point
How to Control When Windows Update Restarts Your PC
How to Change Default Apps in Windows
How to Take a Screenshot in Windows
How to Manage Notifications with Focus Assist
How to Customize the Taskbar and Start Menu
How to Set Up a New User Account
How to Check Your Windows Version and System Specs
How to Perform a Clean Boot to Isolate a Stubborn Problem