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.
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
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
• 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.