Daniel901Johnson's picture
From Daniel901Johnson rss RSS  subscribe Subscribe

Microsoft Excel 2003 - How To Name A Range (2) 

 

 
 
Views:  25
Published:  February 15, 2012
 
0
download

Share plick with friends Share
save to favorite
Report Abuse Report Abuse
 
Related Plicks
Options for Microsoft Office Training

Options for Microsoft Office Training

From: Khathcautopilot
Views: 80 Comments: 0
All about Microsoft Office, please check the provided website.
 
2003guide

2003guide

From: bogls22
Views: 314 Comments: 0
2003guide
 
Free Microsoft 70-291 Practice Exams

Free Microsoft 70-291 Practice Exams

From: Newexmas
Views: 33 Comments: 0
http://www.selftestexams.com offers Free Microsoft 70-291 Practice Exams provide you a best chance to prepare your exams and main thing is that you can familiarity with nature of exams questions Thus can prepare your certification in better way.
 
The Secret To Passing The Microsoft Office

The Secret To Passing The Microsoft Office

From: Khathcautopilot
Views: 86 Comments: 0
All about Microsoft Office, please check the provided website.
 
2003 Yamaha Outboard Service Repair Manual DOWNLOAD (42)

2003 Yamaha Outboard Service Repair Manual DOWNLOAD (42)

From: Aferself178
Views: 58 Comments: 0

 
2003 Yamaha Outboard Service Repair Manual DOWNLOAD 03 (15)

2003 Yamaha Outboard Service Repair Manual DOWNLOAD 03 (15)

From: Souldive398
Views: 1282 Comments: 0

 
See all 
 
More from this user
Toile Bedding (398)

Toile Bedding (398)

From: Daniel901Johnson
Views: 94
Comments: 0

Facebook Advertising Tips That Work

Facebook Advertising Tips That Work

From: Daniel901Johnson
Views: 55
Comments: 0

Toile Bedding (318)

Toile Bedding (318)

From: Daniel901Johnson
Views: 89
Comments: 0

Downloading Ipod Music

Downloading Ipod Music

From: Daniel901Johnson
Views: 116
Comments: 0

Uniforms For Nurses

Uniforms For Nurses

From: Daniel901Johnson
Views: 77
Comments: 0

Social Media Internet Marketing Drives More Traffic To Your Business

Social Media Internet Marketing Drives More Traffic To Your Business

From: Daniel901Johnson
Views: 88
Comments: 0

See all 
 
 
 URL:          AddThis Social Bookmark Button
Embed Thin Player: (fits in most blogs)
Embed Full Player :
 
 

Name

Email (will NOT be shown to other users)

 

 
 
Comments: (watch)
 
 
Notes:
 
Slide 1: Microsoft Excel 2003 - How To Name A Range One of the most common functions that you will use in Microsoft Excel is to name a cell. The role of naming the cell is simply to provide you with a name to remember rather than a specific cell address like B2 or B3. However, one of the cool functions that Microsoft has incorporated into Microsoft Excel is the ability to name a range of cells and utilize the range when required. There are a number of approaches that could be undertaken to name a range however the most common technique is to use the menu bar in Microsoft Excel 2003. The first step is to create a basic sheet with some data in it. I have outlined below a small table to enter into a worksheet and the cell location to place the values. Cell C6: Products Cell D6: Value Cell C7: Shoes Cell D7: $5.00 Cell C8: Pants Cell D8: $15.00 Cell C9: Thongs Cell D9: $23.00 The first step in naming a range is to select the range. Select using your mouse the range from C6 to D9. Once you have completed this go to the Insert menu, then choose Name, and then Define from the expanded menu. At this point the Define Name dialog box will appear. Type in the Names in Workbook text box the name - MyProducts and then press the OK button. You will notice that in the Refers To text box that your cell range selection has dollar symbols around it. Those dollar symbols inform Microsoft Excel, that on selection of the name you must absolutely refer to those cells. You have now defined a Named Range. The next step in this process is to use the name range. The easiest way to do this is to first select the cell A1 on your worksheet. Now, goto the Name box on your formula bar and click on the drop down arrow. In the drop down box you will see the name - MyProducts. Simply choose the name. You will now see the cell range automatically selected in your worksheet. There are many different areas in Microsoft Excel where you would use the Name Range. The most common time is when you want to create drop down lists in your spreadsheet. We use the name range capability, so that we can place the list on a different worksheet to the one we want to reference. Luxury bedding collections

   
Time on Slide Time on Plick
Slides per Visit Slide Views Views by Location