Tuesday, November 15, 2011

How to Define Cell Names in Excel 2003


1. Go to the Start menu and open Excel.
2. Decide which cells you would like to define. You can do this by highlighting them with your mouse. If you want to define multiple cells that are not next to each other, click on each of them and hold down the 'Ctrl' button.
3. Click on the name box, which is is directly above the 'A1' cell. Once you click on the cell, it will be ready for you to type the new name.
4. Type the new name for the cell(s). For example, if you are making a budget and you want to name the cells accordingly, you might name them 'debit' or 'bill.'
5. Press 'Enter' to save the name into the name box. If you forget to do this, your name will be lost.
6. Use the names to make your formulas simpler. Now you can use 'debit' as a part of your next formula. This simplifies everything.
7. Visit the Help section of Microsoft.com for more information on how to make formulas. There are a few things that you need to know to make your formulas work properly.

Blogger news