Microsoft KB Archive/109245

Microsoft Knowledge Base

XL: Can't Access Name Box with Key Commands

Last reviewed: March 27, 1997
Article ID: Q109245

5.00 5.00c 7.00 | 5.00

WINDOWS         | MACINTOSH

kbusage

The information in this article applies to:

• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for Windows 95, version 7.0
• Microsoft Excel for the Macintosh, version 5.0

SUMMARY

In Microsoft Excel versions 5.x and 7.0, to access the name box, you must use a mouse or other pointing device (such as a trackball). You cannot access the name box with key combinations.

MORE INFORMATION

The name box allows you to define names and select named ranges without having to use the Define Name or Go To dialog boxes. The name box is located in the formula bar.

To define a name without using the name box, you must use the Define Name dialog box. To do this using only a keyboard:

• Press CTRL+F3 to display the Define Name dialog box.

-or-

1. Press ALT+I to access the Insert menu.
2. Press N to access the Name submenu.
3. Press D to display the Define Name dialog box.

To go to a named range without using the name box, you must use the Go To dialog box. To do this using only a keyboard:

1. Press F5 or CTRL+G to display the Go To dialog box.

-or-

1. Press ALT+E to access the Edit menu.
2. Press G to display the Go To dialog box.

REFERENCES

"User's Guide," version 5.0, pages 142-148

KBCategory: kbusage KBSubcategory: Additional reference words: 5.00 5.00c 7.00 Keywords : kbusage Version : 5.00 5.00c 7.00 | 5.00 Platform : MACINTOSH WINDOWS THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Last reviewed: March 27, 1997 ©1997 Microsoft Corporation. All rights reserved. Legal Notices.