6. What
Do You See? Paste Special
lets you choose what you want to paste. The
default options include: All (everything), Formulas, Values, Formats,
Comments, or Validation, only. Options
to Remove
Formatting Paste
Special can get rid of Formats, Themes, Borders or blanks you may have
copied from the original sheet. Options
to Select
Operation You can
select the math you want to paste: Add, Subtract, Multiply, Divide,
or none at all. Keep
going...
Home->Paste ->Paste Special ->Values
The Computer Mama sez:
This can save you a lot of
time!
Exam 77-882: Microsoft Excel 2010
Core
2. Creating Cell Data
2.1. Construct cell data: Paste
Special |
|
| |
