Name a Cell or Range Using the Name Box : Cells Name « Formula « Microsoft Office Excel 2007 Tutorial

Microsoft Office Excel 2007 Tutorial

1.	Introduction
2.	Editing
3.	Format Style
4.	Table
5.	Chart
6.	Formula
7.	Workbook Worksheet
8.	Wordart Clip Art Shape Picture
9.	PivotTable PivotChart
10.	Data Analysis
11.	Macro ActiveX Add in
12.	Security
13.	Collaboration
14.	Database functions
15.	Date Time functions
16.	Engineering functions
17.	Information functions
18.	Logical functions
19.	Lookup Reference functions
20.	Math Trigonometry functions
21.	Statistical functions
22.	Text functions

VBA / Excel / Access / Word

Microsoft Office PowerPoint 2007 Tutorial

Microsoft Office Word 2007 Tutorial

Microsoft Office Excel 2007 Tutorial » Formula » Cells Name

6.4.1.Name a Cell or Range Using the Name Box

A range name can include up to 255 characters, uppercase or lowercase letters (not case sensitive), numbers, and punctuation, but no spaces or cell references.

Select the cell or a range, or nonadjacent selections.

Click the Name box on the formula bar. 

           Type a name for the range. Press Enter

Click the Name box on the formula bar. Type a name for the range. Press Enter

The range name will appear in the Name box whenever you select the range in the workbook.

6.4.Cells Name
	6.4.1.	Name a Cell or Range Using the Name Box
	6.4.2.	Let Excel Name a Cell or Range
	6.4.3.	Name a Cell or Range Using the New Name Dialog Box
	6.4.4.	Enter a Named Cell or Range Using the Name Box
	6.4.5.	Enter a Named Cell or Range Using Formula AutoComplete
	6.4.6.	Enter a Named Cell or Range from the Use in Formula Command
	6.4.7.	Apply a Name to a Cell or Range Address
	6.4.8.	Organize and View Names: Edit, Delete
	6.4.9.	Name Manager Filter Options
	6.4.10.	Change a Name
	6.4.11.	Delete a name range

www.java2java.com | Contact Us

All other trademarks are property of their respective owners.