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

Excel

How-to guides and tutorials about the Microsoft Excel spreadsheet application.

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
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
Illustration of how to make an Excel spreadsheet live: save it to OneDrive, share it for real-time co-authoring, and set data to refresh automatically

How to Make an Excel Spreadsheet Live

November 17, 2026June 25, 2024 by Matt Jacobs

Make an Excel spreadsheet live by saving it to OneDrive and sharing it for real-time co-authoring, and set stock, web or database data to refresh automatically. Continue Reading How to Make an Excel Spreadsheet Live

Categories Excel
Illustrated path for embedding an Excel workbook in Word: Insert tab, Text group, Object, Create from File, Browse, Link to file cleared, OK

How to Embed an Excel File in Word

November 17, 2026June 24, 2024 by Matt Jacobs

Embed an Excel file in Word: select Insert, then Object, open Create from File, browse to the workbook, leave Link to file cleared and select OK. Continue Reading How to Embed an Excel File in Word

Categories Excel
How to add a line break in an Excel cell: Alt+Enter on Windows, Option+Return on Mac, and CHAR(10) in formulas

How to Add a Line Break (Return) in an Excel Cell

November 17, 2026June 24, 2024 by Matt Jacobs

Press Alt + Enter on Windows or Option + Return on a Mac to start a new line inside a cell. Use CHAR(10) in formulas, and Ctrl + J to remove breaks. Continue Reading How to Add a Line Break (Return) in an Excel Cell

Categories Excel
Illustration of the path to hide gridlines in Excel: View tab, Show group, Gridlines check box

How to Remove Lines in Excel

November 17, 2026June 19, 2024 by Matt Jacobs

Hide Excel gridlines on the View tab, remove borders with Home > Borders > No Border, and turn off dashed page break lines in File > Options > Advanced. Continue Reading How to Remove Lines in Excel

Categories Excel
Illustration of the path to insert a calendar template in Excel: File, New, search for calendar, preview a template, Create

How to Insert a Calendar in Excel

November 17, 2026June 17, 2024 by Matt Jacobs

To insert a calendar in Excel, pick a calendar template under File, New, or build a monthly grid that updates itself with the SEQUENCE function. Continue Reading How to Insert a Calendar in Excel

Categories Excel
Illustration of the path to change the Excel display language: File, Options, Language, Office display language, Set as Preferred

How to Change the Language in Excel

November 17, 2026June 17, 2024 by Matt Jacobs

Change Excel’s language in File > Options > Language: set the Office display language and authoring language as preferred, then restart Excel. Continue Reading How to Change the Language in Excel

Categories Excel
Illustration of three ways to make Excel cells fit text: AutoFit the column, turn on Wrap Text, or use an AutoFit macro

How to Make Excel Cells Expand to Fit Text Automatically

November 17, 2026June 13, 2024 by Matt Jacobs

AutoFit columns, wrap text so rows grow, or use a short macro so Excel columns resize as you type. Includes fixes for merged cells and cut-off text. Continue Reading How to Make Excel Cells Expand to Fit Text Automatically

Categories Excel

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