Home Sample Files e-Books Books Wholesale Forums & Support Search Contact
Login
Basic Skills
Essential Skills Expert Skills
2016 2013 2010 2007 Apple Mac

Automatically create single-cell range names:

Lesson 4-1 from: Microsoft Excel 2013 Expert Skills (167 Video Lessons)
Automatically create single-cell range names
Play Video
Play The Video
ExcelCentral Icon ExcelCentral.com
Play
Back 10 Seconds
Slower
Faster
Full Screen View
Online Video Course: Microsoft Excel 2013 Expert Skills
Session: Session 4: Using Names and the Formula Auditing Tools
Lesson: Lesson 4-1 Automatically create single-cell range names Name a cell with an Excel range name. Thumbnail from Excel 2013 Expert Skills Lesson 4-1 Automatically create single-cell range names.
Description:

This video lesson demonstrates how to automatically create range names for several cells on a Microsoft Excel worksheet. In this lesson's example, range names are automatically created for several exchange rates and are then used in formulas to calculate currency values. This lesson explains the syntax rules that Excel applies to range names and how to quickly insert a range name using the Use In Formula feature.

Share on Facebook
Share on Twitter
Share on Google+
Share on Reddit
Share on Tumblr
Share on StumbleUpon
Share by email