به روز

When rearranging a worksheet, you can save time by combining cell attributes. For example,

if you need to copy several formulas to a range but you don’t want to disturb the existing

formatting, you can tell Excel to copy only the formulas.

If you want to copy only selected cell attributes, follow these steps:

1. Select and then copy the range you want to work with.

2. Select the destination range.

3. Select Home, pull down the Paste menu, and then select Paste S pecial. Excel displays

the Paste Special dialog box, as shown in Figure 1.9 .

4. In the Paste group, click the attribute you want to paste into the destination range:

A ll Pastes all the source range’s cell attributes.

F ormulas Pastes only the cell formulas (you can also select Home, Paste,

F ormulas).

V alues Converts the cell formulas to values and pastes only the values. (you can

also select Home, Paste, Paste V alues).

Forma t s Pastes only the cell formatting.

C omments Pastes only the cell comments.

Validatio n Pastes only the cell-validation rules.

All Using Source

T h eme

Pastes all the cell attributes and then formats the copied range using the

theme that’s applied to the copied range.

All E x cept Borders Pastes all the cell attributes except the cell’s border formatting (you can

also select Home, Paste, No B orders).

Column W idths Changes the width of the destination columns to match the widths of the

source columns. No data is pasted.

Fo r mulas and

Number Formats

Pastes the cell formulas and numeric formatting.

Val u es and Number

Formats

Converts the cell formulas to values and pastes only the values and the

numeric formats.

All Mer g ing

Condition Formats

Pastes all the cell attributes and merges the conditional formatting from

the source and destination ranges.

5. If you don’t want Excel to paste any blank cells included in the selection, select the

Skip B lanks check box.

6. If you want to paste only formulas that set the destination cells equal to the values of

the source cells, click Paste L ink. (For example, if the source cell is A1, the value of the

destination cell is set to the formula =$A$1 .) Otherwise, click OK to paste the range.