Skip to content
Live2Tech
  • iPhone
  • Windows
    • Windows 11
    • Windows 10
  • Office
    • Word
    • Excel
    • Powerpoint
    • Outlook
  • Google
    • Google Docs
    • Google Sheets
    • Google Slides
    • Gmail
    • Chrome
    • Google Drive
  • Mac & Apple
    • Mac
    • iPad
    • Apple Watch
  • All Tutorials

Excel

How-to guides and tutorials to help you perform specific tasks and use the Microsoft Excel spreadsheet application.

How to Use SUMIF and SUMIFS in Excel

November 16, 2026 by Kermit Matthews

Use SUMIF to add numbers that meet one condition and SUMIFS for two or more. The key difference is argument order: SUMIF puts the cells to add last, SUMIFS puts them first. Includes worked examples with text, number, date and wildcard criteria, OR logic, and fixes for results of 0, #VALUE! and wrong totals. Continue Reading How to Use SUMIF and SUMIFS in Excel

Categories Excel

How to Use INDEX and MATCH in Excel

November 15, 2026November 11, 2026 by Kermit Matthews

Nest MATCH inside INDEX, =INDEX(return_range, MATCH(lookup_value, lookup_range, 0)), to look up a value in any direction. Step-by-step example, exact vs approximate match, left and two-way lookups, multiple criteria, error fixes and when to use XLOOKUP instead. Continue Reading How to Use INDEX and MATCH in Excel

Categories Excel

How to Use Conditional Formatting in Excel

November 15, 2026November 6, 2026 by Kermit Matthews

Select your cells, go to Home > Conditional Formatting, pick a rule such as Highlight Cells Rules > Greater Than, set the value and format, and click OK. This guide covers every rule type, formula rules that highlight whole rows, the Rules Manager and Stop If True, Mac and web steps, and fixes. Continue Reading How to Use Conditional Formatting in Excel

Categories Excel

How to Create a Drop-Down List in Excel

November 10, 2026November 3, 2026 by Kermit Matthews

Select the cells, go to Data > Data Validation, set Allow to List, and pick your source. Here is every way to build an Excel drop-down list, including lists that update automatically, dependent lists, Mac and web steps, and fixes. Continue Reading How to Create a Drop-Down List in Excel

Categories Excel

Choose Which Duplicate Excel Rows to Keep Before Deleting

November 13, 2026October 28, 2026 by Kermit Matthews

Click a cell in your data, choose Data > Remove Duplicates, pick the columns that must match, and click OK. This guide also covers highlighting duplicates first, Advanced Filter, the UNIQUE function, COUNTIF flags, TRIM cleanup, Power Query, Mac and web steps, and how to undo it. Continue Reading Choose Which Duplicate Excel Rows to Keep Before Deleting

Categories Excel

How to Use VLOOKUP in Excel

November 15, 2026October 23, 2026 by Kermit Matthews

Type =VLOOKUP(lookup_value, table_array, col_index_num, FALSE) to find a value in the first column of a range and return data from the same row. This guide walks through a worked example, exact vs approximate match, locking references, IFNA, other sheets and workbooks, and when to use XLOOKUP instead. Continue Reading How to Use VLOOKUP in Excel

Categories Excel

How to Use the FILTER Function in Excel

November 15, 2026October 22, 2026 by Kermit Matthews

Type =FILTER(data, condition, “message if nothing matches”) in one cell and Excel spills every matching row. This guide covers the syntax, AND and OR criteria, SORT and UNIQUE combinations, #SPILL! and #CALC! fixes, and how FILTER differs from the Filter button. Continue Reading How to Use the FILTER Function in Excel

Categories Excel

Look Up Prices From Another Sheet With XLOOKUP in Excel

November 12, 2026October 19, 2026 by Kermit Matthews

Type =XLOOKUP(lookup value, lookup column, return column) and press Enter. This guide explains every argument, walks through 12 worked examples with sample tables, compares XLOOKUP with VLOOKUP, and fixes the common errors. Continue Reading Look Up Prices From Another Sheet With XLOOKUP in Excel

Categories Excel

How to Make a Bar Graph in Excel

November 15, 2026October 15, 2026 by Kermit Matthews

Select your data and choose Insert > Insert Column or Bar Chart > Clustered Bar. This guide explains bar vs column charts, clustered vs stacked vs 100% stacked, data labels, axis formatting, putting the largest bar on top, Mac and web steps, and fixes for common problems. Continue Reading How to Make a Bar Graph in Excel

Categories Excel

Summarize a Transaction List With an Excel Pivot Table

November 6, 2026October 13, 2026 by Kermit Matthews

Click a cell in your data, choose Insert > PivotTable, and check the fields you want to summarize. This guide covers every step on Windows, Mac, and the web, plus a worked example, Recommended PivotTables, PIVOTBY, refreshing, and troubleshooting. Continue Reading Summarize a Transaction List With an Excel Pivot Table

Categories Excel

How to Use Copilot in Excel to Create a Formula: A Step-by-Step Guide

November 10, 2026September 3, 2026 by Kermit Matthews

Creating formulas in Excel can be tricky, but with the help of Copilot, things get a whole lot easier. Imagine having an assistant right there… Continue Reading How to Use Copilot in Excel to Create a Formula: A Step-by-Step Guide

Categories Excel

How to Use Copilot in Excel to Analyze a Table: A Step-by-Step Guide

November 10, 2026September 3, 2026 by Kermit Matthews

If you’ve ever wondered how to make sense of that huge data table in Excel quickly, Copilot is your new best friend. This handy tool… Continue Reading How to Use Copilot in Excel to Analyze a Table: A Step-by-Step Guide

Categories Excel
Task Manager Processes tab with a spreadsheet app marked Not responding and the End task button highlighted

How to Force Quit Excel on Windows (and Recover Your Work)

November 15, 2026June 6, 2025 by Kermit Matthews

Force quit a frozen Excel on Windows with Task Manager, Alt+F4 or taskkill, recover unsaved work with AutoRecover, and stop Excel from freezing again. Continue Reading How to Force Quit Excel on Windows (and Recover Your Work)

Categories Excel

How to Cut a Word in Excel (Move, Extract or Remove Text)

November 10, 2026October 30, 2024 by Kermit Matthews

Learn how to cut words in Excel with our step-by-step guide. Simplify your editing process and enhance productivity with these easy tips and tricks. Continue Reading How to Cut a Word in Excel (Move, Extract or Remove Text)

Categories Excel
Spreadsheet with the Symbol dialog open and the n with tilde character selected, and a cell using the CHAR 241 formula

How to Type Ñ and ñ on Windows (Laptop, Word and Excel)

November 17, 2026September 12, 2024 by Kermit Matthews

Type ñ on a laptop without a number pad: use Windows + period, Insert Symbol or =CHAR(241) in Excel, AutoCorrect, the touch keyboard or US-International. Continue Reading How to Type Ñ and ñ on Windows (Laptop, Word and Excel)

Categories Excel
Windows Customize Format dialog on the Numbers tab with Digit grouping set to 123,456,789

How to Change Lakhs to Millions in Excel on Windows 10

November 14, 2026August 29, 2024 by Kermit Matthews

Change Excel from lakhs to millions by setting Windows digit grouping to 123,456,789, use custom number formats, or convert lakh values with a formula. Continue Reading How to Change Lakhs to Millions in Excel on Windows 10

Categories Excel
Data Validation dialog with the Clear All button highlighted

How to Remove a Drop-Down List in Excel on Windows 10

November 14, 2026August 12, 2024 by Kermit Matthews

Remove a drop-down list in Excel by selecting the cells and choosing Data, Data Validation, Clear All. Your cell values stay in place. Continue Reading How to Remove a Drop-Down List in Excel on Windows 10

Categories Excel
Excel worksheet with a COUNTIF formula in the formula bar counting cells that contain the word Yes

How to Count a Word in Excel (COUNTIF and More)

November 10, 2026July 11, 2024 by Kermit Matthews

Count a word in Excel with COUNTIF for matching cells, wildcards for partial matches, and LEN and SUBSTITUTE to count every occurrence. Continue Reading How to Count a Word in Excel (COUNTIF and More)

Categories Excel
Spreadsheet Find and Replace dialog with a word entered, Options expanded to search the workbook, and a Find All results list showing matching cells

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

November 10, 2026July 8, 2024 by Kermit Matthews

Search for a word in Excel with Ctrl + F and Find All, search the whole workbook, use wildcards, replace text, filter rows or use SEARCH in formulas. Continue Reading How to Search for a Word in Excel (Find, Filter and Formulas)

Categories Excel

How to Make the First Letter of Each Word Capital in Excel

November 10, 2026July 3, 2024 by Kermit Matthews

Learn how to easily capitalize the first letter of each word in Excel with our step-by-step guide, ensuring your data looks professional and well-organized. Continue Reading How to Make the First Letter of Each Word Capital in Excel

Categories Excel
Formula bar showing a COUNTIF formula with wildcards

How to Count How Many Times a Word Appears in Excel

November 10, 2026July 1, 2024 by Kermit Matthews

Count a word in Excel with COUNTIF for exact or partial matches, or SUMPRODUCT to count every occurrence, including repeats in one cell. Continue Reading How to Count How Many Times a Word Appears in Excel

Categories Excel
Command Prompt showing ipconfig /all output with the Physical Address line highlighted for the Wi-Fi adapter

How to Enable Macros in Excel Safely on Windows 11

November 15, 2026June 14, 2024 by Kermit Matthews

Enable macros in Excel on Windows 11 with Enable Content, Trust Center macro settings, unblocking downloaded files, or trusted locations, and stay safe. Continue Reading How to Enable Macros in Excel Safely on Windows 11

Categories Excel

Fix Excel’s “This Value Doesn’t Match the Data Validation Restrictions” Error

November 10, 2026April 2, 2024 by Kermit Matthews

Learn how to fix “This Value Doesn’t Match” errors in Excel with our step-by-step solutions for data validation issues. Continue Reading Fix Excel’s “This Value Doesn’t Match the Data Validation Restrictions” Error

Categories Excel

Mastering Excel: Clicking and Dragging the Fill Handle for Quick Data Entry

November 10, 2026April 1, 2024 by Kermit Matthews

Learn how to use Excel’s fill handle to quickly enter data and save time with our step-by-step guide to mastering this essential skill. Continue Reading Mastering Excel: Clicking and Dragging the Fill Handle for Quick Data Entry

Categories Excel

How to Remove Temporary Views in Excel

November 10, 2026March 31, 2024 by Kermit Matthews

Improve your Excel workflow by removing temporary views. Follow these easy steps to declutter your spreadsheet and increase efficiency. Continue Reading How to Remove Temporary Views in Excel

Categories Excel

How to Select Multiple Items from a Dropdown List in Excel

November 10, 2026March 31, 2024 by Kermit Matthews

Learn how to easily select multiple items from a dropdown list in Excel with our step-by-step guide. Save time and boost productivity! Continue Reading How to Select Multiple Items from a Dropdown List in Excel

Categories Excel
Excel with a month and sales data range selected, the Insert Line or Area Chart button highlighted, and the resulting line graph

How to Make a Line Graph in Excel

November 10, 2026March 13, 2024 by Kermit Matthews

Make a line graph in Excel from your data with Insert > Line Chart, add titles and multiple lines, and fix common problems like years plotted as data. Continue Reading How to Make a Line Graph in Excel

Categories Excel

How to Delete a Button in Excel (Form, ActiveX or Shape)

November 10, 2026March 13, 2024 by Kermit Matthews

Struggling to remove unwanted buttons in Excel? Follow our step-by-step guide to declutter your spreadsheet with ease. Continue Reading How to Delete a Button in Excel (Form, ActiveX or Shape)

Categories Excel

How to Format Excel Cells: A Step-by-Step Guide

November 10, 2026March 13, 2024 by Kermit Matthews

Learn how to format Excel cells like a pro with our step-by-step guide. From text alignment to number formatting, we’ve got you covered. Continue Reading How to Format Excel Cells: A Step-by-Step Guide

Categories Excel
Excel Format Cells dialog on the Font tab with the Strikethrough effect checked

How to Strikethrough in Excel (Shortcut, Partial Text and Auto Strikethrough)

November 15, 2026March 2, 2024 by Kermit Matthews

Select the cell and press Ctrl + 5, or use Ctrl + 1 > Font > Strikethrough. How to cross out part of a cell, add a button, and auto-strike done tasks. Continue Reading How to Strikethrough in Excel (Shortcut, Partial Text and Auto Strikethrough)

Categories Excel Tags excel 2013, Formatting

How to Insert a Date and Time in Excel (Shortcuts, Formulas and Formats)

November 10, 2026January 12, 2024 by Kermit Matthews

To put today’s date in an Excel cell, press Ctrl + ; (semicolon). To put the current time, press Ctrl + Shift + ;. Both… Continue Reading How to Insert a Date and Time in Excel (Shortcuts, Formulas and Formats)

Categories Excel
Spreadsheet Options Advanced Display section with Ruler units set to Centimeters

How to Change the Excel Ruler From Inches to Centimeters

November 10, 2026April 12, 2023 by Kermit Matthews

Switch Excel ruler units to centimeters in File > Options > Advanced > Display, and view the ruler in Page Layout view. Continue Reading How to Change the Excel Ruler From Inches to Centimeters

Categories Excel Tags excel 2013
Excel worksheet with the formula =A2^B2 in the formula bar and the result highlighted in column C

How to Expand All Rows in Excel for Office 365

November 10, 2026February 9, 2023 by Kermit Matthews

Expand all rows in Excel for Office 365: open grouped rows with outline numbers, unhide hidden rows, AutoFit row height, and clear filters. Continue Reading How to Expand All Rows in Excel for Office 365

Categories Excel Tags Rows
how to print all excel columns on one page

How to Prevent Extra Pages from Printing in Excel 2010

November 10, 2026January 27, 2023 by Kermit Matthews

This article contains affiliate links. If you buy through one of them, Live2Tech may earn a commission at no extra cost to you. As an… Continue Reading How to Prevent Extra Pages from Printing in Excel 2010

Categories Excel Tags excel 2010
how to copy as a picture in excel 2013

How to Copy as a Picture in Excel 2013

November 10, 2026January 23, 2023 by Kermit Matthews

When you have information in a spreadsheet that you want to use in a document or a slideshow, then you might just copy and paste… Continue Reading How to Copy as a Picture in Excel 2013

Categories Excel Tags excel 2013
how to change the first page number in excel 2013

How to Change the First Page Number in Excel 2013

November 10, 2026January 23, 2023 by Kermit Matthews

While many page numbering tasks will only involve one document, you might be combining your spreadsheet with something else for a project. This could mean… Continue Reading How to Change the First Page Number in Excel 2013

Categories Excel Tags excel 2013
how to hide the recent documents list in excel 2013

How to Stop Showing Recent Documents in Excel 2013

November 10, 2026January 23, 2023 by Kermit Matthews

Microsoft Excel will show you some of the files that you have been working on recently when you click the File tab at the top-left… Continue Reading How to Stop Showing Recent Documents in Excel 2013

Categories Excel Tags excel 2013
click the show formulas button

How to Hide Formulas in Excel 2013

November 10, 2026January 18, 2023 by Kermit Matthews

Looking at the formulas you type into a Microsoft Excel spreadsheet can help you troubleshoot issues that might arise if the formula isn’t working or… Continue Reading How to Hide Formulas in Excel 2013

Categories Excel Tags excel 2013
Excel Formulas tab with the Show Formulas button highlighted and cells displaying formulas instead of results, plus Calculation Options

Why Is Excel Showing Formulas Instead of Results?

November 10, 2026January 18, 2023 by Kermit Matthews

Fix Excel showing formulas instead of results: turn off Show Formulas, change Text cells to General, remove leading spaces, and set calculation to Automatic. Continue Reading Why Is Excel Showing Formulas Instead of Results?

Categories Excel
Spreadsheet View tab with the Formula Bar checkbox in the Show group highlighted and the formula bar showing a SUM formula

Where Is the Formula Bar in Excel? (Show, Hide, Expand)

November 10, 2026January 17, 2023 by Kermit Matthews

Find the formula bar in Excel, show or hide it from the View tab on Windows, Mac, and the web, expand it for long formulas, and fix a missing formula bar. Continue Reading Where Is the Formula Bar in Excel? (Show, Hide, Expand)

Categories Excel Tags excel 2013
Spreadsheet with a selected picture and the Insert Hyperlink dialog open with a web address entered and a ScreenTip button

How to Add a Hyperlink to a Picture in Excel

November 12, 2026January 16, 2023 by Kermit Matthews

Add a hyperlink to a picture in Excel with Ctrl+K: link to a web page, another sheet, a file or an email, add a ScreenTip, and edit or remove the link. Continue Reading How to Add a Hyperlink to a Picture in Excel

Categories Excel Tags excel 2013, Objects
Spreadsheet Page Setup dialog on the Sheet tab with Rows to repeat at top set to row 1 highlighted

How to Include a Title at the Top of Every Page in Excel 2013

November 10, 2026December 8, 2022 by Kermit Matthews

Print a title on every page in Excel 2013 with Print Titles and Rows to repeat at top, or add it to the header, plus fixes when Print Titles is grayed out. Continue Reading How to Include a Title at the Top of Every Page in Excel 2013

Categories Excel Tags excel 2013, Featured Excel Guides
Spreadsheet with rows 4 to 6 selected and the right-click menu showing Hide

How to Hide Rows and Columns in Excel 2013

November 10, 2026December 8, 2022 by Kermit Matthews

Hide rows and columns in Excel 2013 with right-click, the Format menu, or Ctrl + 9 and Ctrl + 0, unhide them again, and hide individual cell contents. Continue Reading How to Hide Rows and Columns in Excel 2013

Categories Excel Tags excel 2013, Featured Excel Guides
Spreadsheet with a bar chart selected and its right-click menu open with Save as Picture highlighted

How to Save an Excel Chart as an Image (PNG, JPG, or SVG)

November 10, 2026December 8, 2022 by Kermit Matthews

Save an Excel chart as an image with Save as Picture on Windows or Mac, choose PNG, JPG, or SVG, and use copy-paste or screenshots in Excel for the web. Continue Reading How to Save an Excel Chart as an Image (PNG, JPG, or SVG)

Categories Excel Tags Featured Excel Guides
Spreadsheet Page Setup dialog on the Sheet tab with Rows to repeat at top set to $1:$1 highlighted

How to Print the Top Row on Every Page in Excel 2016

November 13, 2026December 8, 2022 by Kermit Matthews

Print the top row on every page in Excel 2016 with Page Layout > Print Titles, repeat columns on the left, and fix a grayed-out Print Titles button. Continue Reading How to Print the Top Row on Every Page in Excel 2016

Categories Excel Tags excel 2016, Featured Excel Guides
Spreadsheet Page Layout tab with the Breaks menu open and Reset All Page Breaks highlighted

How to Remove All Page Breaks in Excel 2013 (and Newer)

November 10, 2026December 8, 2022 by Kermit Matthews

Remove all page breaks in Excel with Reset All Page Breaks, delete single breaks in Page Break Preview, hide dotted lines, and control breaks with scaling. Continue Reading How to Remove All Page Breaks in Excel 2013 (and Newer)

Categories Excel Tags excel 2013, Featured Excel Guides
Excel Page Setup dialog on the Margins tab with Center on page Horizontally and Vertically checked

How to Center a Worksheet Horizontally and Vertically in Excel 2010

November 10, 2026December 8, 2022 by Kermit Matthews

Go to Page Layout, open Page Setup, and on the Margins tab check Horizontally and Vertically under Center on page. How to preview and apply to many sheets. Continue Reading How to Center a Worksheet Horizontally and Vertically in Excel 2010

Categories Excel Tags excel 2010, Featured Excel Guides
Excel 2013 Print screen with settings for print area, orientation, margins, and scaling highlighted, plus Page Setup link

The Complete Guide to Printing in Excel 2013

November 10, 2026November 9, 2022 by Kermit Matthews

Print Excel 2013 sheets cleanly: set a print area, use landscape and narrow margins, scale to fit, repeat headers, and preview. Checklist and fixes. Continue Reading The Complete Guide to Printing in Excel 2013

Categories Excel Tags excel 2013
Spreadsheet Home tab with the Fill Color palette open and a range of cells shaded yellow

How to Fill a Cell With Color in Excel 2013

November 10, 2026November 9, 2022 by Kermit Matthews

Fill cells with color in Excel 2013 using the Fill Color button, Format Cells, or conditional formatting, and remove shading with No Fill. Continue Reading How to Fill a Cell With Color in Excel 2013

Categories Excel Tags excel 2013
Spreadsheet print screen with the settings menu open and Print Selection highlighted, and a preview showing only the selected cells

How to Print Part of a Spreadsheet in Excel

November 10, 2026June 13, 2022 by Kermit Matthews

Print only part of an Excel spreadsheet with Print Selection or a saved print area, print separate ranges, and fit the selection on one page. Continue Reading How to Print Part of a Spreadsheet in Excel

Categories Excel Tags excel 2013
Older posts
Page1 Page2 Page3 Next →

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

Live2Tech

Plain-English, step-by-step guides for the devices and apps you use every day.

Apple

  • iPhone
  • iPad
  • Mac
  • Apple Watch

Windows

  • Windows 11
  • Windows 10

Microsoft Office

  • Word
  • Excel
  • Powerpoint
  • Outlook

Google

  • Google Docs
  • Google Sheets
  • Google Slides
  • Gmail
  • Chrome
  • Google Drive
  • About Us
  • Contact
  • Disclaimer
  • Privacy Policy
© Live2Tech.com 2026
  • iPhone
  • Windows
    • Windows 11
    • Windows 10
  • Office
    • Word
    • Excel
    • Powerpoint
    • Outlook
  • Google
    • Google Docs
    • Google Sheets
    • Google Slides
    • Gmail
    • Chrome
    • Google Drive
  • Mac & Apple
    • Mac
    • iPad
    • Apple Watch
  • All Tutorials