facebook

Articles

Copying & Pasting

There's more to it than just copy (Edit/Copy or ctrl C) & paste (Edit/Paste or ctrl V). You can copy and control exactly what you want to paste. Example you need to copy a total (where you used a formula) and when you pasted it get an error because of the formula. What you need to do is perform the copy (as normal), select your destination and Paste Special (click Edit/Paste Special) a dialogue box will appear, select the option Values and the value of the total will be pasted instead of the formula. Just like magic.

Likewise sometimes we just need to copy the formats (example just the borders), select the range, perform the copy as normal, select your destination and Paste Special (click Edit/Paste Special) a dialogue box will appear, select the option Formats and presto! Just the formats without the contents.