Microsoft Office Tutorials and References

In Depth Information

**Fancy Pasting Tricks**

Moving Cells Around

click the picture to finish the paste. Or move your mouse over a different option

to preview
its
results. And if you get cold feet, you can call the whole thing off by

clicking any cell on the worksheet, in which case the preview will disappear and the

worksheet will return to its previous state.

Figure 15-7:

In this example, the original

data is in cells C1 to C6. The

paste preview is shown in cells

E1 to E6. Here, the preview is

for the Values paste option,

which copies all the numbers

but none of the formatting.

You can move to a different

paste option and get a

different preview or click a cell in

the worksheet to banish the

preview and cancel the paste

operation.

When you copy Excel cells (as opposed to data from another program), the list

of paste options includes fourteen choices arranged into three groups. In the first

group, named Paste, you’ll find these choices:

•
Paste
. This option is the same as a normal paste operation, and it pastes both

formatting and numbers.

•
Formulas
. This option pastes only cell content—numbers, dates, and text—

without any formatting. If your source range includes any formulas, Excel also

copies the formulas.

•
Formulas and Number Formatting
. This option is the same as Formulas,

except it also copies the settings that control how numbers appear. (In other

words, numbers that have currency signs, percentage signs, or thousands

separators will remain formatted. However, you’ll lose other formatting details, like

fancy fonts, colors, and borders.)

•
Keep Source Formatting
. This option copies all the data and the formatting.

In fact, it’s the same as the ordinary Paste option, which is an unexplained

Excel quirk.

•
No Borders
. This option copies all the data and formatting (just like an

ordinary paste), except it ignores any borders that you’ve drawn around the cells.