How to Capitalize Everything in a Row in Microsoft Excel 2003

Microsoft Excel makes it easy to organize data and information, but its functionality extends beyond just organization. In Excel, formulas provide you with a broad suite of tools. Although many formulas are used for performing calculations on numbers, there are also formulas to help you format text. Formulas can save you time if you need to change the case of an entire row of cells. The "Upper," "Lower" and "Proper" worksheet functions control whether words in the spreadsheet are all upper case, lower case or title case. Using these formulas is easy to learn.

...
Microsoft Excel formulas can be used to perform calculations or format text.

Capitalizing a Row of Cells

Step

Start Microsoft Excel 2003, and open your spreadsheet.

Step

Click the row number, not the cell, of the row immediately beneath the one you want to capitalize.

Step

Right-click and select “Insert” to insert an empty new row.

Step

Click the cell in the new row that is directly beneath the left-most cell of the row you want to capitalize.

Step

Type “=UPPER(name of cell immediately above the one you are typing in)”. Press "Enter."

Step

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.

Step

Hold the left mouse button down, and drag the cursor to the right, highlighting the whole row you want to capitalize.