We select and review products independently. When you purchase through our links we may earn a commission. Learn more.

#### Complete Guidesby How-To Geek

X
X

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

## How to Make a Tally Graph in Microsoft Excel

A tally graph is a table of tally marks to present the frequency in which something occurred. Microsoft Excel has a large number of built-in chart types available, but it does not have a tally graph option. Fortunately, this …

## How to Include Captions in Microsoft Excel Graphs

Include captions in your Microsoft Excel graphs to provide rich and meaningful labels. The labels can be used to display extra information that is not plotted on the graph. By linking them to cell values, you can make these c…

## How to Sync Microsoft Excel Spreadsheets

You can sync Microsoft Excel spreadsheets to ensure that changes in one will automatically be reflected in another. It is possible to create links between different worksheets as well as separate Excel workbooks. Let’s look a…

## How to Lock the Position of a Chart in Excel

If you insert or resize columns and rows in a spreadsheet, the position and size of your charts change. Charts automatically relocate because they are set to move and resize with cells. Fortunately, you can lock the position …

## How to Use Cell Values for Excel Chart Labels

Make your chart labels in Microsoft Excel dynamic by linking them to cell values. When the data changes, the chart labels automatically update. In this article, we explore how to make both your chart title and the chart data …

## How to Use the TRUNC Function in Excel

There are a variety of ways in Excel to remove decimal points and shortening number values. In this article, we explain how to use the TRUNC function and what makes it different from other techniques.

## How to Create a Dynamic Defined Range in Excel

Your Excel data changes frequently, so it’s useful to create a dynamic defined range that automatically expands and contracts to the size of your data range. Let’s see how.

## How to Make a Curved Graph in Excel

When you create a line graph in Excel, the lines are angled and have hard edges by default. You can easily change this to a curved graph with nice, smooth lines for a more polished look. We’ll walk you through the process ste…

## How to Stop Excel From Moving the Selection Box When You Hit Enter

When you type information into Excel and press the Enter key, the selection box moves to the cell below. This is the standard behavior of Excel, but you might find this frustrating. Fortunately, the default setting can be cha…

## How to Find and Replace Text and Numbers in Excel

The Find and Replace tool is a powerful yet often forgotten feature of Excel. Let’s see how it can be used to find and replace text and numbers in a spreadsheet and also some of its advanced features.

## How to Print a Specific Selection of Cells in Excel

Sometimes you want to print only a specific selection of cells on a worksheet. But when you print in Microsoft Excel, all data on a worksheet is printed by default. This article will show two ways to print a selected range….

## 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 Export Contacts from an Excel Worksheet to Outlook

Contact details stored in an Excel Worksheet can be easily exported and then imported into Outlook. Once the Excel file is saved to a CSV format, you can import it into your Outlook contacts list.

## How to Hide Error Values and Indicators in Microsoft Excel

Your Excel formulas can occasionally produce errors that don’t need fixing. However, these errors can look untidy and, more importantly, stop other formulas or Excel features from working correctly. Fortunately, there are way…

## How to Remove Smart Tags from a Workbook in Excel

Smart tags can be very useful in Excel to quickly change the action a spreadsheet performs on your data. They appear automatically as you work in Excel, but each smart tag can be removed if you do not use them….

## Everything You Need to Know About Co-Authoring in Excel

Co-authoring enables you and your colleagues to work on the same Excel workbook simultaneously. Everyone sees all changes in real-time, and across all devices that run Excel for Office 365, for the web, or any mobile version….

## 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 Work with Trendlines in Microsoft Excel Charts

You can add a trendline to a chart in Excel to show the general pattern of data over time. You can also extend trendlines to forecast future data. Excel makes it easy to do all of this.

## 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 Cross Reference Cells Between Microsoft Excel Spreadsheets

In Microsoft Excel, it’s a common task to refer to cells on other worksheets or even in different Excel files. At first, this can seem a little daunting and confusing, but once you understand how it works, it’s not so hard….

## 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 Geek is where you turn when you want experts to explain technology. Since we launched in 2006, our articles have been read more than 1 billion times. Want to know more?