Skip to content
Support Your Tech
  • Windows
  • Office
    • All Office guides
    • Excel
    • Word
    • PowerPoint
  • Phones, Google & Streaming

Avatar of Matt JacobsMatt Jacobs

Matt Jacobs writes and maintains the guides on Support Your Tech, which he started in 2017. He spent most of his career keeping small-business PCs running and still takes the occasional consulting job, so the steps here come from fixing the same problems on other people's computers. Each guide follows Microsoft, Apple and Google's own documentation and is updated when the steps change. Screenshots marked "Recreated" are illustrations of the real screens.
How to install a certificate on Windows 10

How to Install a Certificate on Windows 10

November 17, 2026September 3, 2024 by Matt Jacobs

Double-click the certificate, select Install Certificate, choose Current User or Local Machine and the right store. Here is how to install .cer and .pfx files, including from the command line. Continue Reading How to Install a Certificate on Windows 10

Categories Articles
Windows 10 Run dialog with %appdata% typed in the Open box and the OK button highlighted

How to Open the AppData Folder in Windows 10

November 17, 2026August 30, 2024 by Matt Jacobs

Press Windows + R, type %appdata% and press Enter, and Windows 10 opens the Roaming folder. Select AppData in the address bar to go up… Continue Reading How to Open the AppData Folder in Windows 10

Categories Articles
Ways to change your computer password in Windows 10

How to Change Your Computer Password on Windows 10

November 17, 2026August 29, 2024 by Matt Jacobs

Press Ctrl + Alt + Delete and choose Change a password, or use Settings > Accounts > Sign-in options. Microsoft account passwords can also be changed online. Here is how. Continue Reading How to Change Your Computer Password on Windows 10

Categories Articles
Windows 10 Colors settings with the Choose your color menu open and Custom highlighted

How to Change the Taskbar Color in Windows 10

November 17, 2026August 27, 2024 by Matt Jacobs

Learn how to personalize your Windows 10 experience by changing the taskbar color. Follow this step-by-step guide to add a touch of your favorite hue! Continue Reading How to Change the Taskbar Color in Windows 10

Categories Articles
Illustration of how to install Python IDLE in Windows 10: download Python from python.org, keep IDLE selected, and open it from the Start menu

How to Install Python IDLE in Windows 10

November 17, 2026August 27, 2024 by Matt Jacobs

IDLE comes with Python. Install Python from python.org with tcl/tk and IDLE selected, open IDLE from the Start menu, and write your first program. Continue Reading How to Install Python IDLE in Windows 10

Categories Articles
Illustration of the path to open a JPG file in Windows 10 using File Explorer and the Open with menu

How to Open JPG Files in Windows 10

November 17, 2026August 27, 2024 by Matt Jacobs

To open a JPG in Windows 10, double-click it in File Explorer, or right-click it, choose Open with, and pick Photos or Paint. Fixes if it won’t open. Continue Reading How to Open JPG Files in Windows 10

Categories Articles
Illustration of the Windows 10 path for creating a guest account: Settings, Accounts, Other users, Add account, then Add a user without a Microsoft account

How to Create a Guest Account on Windows 10

November 17, 2026August 26, 2024 by Matt Jacobs

Windows 10 has no Guest option in Settings. Create a standard local account for visitors in Settings > Accounts > Other users, then remove it later. Continue Reading How to Create a Guest Account on Windows 10

Categories Articles
Ways to check computer activity history on Windows 10

How to Check Computer Activity History on Windows 10

November 17, 2026August 26, 2024 by Matt Jacobs

Check Recent items for opened files, browser history for websites, and Event Viewer for start-ups and sign-ins. Here is how to see what was done on a Windows 10 PC and when. Continue Reading How to Check Computer Activity History on Windows 10

Categories Articles
How to get GTA Vice City legally on a Windows 10 laptop

How to Get GTA Vice City on a Windows 10 Laptop Legally

November 20, 2026August 23, 2024 by Matt Jacobs

Get GTA Vice City on a Windows 10 laptop legally: buy GTA: The Trilogy – The Definitive Edition from Steam, Epic or the Rockstar Store, install the launcher and download it. Continue Reading How to Get GTA Vice City on a Windows 10 Laptop Legally

Categories Articles
Windows 10 File Explorer window with the Maximize button highlighted in the top-right corner

Windows 10 Full Screen: Pick the Right Key for Your App

November 17, 2026August 23, 2024 by Matt Jacobs

If you pressed F11 or maximized a window and the taskbar or title bar is still there, you probably used the right idea with the… Continue Reading Windows 10 Full Screen: Pick the Right Key for Your App

Categories Articles
Windows 10 File Explorer open to Quick access with the File Explorer icon on the taskbar highlighted

How to Open File Explorer in Windows 10

November 17, 2026August 22, 2024 by Matt Jacobs

Learn how to open File Explorer in Windows 10 with our easy, step-by-step guide. Access your files and folders effortlessly using simple methods. Continue Reading How to Open File Explorer in Windows 10

Categories Articles
Windows 10 taskbar with the notification icon highlighted at the far right, next to the clock

How to Open Action Center in Windows 10

November 17, 2026August 21, 2024 by Matt Jacobs

Discover how to open the Action Center in Windows 10 with our step-by-step guide. Follow these simple instructions to access notifications and quick settings easily. Continue Reading How to Open Action Center in Windows 10

Categories Articles
Windows 10 Performance Options dialog with Adjust for best performance selected on the Visual Effects tab and the OK button highlighted

How to Change Performance Settings in Windows 10

November 17, 2026August 21, 2024 by Matt Jacobs

To change performance settings in Windows 10, select Start, type performance, and open Adjust the appearance and performance of Windows. On the Visual Effects tab,… Continue Reading How to Change Performance Settings in Windows 10

Categories Articles
Illustration of the path to download the HP LaserJet M1136 MFP driver for Windows 10 from HP Support

How to Download HP LaserJet M1136 MFP Driver for Windows 10

November 9, 2026August 20, 2024 by Matt Jacobs

Download the HP LaserJet M1136 MFP driver for Windows 10 from HP’s support page, or let Windows Update install a basic driver if HP’s installer fails. Continue Reading How to Download HP LaserJet M1136 MFP Driver for Windows 10

Categories Articles
Illustration of the Windows 10 path to Reset this PC: Settings, Update & Security, Recovery, Get started, Keep my files, then Reset

How to Reset All Settings in Windows 10

November 17, 2026August 20, 2024 by Matt Jacobs

Windows 10 has no reset-all-settings button. Use Settings > Update & Security > Recovery > Reset this PC, or reset just the network or one app. Continue Reading How to Reset All Settings in Windows 10

Categories Articles
Windows Scan app with a scanner selected, File type set to PDF, and the Scan button highlighted

How to Scan From a Printer to a Computer in Windows 10

November 17, 2026August 15, 2024 by Matt Jacobs

Put the document face down on the scanner glass, open the Windows Scan app, and choose your scanner. Set File type to PDF or JPEG… Continue Reading How to Scan From a Printer to a Computer in Windows 10

Categories Articles
Windows 10 System Restore wizard with a restore point selected and the Next button highlighted

How to Restore Windows 10 to a Previous Date

November 17, 2026August 15, 2024 by Matt Jacobs

System Restore rolls Windows 10 back to an earlier restore point. Press Windows + R, type rstrui, and press Enter, or search the taskbar for… Continue Reading How to Restore Windows 10 to a Previous Date

Categories Articles
Windows 10 Settings Default apps page with the Web browser setting open and a browser chosen from the Choose an app list

Change the Default Browser in Windows 10 (and Make It Stick)

November 17, 2026August 15, 2024 by Matt Jacobs

You clicked a link in an email and Edge opened, or you pressed “Make default” in Chrome and nothing seemed to happen. The fix is… Continue Reading Change the Default Browser in Windows 10 (and Make It Stick)

Categories Articles
Windows 10 Settings Clipboard page with the Clipboard history switch on and the Clear button highlighted

How to Open the Clipboard in Windows 10 (There’s No Window)

November 17, 2026August 13, 2024 by Matt Jacobs

There’s no Clipboard app, folder or window in Windows 10 to go looking for. The clipboard lives in memory, and the only way to see… Continue Reading How to Open the Clipboard in Windows 10 (There’s No Window)

Categories Articles
Windows 10 Settings Printers and scanners page with Add a printer or scanner and a found printer highlighted

Add a Printer in Windows 10: USB, Wi-Fi or IP Address

November 17, 2026August 8, 2024 by Matt Jacobs

On Windows 10, the connection decides the route. A USB printer usually installs itself when plugged in. For a Wi-Fi or network printer, go to… Continue Reading Add a Printer in Windows 10: USB, Wi-Fi or IP Address

Categories Articles
Windows 10 desktop with one window snapped to the left half and Snap Assist showing other windows on the right

How to Split Screen in Windows 10

November 18, 2026August 8, 2024 by Matt Jacobs

To split the screen in Windows 10, drag a window by its title bar to the left or right edge of the screen until an… Continue Reading How to Split Screen in Windows 10

Categories Articles
Illustration of the Windows 10 sign-out path: Start, user picture or Accounts icon, Sign out

How to Sign Out of a Microsoft Account in Windows 10

November 17, 2026August 7, 2024 by Matt Jacobs

Sign out of Windows 10 from Start > your picture > Sign out, or switch to a local account in Settings to stop using a Microsoft account. Continue Reading How to Sign Out of a Microsoft Account in Windows 10

Categories Articles
How to deal with a forgotten administrator password on Windows 10: find which account is admin, reset a Microsoft account online, or reset a local account

What to Do When Windows 10 Asks for an Admin Password

November 20, 2026August 7, 2024 by Matt Jacobs

Windows 10 can’t show the admin password, but you can find which account is the administrator and reset its password online, with security questions or from another admin. Continue Reading What to Do When Windows 10 Asks for an Admin Password

Categories Articles
How to search for text or numbers in Excel with Find

How to Search for Something in Excel (Find, Filter and Formulas)

November 17, 2026August 2, 2024 by Matt Jacobs

Search in Excel with Ctrl+F, list every match with Find All, search the whole workbook, use wildcards, filter rows, or find matches with SEARCH, COUNTIF and FILTER. Continue Reading How to Search for Something in Excel (Find, Filter and Formulas)

Categories Excel
Illustration of the Excel path for a date drop-down list using Data Validation

How to Add a Calendar Drop-Down or Date Picker in Excel

November 17, 2026August 2, 2024 by Matt Jacobs

Excel has no built-in calendar for cells. Add a date drop-down with Data Validation and a list of dates, or use the Date and Time Picker in 32-bit Excel. Continue Reading How to Add a Calendar Drop-Down or Date Picker in Excel

Categories Excel
Ways to add totals from different sheets in Excel

How to Add Totals from Different Sheets in Excel

November 17, 2026August 1, 2024 by Matt Jacobs

Click each sheet’s total with + between them, use a 3D SUM like =SUM(Jan:Dec!B10), or use Consolidate. Here is how, including conditional totals across sheets with VSTACK. Continue Reading How to Add Totals from Different Sheets in Excel

Categories Excel
Illustration of how to get rid of E+ in Excel: apply a Number format, store long numbers as text, or turn off automatic data conversion

How to Get Rid of E+ in Excel

November 18, 2026August 1, 2024 by Matt Jacobs

Stop Excel showing numbers like 1.23E+11. Apply a Number format, store long numbers as text, turn off automatic data conversion, or import CSV files as text. Continue Reading How to Get Rid of E+ in Excel

Categories Excel
How to share an Excel file as a link

How to Share an Excel File as a Link

November 17, 2026July 31, 2024 by Matt Jacobs

Save the workbook to OneDrive, select Share > Copy link, and choose who it works for and whether they can view or edit. Here is how, plus expiry dates, passwords and links to a cell. Continue Reading How to Share an Excel File as a Link

Categories Excel
Illustration of the Excel sharing path: select Share, enter email addresses, keep Can edit, add a message, select Send

How to Share an Excel Spreadsheet for Editing

November 17, 2026July 30, 2024 by Matt Jacobs

To let others edit an Excel workbook, save it to OneDrive or SharePoint, select Share, keep Can edit selected, add their emails, and select Send. Continue Reading How to Share an Excel Spreadsheet for Editing

Categories Excel
Illustration of the path to edit history in Excel: open the workbook, select the Review tab, select Show Changes, read the Changes pane, then filter by Range or Sheet

How to View Edit History in Excel

November 9, 2026July 30, 2024 by Matt Jacobs

To view edit history in Excel, select Review > Show Changes to see who changed which cells and when, or use Version History for older versions. Continue Reading How to View Edit History in Excel

Categories Excel
Illustration of the path to Power Query in Excel: Data tab, Get and Transform Data group, Get Data, Launch Power Query Editor

How to Find and Enable Power Query in Excel

November 17, 2026July 29, 2024 by Matt Jacobs

Power Query is built into Excel 2016 and later: open the Data tab and use Get and Transform Data. Excel 2010 and 2013 need Microsoft’s free add-in. Continue Reading How to Find and Enable Power Query in Excel

Categories Excel
Ways to link or embed a PDF in Excel

Link a PDF in Excel: Hyperlink, Embed or Formula

November 17, 2026July 29, 2024 by Matt Jacobs

Link a PDF in Excel with Ctrl+K to create a clickable hyperlink, embed it with Insert > Object > Create from File, or build many links with the HYPERLINK formula. Continue Reading Link a PDF in Excel: Hyperlink, Embed or Formula

Categories Excel
Steps to add Copilot to Excel

How to Add Copilot to Excel

November 17, 2026July 24, 2024 by Matt Jacobs

Copilot in Excel comes with Microsoft 365 Personal, Family, Premium or a work Copilot license. Here is how to sign in, update and turn it on, and what to do if the button is missing. Continue Reading How to Add Copilot to Excel

Categories Excel
Illustration of conditional formatting rules that change Excel cell colors based on dates: overdue, due soon, and A Date Occurring

How to Make Excel Cells Change Color Automatically Based on Date

November 17, 2026July 19, 2024 by Matt Jacobs

Use conditional formatting with TODAY() to color overdue, due-soon and future dates in Excel automatically, including whole rows and traffic-light status. Continue Reading How to Make Excel Cells Change Color Automatically Based on Date

Categories Excel
Illustration of the Excel path Home, Number Format box, Text, then typing a number with leading zeros

How to Stop Excel From Removing Leading Zeros

November 17, 2026July 18, 2024 by Matt Jacobs

To keep leading zeros in Excel, format the cells as Text before typing, start entries with an apostrophe, or use a custom format or the TEXT function. Continue Reading How to Stop Excel From Removing Leading Zeros

Categories Excel
Excel Data Validation dialog with a list of sizes in the Source box and Apply these changes to all other cells with the same settings checked

How to Modify a Drop-Down List in Excel

November 17, 2026July 16, 2024 by Matt Jacobs

You can modify a drop-down list from Data > Data Validation in Excel for Microsoft 365, Excel 2024, 2021, 2019 and 2016 on Windows. Select… Continue Reading How to Modify a Drop-Down List in Excel

Categories Excel
The parts of an XLOOKUP formula that pulls data from another sheet

How to Use XLOOKUP in Excel with Two Sheets

November 17, 2026July 12, 2024 by Matt Jacobs

Use XLOOKUP across two sheets: =XLOOKUP(A2,Sheet2!A:A,Sheet2!C:C,”Not found”). Includes sheet names with spaces, returning several columns, two-criteria lookups and error fixes. Continue Reading How to Use XLOOKUP in Excel with Two Sheets

Categories Articles
How to save an Excel workbook to the desktop

Save an Excel File to Your Desktop Instead of OneDrive

November 17, 2026July 12, 2024 by Matt Jacobs

Press F12 or choose File > Save As > Browse, pick Desktop and select Save. Here is how on Windows, Mac and Excel for the web, and how to stop Excel defaulting to OneDrive. Continue Reading Save an Excel File to Your Desktop Instead of OneDrive

Categories Excel
Excel File, Info page with the Protect Workbook menu open and Encrypt with Password highlighted

How to Require a Password to Open an Excel File

November 17, 2026July 9, 2024 by Matt Jacobs

Excel locks a workbook behind a password from File > Info > Protect Workbook > Encrypt with Password. Type a password, select OK, type it… Continue Reading How to Require a Password to Open an Excel File

Categories Excel
Steps to give someone edit access to an Excel sheet

How to Give Edit Access to an Excel Sheet

November 17, 2026July 8, 2024 by Matt Jacobs

Share the workbook from OneDrive with Can edit, then unprotect the sheet or unlock the cells people should change. Here is how, plus fixes for read-only files. Continue Reading How to Give Edit Access to an Excel Sheet

Categories Excel
The parts of a VLOOKUP formula that looks up data on another sheet

How to Do a VLOOKUP in Excel Between Two Sheets

November 17, 2026July 5, 2024 by Matt Jacobs

Do a VLOOKUP between two sheets: start the formula, click the other sheet tab, select and lock the range. Includes sheet names with spaces, other workbooks, XLOOKUP and #N/A fixes. Continue Reading How to Do a VLOOKUP in Excel Between Two Sheets

Categories Excel
Ways to compare two Excel sheets for matches

How to Compare Two Sheets in Excel for Matches

November 17, 2026July 5, 2024 by Matt Jacobs

Use COUNTIF to flag matches, XLOOKUP to pull related data, conditional formatting to highlight them, or a cell-by-cell formula for sheets with the same layout. Formulas you can copy. Continue Reading How to Compare Two Sheets in Excel for Matches

Categories Excel
Steps to make a spreadsheet in Microsoft Excel

How to Make an Excel Spreadsheet

November 17, 2026July 3, 2024 by Matt Jacobs

Open a blank workbook, type headings and data, turn it into a table with Ctrl + T, add totals with AutoSum and save. A beginner’s walkthrough using a simple budget. Continue Reading How to Make an Excel Spreadsheet

Categories Excel
Illustration of the path to dd/mm/yyyy in Excel: select the dates, press Ctrl+1, Number tab, Custom, type dd/mm/yyyy, OK

How to Change mm/dd/yyyy to dd/mm/yyyy in Excel

November 17, 2026July 2, 2024 by Matt Jacobs

Change mm/dd/yyyy to dd/mm/yyyy in Excel: select the dates, press Ctrl+1, choose Custom, type dd/mm/yyyy and select OK. Includes fixes for text dates. Continue Reading How to Change mm/dd/yyyy to dd/mm/yyyy in Excel

Categories Excel
Illustration of the Excel path File, Info, Version History, Open version, Restore

How to View Version History in Excel

November 10, 2026July 2, 2024 by Matt Jacobs

Open a workbook saved in OneDrive or SharePoint, click the file name at the top, and choose Version history to open or restore an earlier copy. Continue Reading How to View Version History in Excel

Categories Excel
Illustration of the Excel path to copy a sheet to another workbook: right-click the tab, Move or Copy, To book, Before sheet, Create a copy, OK

How to Copy a Sheet to Another Workbook in Excel

November 17, 2026June 28, 2024 by Matt Jacobs

Right-click the sheet tab, select Move or Copy, pick the workbook under To book, check Create a copy, and select OK. Mac and web steps included. Continue Reading How to Copy a Sheet to Another Workbook in Excel

Categories Excel
Excel path to turn off Always Open Read-Only

How to Change Read-Only Mode in Excel

November 17, 2026June 27, 2024 by Matt Jacobs

Turn off read-only in Excel: select Edit Anyway, then File, Info, Protect Workbook, and clear Always Open Read-Only. Plus Protected View and lock fixes. Continue Reading How to Change Read-Only Mode in Excel

Categories Excel
Illustration of the Excel path: select cell B2, View, Freeze Panes, Freeze Panes

How to Freeze the Top Row and First Column in Excel

November 18, 2026June 26, 2024 by Matt Jacobs

Select cell B2, then go to View > Freeze Panes > Freeze Panes to keep row 1 and column A visible while you scroll in Excel. Continue Reading How to Freeze the Top Row and First Column in Excel

Categories Excel
How to add a hyperlink to an Excel cell that contains other text

How to Insert a Hyperlink in an Excel Cell with Other Text

November 17, 2026June 26, 2024 by Matt Jacobs

An Excel cell can have one link covering the whole cell. Use Ctrl + K with custom display text, or the HYPERLINK function to combine text and links. Here is how, plus a workaround for partial links. Continue Reading How to Insert a Hyperlink in an Excel Cell with Other Text

Categories Excel
Illustration of the path to enable the legacy Share Workbook feature in Excel for Windows

How to Enable Share Workbook in Excel

November 17, 2026June 25, 2024 by Matt Jacobs

To enable Share Workbook in Excel, add Share Workbook (Legacy) to the Quick Access Toolbar, then allow changes by more than one user. Continue Reading How to Enable Share Workbook in Excel

Categories Excel
Older posts
Newer posts
← Previous Page1 Page2 Page3 Page4 … Page8 Next →

New guides, by email

One short email when a new guide goes up. No deals, no spam.

Unsubscribe with one click, any time.
Privacy policy

SupportYourTech

Clear, tested instructions for the devices and apps you use every day, written by Matt Jacobs.

Help centers

  • Windows
  • Microsoft Office
  • Phones, Google & Streaming

Popular topics

  • Excel
  • Word
  • PowerPoint
  • iPhone

[email protected]
4842931513
1 E Broad St
Ste 130 - 1107
Bethlehem, PA 18018
United States

  • Privacy Policy
  • Affiliate Disclaimer
  • Contact Us
  • About Us
© SupportYourTech.com 2026
  • Windows
  • Office
    • All Office guides
    • Excel
    • Word
    • PowerPoint
  • Phones, Google & Streaming