How-To Geek

Alan Murray-

Alan Murray

  • 34
    articles

About Alan Murray

Alan is a freelance Microsoft Excel writer and trainer from the UK. When he is not writing, he can be found running, hiking or drinking real ale.

Latest Articles

Excel Logo on a gray background 1
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.

Excel Logo on a gray background 1
How to Include Captions in Microsoft Excel Graphs

Include captions in your Excel graphs to provide rich and meaningful labels. Here's how.

Excel Logo on a gray background 1
How to Sync Microsoft Excel Spreadsheets

Sync Excel spreadsheets together so that changes in one are automatically reflected in the other. Here's how.

Excel Logo on a gray background 1
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.

Excel Logo on a gray background 1
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.

Excel Logo on a gray background 1
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.

Excel Logo on a gray background 1
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.

Excel Logo on a gray background 1
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.

Excel Logo on a gray background 1
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.

Excel Logo on a gray background 1
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.

Excel Logo on a gray background 1
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.

Excel Logo on a gray background 1
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.

Excel Logo on a gray background 1
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.

Excel Logo on a gray background 1
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.

Excel Logo on a gray background 1
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.

Excel Logo on a gray background 1
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.

Excel Logo on a gray background 1
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.

Excel Logo on a gray background 1
How to Calculate Percent Increases in Excel

Need to calculate a percent increase in Excel? Here's how you can do it.

Excel Logo on a gray background 1
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.

Excel Logo on a gray background 1
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.

1 2
Page 1 / 2