eHow launches Android app: Get the best of eHow on the go.
How to Record an Excel Macro
How to Add 2 Cells in Excel
How to Sum a Column or Row of Excel Cells
How to Insert a Row or Column in an Excel Spreadsheet
How to Sort a Row or Column in Excel
How to Create a Bar Graph From an Excel Spreadsheet
How to Use Provided Excel Formulas
How to Use Subtotals & Totals in an Excel Spreadsheet
How to Decide When to Use Worksheets & Workbooks in Excel
How to Add or Delete an Excel Worksheet
How to Rename an Excel Worksheet
How to Format Cell Numbers in Excel
How to Align Text in Excel Cells
How to Add a Background Color or Pattern to Excel Cells
How to Protect Excel Cells From Modification
How to Format Rows & Columns in Excel
How to Add Headers & Footers to Excel Documents
How to Add a Custom Menu to an Excel Toolbar
How to Define Cell Names in Excel
How to Define Cell Ranges in Excel
How to Use Cell Ranges in Excel Formulas
How to Use the AutoFill Function in Excel
How to Use the Freeze Pane Command in Excel to Create Static Headings
How to Save an Excel Worksheet as HTML
How to Create a Spreadsheet Template in Excel
How to Make a Circle Graph With Excel
How to Create a Message Box in Excel VBA
Summary: Defining cell ranges in Excel is done by highlighting the cell, going to insert on the menu and selecting name and define. Define cell ranges in Excel with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Amar Enhsaihan is an assistant certified public accountant (CPA) and works with Excel applications everyday on his job.read more
"Hi, I'm Amar Enhsaihan, I'm going to show you how to define range names in Excel. I have my example open. I am going to highlight the range that I'm going to name and then insert name, define, I'll name it as, anything you want. Numbers, so since we named this range, now we don't have to use the actual cell of references, we can just use a name. Check this out, I'm going to sum it up, sum up the range, sum, open parentheses, numbers, closed parentheses, and wa-la, one forth nine, sum of this range. That's how you create range names in Excel. I'm Amar Enhsaihan, thank you for watching!"
eHow Article: How to Define Cell Ranges in Excel
Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy. en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License.
