Choose Formula Bar from the View menu to display the formula bar. You will be creating an income statement worksheet. Remember to hold down the Ctrl key when selecting a discontinuous range. Naming Cells Excel allows you to name any cell, range, or value in a workbook. You can then use this name to refer to the cell,range, or value.
Names make formulas easier to read, understand, and maintain.
You can change or delete names that have been defined previously. Names appear in the reference area of the formula bar when you select a named cell or range. Select cell B6 and choose Name from the Insert menu, and choose Define from the Name submenu. This is fine. Click the OK button.