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 Use the Built-In Geography Feature in Microsoft Excel

Instead of researching and updating geographical data in your spreadsheets, save time by using the tools provided to you by Microsoft. The built-in Geography feature in Microsoft Excel will do the heavy lifting for you….

## How to Use Exponents in Excel

Exponents are simply repeated multiplications. For example, four to the third power (4³) isn’t 4 x 3, it’s 4 x 4 x 4, which equals a total of 64. If that sounds complicated, fear not; Excel can do the heavy lifting for you…

## How to Make a Title Line on an Excel Spreadsheet

There are several ways to add a customized title to a spreadsheet in Microsoft Excel. Titles aren’t just for file names—you can place one right above your spreadsheet data so viewers can understand it more easily….

## How to Use the YEAR Function in Microsoft Excel

If you need to quickly extract the year from a date in Microsoft Excel, you can use the YEAR function. This will give you the year value in a separate cell, allowing you to use it in a separate formula….

## How to Add Alternative Text to an Object in Microsoft Excel

Alternative text (alt text) allows screen readers to capture the description of an object and read it aloud, providing aid for those with visual impairments. Here’s how to add alt text to an object in Microsoft Excel….

## How to Rename a Data Series in Microsoft Excel

A data series in Microsoft Excel is a set of data, shown in a row or a column, which is presented using a graph or chart. To help analyze your data, you might prefer to rename your data series.

## How to Sort by Date in Microsoft Excel

When you’re trying to look at a set of data in a spreadsheet over time, it’s often helpful to be able to sort the data using the dates in that range, which Microsoft Excel allows you to do using the built-in sort tool. Here’s…

## How to Make a Bar Chart in Microsoft Excel

A bar chart (or a bar graph) is one of the easiest ways to present your data in Excel, where horizontal bars are used to compare data values. Here’s how to make and format bar charts in Microsoft Excel….

## How to Create a Histogram in Microsoft Excel

Histograms are a useful tool in frequency data analysis, offering users the ability to sort data into groupings (called bin numbers) in a visual graph, similar to a bar chart. Here’s how to create them in Microsoft Excel….

## 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 Save an Excel Sheet as a PDF

Saving an Excel spreadsheet as a PDF can be confusing, and the finished file often looks different from how we want it to be presented. Here’s how to save a sheet as a readable clean PDF file.

## How to Use Mentions in Microsoft Office 365 Comments

When you’re adding comments to a Word document, Excel spreadsheet, or PowerPoint presentation, Office 365 lets you mention another user using the “@” sign (like most chat apps). Here’s what Office 365 mentions are for and how…

## 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 Group Worksheets in Excel

If you’re editing multiple worksheets in Microsoft Excel, it might be helpful to group them together. This allows you to make changes to the same range of cells across multiple worksheets. Here’s how to do it….

## How to Convert Currency in Microsoft Excel

Microsoft Excel doesn’t include built-in tools to convert currency. However, you can use an external data source to provide up-to-date rates. A basic multiplication formula will then convert from one currency to another. Here…

## 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 Make One Long Column into Multiple Columns in Excel

Too much data in a single column can make your Microsoft Excel spreadsheet harder to read. To improve it, you should consider splitting up your column using the “Text to Columns” or “Flash Fill” features….

## 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 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?