Excel skills

1. Fill in alternate rows

Method:

1. Select the target cells that need to be filled in alternate rows.

2. [Conditional Formatting]-[New Rule]-[Use formulas to determine the cells to be formatted].

3. Enter: =mod(row(),2)=1 in [Format values ​​that match this formula].

4. Click [Format]-[Fill] in the lower right corner, select the fill color and [OK]-[OK].

2. Add units uniformly

Method:

1. Select the target cell.

2. Use the shortcut key Ctrl 1 to open the [Format Cells] dialog box and select [Customize] under the category.

3. Add unit: ten thousand yuan or other suffix after [Type], and [OK].

3. Quickly insert\delete rows

Method:

1. Select the number of rows to be inserted or deleted.

2. Shortcut key Ctrl Shift (plus sign) or Ctrl - (plus sign).

4. Align characters of different lengths

Method:

1. Select the target cell.

2. Press the shortcut key Ctrl 1 to open the [Format Cells] dialog box.

3. Select the [Alignment] tab, and select [Distributed Alignment (Indent)]-[OK] under [Horizontal Alignment].

Recommended tutorial: excel tutorial

The above is the detailed content of Excel skills. For more information, please follow other related articles on the PHP Chinese website!