Home / Alan Murray

Alan Murray

How to Create a Dynamic Defined Range in Excel

Your Excel information adjustments continuously, so it’s helpful to create a dynamic outlined vary that robotically expands and contracts to the dimensions of your information vary. Let’s see how. Through the use of a dynamic outlined vary, you’ll not must manually edit the ranges of your formulation, charts, and PivotTables …

Read More »

How to Make a Curved Graph in Excel

If you create a line graph in Excel, the strains are angled and have exhausting edges by default. You’ll be able to simply change this to a curved graph with good, easy strains for a extra polished look. We’ll stroll you thru the method step-by-step to transform your graph. On …

Read More »

How to Print a Specific Selection of Cells in Excel

Generally you need to print solely a selected choice of cells on a worksheet. However once you print in Microsoft Excel, all information on a worksheet is printed by default. This text will present two methods to print a specific vary. Printing a Particular Collection of Cells in Microsoft Excel …

Read More »

How to Use the XLOOKUP Function in Microsoft Excel

Excel’s new XLOOKUP will exchange VLOOKUP, offering a strong substitute to one in every of Excel’s hottest capabilities. This new operate solves a few of VLOOKUP’s limitations and has additional performance. Right here’s what you must know. What’s XLOOKUP? The brand new XLOOKUP operate has options for among the greatest limitations …

Read More »

How to Apply Shading to Alternate Rows in Excel

Making use of coloration to alternate rows makes your spreadsheet knowledge simpler to learn. In Excel, that is fast and easy to use by formatting your knowledge as a Desk. The row shading is then mechanically utilized to new rows added to the desk. The right way to Format Your …

Read More »

How to Export Contacts from an Excel Worksheet to Outlook

Contact particulars saved in an Excel Worksheet could be simply exported after which imported into Outlook. As soon as the Excel file is saved to a CSV format, you’ll be able to import it into your Outlook contacts listing. Save Your Contacts as a CSV File The contacts listing beneath …

Read More »

How to Hide Error Values and Indicators in Microsoft Excel

Your Excel formulation can sometimes produce errors that don’t want fixing. Nonetheless, these errors can look untidy and, extra importantly, cease different formulation or Excel options from working appropriately. Happily, there are methods to cover these error values. Conceal Errors with the IFERROR Operate The best technique to disguise error …

Read More »

How to Remove Smart Tags from a Workbook in Excel

Good tags will be very helpful in Excel to rapidly change the motion a spreadsheet performs in your knowledge. They seem robotically as you’re employed in Excel, however every good tag will be eliminated if you don’t use them. What Are Good Tags? A sensible tag is a small button …

Read More »