How to Enter a Function in Excel with the Function Command
How to Protect Your Excel Workbook when Saving the File
Set Up and Define Problems in Excel's Solver Add-In Utility

How to Work with Named Ranges in Excel 2013

Step 1 of 5
Previous
Next Slideshow
Next Slideshow

You can name a range by using several different methods.

You can create a named range from a selection, or you can enter a cell name in the Name box to the left of the Formula bar. Another option for naming a range in Excel: choosing the Define Name command.

  • Add a Comment
  • Print
  • Share

Recommends

Promoted Stories From Around The Web

COMMENTS »
blog comments powered by Disqus
How to Create Sparklines in Excel 2013
 
Top 10 New Features in Excel 2013
How to Use the Excel 2013 Quick Analysis Tool
How to Use Ready-Made Number Filters in Excel 2013
How to Perform Analyses of Variance in Excel