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
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
Turning 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