14 Excel tips every user should master


Whether you are a Microsoft Excel beginner or an advanced user, you’ll benefit from these step-by-step tutorials.

People near the Microsoft store on Fifth Avenue in New York City.

Image: Bumblee_Dee, iStock/Getty Images

Microsoft Excel was first released in 1985, and the spreadsheet program has remained popular through the years. You can master Excel by reading these tips and tricks on how to add a drop-down list in an Excel cell to finding duplicates, how to delete blank rows in Excel, and more.

LEARN MORE: Office 365 Consumer pricing and features


<strong>How to use named ranges to quickly navigate an Excel workbook</strong>

Named ranges aren’t just for formulas. Here are two ways you can use named ranges to create shortcuts for quick navigation in a Microsoft Excel workbook.


How to combine formulas with Excel’s data validation and a Word Replace trick

These tutorials based on readers’ questions detail how to combine formulas with Excel’s data validation and feature a Word Replace trick.


<strong>How to use Excel’s border options by creating a simple floor plan</strong>

Applying borders to your sheets will make them more readable and easier to use. Learn how to use borders efficiently by creating a simple floor plan.

How to add a drop-down list to an Excel cell
Drop-down lists can greatly facilitate data entry. Here’s a look at how to use Excel’s data validation feature to create handy lists within your worksheets.

A quick way to delete blank rows in Excel
Deleting blank rows in an Excel data range is easy with this technique, but watch out for unintended consequences.

How to password protect an Excel workbook
At the file level, you can password protect an Excel workbook in two ways: You can determine who can get in and who can save changes.

Entering leading zeroes in Excel
By default, Microsoft Excel won’t display or store leading zeros. Read this Excel tip to learn three…



www.techrepublic.com