#### Changing the Capitalization of a Single Cell

**1. UPPER Function:**

- To change the content of a single cell (e.g., A1) to uppercase, enter the formula
**=UPPER(A1)**in another cell (e.g., B1).

**2. LOWER Function:**

- To change the content of a single cell (e.g., A1) to lowercase, enter the formula
**=LOWER(A1)**in another cell (e.g., B1).

**3. PROPER Function:**

- To change the content of a single cell (e.g., A1) to proper case, enter the formula
**=PROPER(A1)**in another cell (e.g., B1).

#### Changing the Capitalization of Multiple Cells

**1. UPPER, LOWER, or PROPER Functions with Range:**

- Use the functions with a range reference to change the capitalization of multiple cells.
- Example:
**=UPPER(A1:A10)**,**=LOWER(A1:A10)**,**=PROPER(A1:A10)**.

#### Changing the Capitalization of a Column, Row, or Range

**1. Select the Target Range:**

- Select the column, row, or range of cells you want to modify.

**2. Use the Appropriate Function:**

- For a column, use formulas like
**=UPPER(A1)**in cell B1 and drag it down. - For a row, use formulas like
**=UPPER(A1)**in cell B1 and drag it across. - For a range, use formulas like
**=UPPER(A1:B10)**in cell C1.

#### Changing the Capitalization of a Worksheet or Workbook

**1. Apply Functions to Entire Worksheet or Workbook:**

- For an entire worksheet, use formulas like
**=UPPER(A1:A1048576)**in cell B1 (adjust the range as needed). - For an entire workbook, apply the formulas to the respective cells in each sheet.

#### Note:

**UPPER Function:**Converts text to uppercase.**LOWER Function:**Converts text to lowercase.**PROPER Function:**Converts the first letter of each word to uppercase.

#### Example:

- If cell A1 contains "example TEXT," using
**=UPPER(A1)**in cell B1 will result in "EXAMPLE TEXT." - Using
**=LOWER(A1)**will result in "example text." - Using
**=PROPER(A1)**will result in "Example Text."

These functions provide flexibility in changing the capitalization based on your specific needs, whether for a single cell, a range, or an entire worksheet/workbook. Adjust the formulas according to the location and extent of the data you want to modify.