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 proce...
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 a...
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&...
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 no...
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 Combine or Group Pie Charts in Microsoft Excel
Pie charts are popular in Excel, but they are limited. You’ll have to decide for yourself between using multiple pie charts or giving up some flexibility in favor of readability by combining them. If you do want to com...
How to Convert Text to Date Values in Microsoft Excel
Analysis of business data often requires working with date values in Excel to answer questions such as “how much money did we make today” or “how does this compare to the same day last week?” And that ...
How to Get Microsoft Excel to Calculate Uncertainty
There is doubt surrounding the accuracy of most statistical data—even when following procedures and using efficient equipment to test. Excel lets you calculate uncertainty based on your sample’s standard deviation...
How to Use Text to Columns Like an Excel Pro
Excel’s Text to Columns feature splits text in a cell into multiple columns. This simple task can save a user the heartache of manually separating the text in a cell into several columns.
How to Calculate Percentage Change with Pivot Tables in Excel
Pivot Tables are an amazing built-in reporting tool in Excel. While typically used to summarize data with totals, you can also use them to calculate the percentage of change between values. Even better: It is simple to do....
How to Use VLOOKUP on a Range of Values
VLOOKUP is one of Excel’s most well-known functions. You’ll typically use it to look up exact matches, such as the ID of products or customers, but in this article, we’ll explore how to use VLOOKUP with a ra...
How to Use Logical Functions in Excel: IF, AND, OR, XOR, NOT
Logical functions are some of the most popular and useful in Excel. They can test values in other cells and perform actions dependent upon the result of the test. This helps us to automate tasks in our spreadsheets....
