Sundry Information

How to name areas of your Excel Spreadsheet for easy access

If you want to simplify the task of locating any particular part of your spreadsheet, you can assign names to particular parts or cell arrays in your spreadsheet. It should then be possible to go to any of these areas simply by clicking on the appropriate name in the name bar. More information on this can be obtained by searching for help on 'Defining Names' and 'Going to Specific Place in Sheet' in EXCEL.

Select the cell, cell range, or nonadjacent selections you want to name. Click the name box at the left end of the formula bar to activate it. Type the name for the cell or range. Press ENTER. When you click the arrow next to the name box to view the list of names, you see the new cell or range name. If you select the name, Microsoft Excel selects the cell or range.

Go to P.V. Viswanath's Home Page