How to Capitalize Everything in a Row in Microsoft Excel 2003

Capitalizing a Row of Cells
1. Start Microsoft Excel 2003, and open your spreadsheet.
2. Click the row number, not the cell, of the row immediately beneath the one you want to capitalize.
3. Right-click and select 'Insert' to insert an empty new row.
4. Click the cell in the new row that is directly beneath the left-most cell of the row you want to capitalize.
5. Type '=UPPER(name of cell immediately above the one you are typing in)'. Press 'Enter.'
6. Click the cell you just typed in to select it, and then hold the cursor in the lower-right corner of the cell until a black plus sign appears.
7. Hold the left mouse button down, and drag the cursor to the right, highlighting the whole row you want to capitalize.