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