We select and review products independently. When you purchase through our links we may earn a commission. Learn more.
X
X
The Best Tech Newsletter Anywhere

Join 425,000 subscribers and get a daily digest of news, geek trivia, and our feature articles.

Sign Up Here arrow indicating signup email field.

How to Apply Shading to Alternate Rows in Excel

Applying color to alternate rows makes your spreadsheet data easier to read. In Excel, this is quick and simple to apply by formatting your data as a Table. The row shading is then automatically applied to new rows added to t…

How to Calculate Percent Increases in Excel

If you can calculate percentages in Excel, it comes in handy. For example, you might need to calculate the tax on a sale, or the percentage of change in sales from last month to this month. Here’s how you do it!…

How to Use the XLOOKUP Function in Microsoft Excel

Excel’s new XLOOKUP will replace VLOOKUP, providing a powerful replacement to one of Excel’s most popular functions. This new function solves some of VLOOKUP’s limitations and has extra functionality. Here’s what you need to…

How to Create a Combo Chart in Excel

A combo chart in Excel displays two chart types (such as column and line) on the same chart. They are used to show different types of information on a single chart, such as actuals against a target.

How to Switch to Editing Mode in Excel

When opening Excel spreadsheets from unknown sources, a feature in Excel called Protected View shields you from potential risks. This is great, but to work on the document, you will need to switch to editing mode….

How to Enter Zero Before a Number in Excel

When entering numbers into Excel, zeros at the beginning of the number are removed. This can be an issue when entering phone numbers and IDs. In this article, we will cover ways to solve this problem and keep the leading ze…

How to Save Time with Excel Themes

An Excel theme is a collection of colors, fonts, and effects that you can apply to a workbook with a couple of clicks. Themes ensure a consistent and professional look to your reports, and they let you more easily adhere to …

How to Insert a PDF Into Excel

Excel provides a plethora of features for organizing, manipulating, and handling your data. One of these unique features is inserting a PDF directly into Excel. The good news is it only involves a few simple steps to do it. H…

Use Excel to Calculate How Many Days Until an Event

Excel stores dates as integers. By default, Excel uses “1” to represent 01/01/1900 and each day after that is one greater. Type in 01/01/2000 and switch the format to “Number” and you’ll see “36526” appear. If you subtract 1 …

How to Create a Simple Invoice Using Excel

Whether you’re a freelancer doing work for multiple companies, or a business that plans on extending a credit line to its customers, you’re going to need an invoice. Creating a custom invoice in Excel isn’t difficult. Y…
How-To Geek is where you turn when you want experts to explain technology. Since we launched in 2006, our articles have been read billions of times. Want to know more?