Tag Archives: paste

Excel – 5 Paste tips that will save you HEAPS of time

SharynAvatarBlog120x120Ever wondered what the most used command is in Excel?

I have. In fact a few years back I searched for the answer on Google.  I had thought that the answer would surely be ‘Undo’, especially when I think about how often I use the fabulous Ctrl + Z key combination. Amazingly I found a page (which sadly I’m unable to find now) that claimed that Undo wasn’t the most used…it was Paste, Ctrl + V. Continue reading Excel – 5 Paste tips that will save you HEAPS of time

Excel – Paste a link and Paste Special transpose your data

SharynAvatarBlog120x120Without a doubt ‘Paste Link’ is one of the best time-saving features in Excel.  Linking information from one cell to another saves you from having to update data in several places.

Another fabulous time-saving feature is ‘Paste Special Transpose’. This allows you to copy a horizontal range and paste it vertically, or vice versa. An absolute gem.

But have you ever tried to use the two together?  It isn’t easy at all.  In this post I want to share a wee work-around that will allow you to use the Paste Link and Paste Special Transpose features together. Continue reading Excel – Paste a link and Paste Special transpose your data

Excel – Paste Values shortcut in Excel

 

PVTurning formulas into values is a very common procedure to most users of Excel.  Paste Values allows you to replace a formula with the result.  For example, a cell containing the formula “=3*2” can copied and using Paste Values the formula result, i.e. “6” will be pasted into the cell, replacing the formula.

Here’s a fabulous (and very popular) tip to save you time when you paste values in Excel. Continue reading Excel – Paste Values shortcut in Excel