Wednesday, October 17, 2012

How to Define Cell Ranges in Excel 2003


1. Open Excel from the Start menu.
2. Choose your cell range. For example, highlight 'F5' through 'F28.' (Letters represent columns while numbers represent rows.) To highlight cells, just click and drag. To select a group of cells that are not touching, click each cell separately and hold down the 'Ctrl' key.
3. Click on the name box, which is directly above the 'A1' cell.
4. Type the new cell range name. For example, on a schedule, you might name all the time that you are commuting to work 'Commuting.' Hit the 'Enter' key.
5. Use the cell range names in your next formula. These names can make your formulas much easier to use.
6. Visit the Help section of the Microsoft Web site for more information on how to use cell range names in formulas.

Blogger news