Latest 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. Here's how to make one in Microsoft Excel.
How to Include Captions in Microsoft Excel Graphs
Include captions in your Excel graphs to provide rich and meaningful labels. Here's how.
How to Sync Microsoft Excel Spreadsheets
Sync Excel spreadsheets together so that changes in one are automatically reflected in the other. Here's how.
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. Fortunately, you can lock the position of a chart in Excel.
How to Create Expense and Income Spreadsheets in Microsoft Excel
Create an expenses and income Microsoft Excel spreadsheet to help manage your personal finance. Here's how.
How to Use Cell Values for Excel Chart Labels
Make dynamic chart labels in Microsoft Excel by linking them to cell values. When the data changes, the chart labels automatically update.
How to Use the TRUNC Function in Excel
The TRUNC function in Excel provides a unique way of handling decimal places and shortening your numbers. Here's how to use it.
How to Create a Dynamic Defined Range in Excel
Your Excel data changes frequently with new data constantly added and deleted. It is 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 by default. This article will show you step by step how to change those angled lines to smooth curved lines.
How to Stop Excel From Moving the Selection Box When You Hit Enter
When you type information into Excel and press Enter, the selection box moves to the cell below. If you don't like that default behavior, it can be changed.
How to Find and Replace Text and Numbers in Excel
The Find and Replace tool is a powerful and often forgotten feature of Excel. Here's the full array of options this feature has and how much it can help you.
How to Print a Specific Selection of Cells in Excel
You sometimes want to print only a specific selection of cells. This article will demonstrates two ways to print only a selected area on the worksheet in Microsoft Excel.
How to Use the XLOOKUP Function in Microsoft Excel
The new XLOOKUP function is now available in Excel. It is the successor to VLOOKUP and HLOOKUP and is a huge improvement. Here's what you need to know.
How to Export Contacts from an Excel Worksheet to Outlook
Contact details stored in Excel can be easily exported into Outlook. The process is as simple as converting the list as a CSV and then importing the file. Here's how.
How to Hide Error Values and Indicators in Microsoft Excel
Excel formulas can produce errors that don't require fixing. Fortunately, you can hide these errors, keeping your spreadsheets working correctly.
How to Remove Smart Tags from a Workbook in Excel
Smart tags can be very useful in Excel to quickly change the action that a spreadsheet performs on your data. Here's how to remove them if they're unneeded.
Everything You Need to Know About Co-Authoring in Excel
When you co-author in Excel, you can collaborate with your colleagues in real-time. Here's how to do it.
How to Calculate Percent Increases in Excel
Need to calculate a percent increase in Excel? Here's how you can do it.
How to Create a Combo Chart in Excel
A combo chart displays two chart types in a single diagram and can show actual values against a target. Here's how to create a combo chart in Excel.
How to Switch to Editing Mode in Excel
When opening Excel files from unknown sources, Protected View shields you from potential threats. These threats can include viruses and malware, so Protected View is very useful. However to work on a spreadsheet you need to switch to editing mode. This article will explain how to switch to editing mode, and how to enable automatic switching to editing mode in the future.