No Image Available
Mike Thomas

IBM

Training Consultant

Read more from Mike Thomas

Defining and Using Range Names in Excel

Learn how to assign names to cells and ranges in Excel to simplify formulas and navigate large spreadsheets more efficiently. Range names can be scoped at the worksheet or workbook level, making your spreadsheets more organized and easier to understand.
default-16x9

Excel allows you to assign a name to an individual cell or a range of cells. That name can be used in a formula and can help to make the formula easier to understand.

Names can also make it easier to navigate around a large spreadsheet. In Excel 2007 and 2010, names have a scope assigned to them, meaning that a name can be a worksheet-level name or a workbook-level name.

Find out more in my easy-to-follow short tutorial: http://mthomas.co.uk/defining-and-using-range-names-in-excel/

Excel allows you to assign a name to an individual cell or a range of cells. That name can be used in a formula and can help to make the formula easier to understand.

Names can also make it easier to navigate around a large spreadsheet. In Excel 2007 and 2010, names have a scope assigned to them, meaning that a name can be a worksheet-level name or a workbook-level name.

Find out more in my easy-to-follow short tutorial: http://mthomas.co.uk/defining-and-using-range-names-in-excel/

Newsletter Subscription

Elevate your L&D expertise by subscribing to TrainingZone’s newsletter.

"*" indicates required fields

This field is for validation purposes and should be left unchanged.
Name*
Email*
Privacy*
Additional Options