Thursday, December 27, 2012

How to Define Names Labels in Microsoft Excel 2003


1. Open the Microsoft Excel 2003 program and then click the 'Tools' option from the top toolbar menu.
2. Click the 'Options' button and then click the 'Calculations' tab. Select the box next to the 'Accept labels in formulas' field, and then close out of the dialog box.
3. Use your mouse to select a range of cells in your worksheet that you want to define names for.
4. Click the 'Name' field from the left side of the formula bar. Enter the name you want for the group of cells.
5. Press the 'Enter' key on your keyboard, and the names will be added.

Blogger news