If you share Excel files outside of your organisation you’ll enjoy this post where I share with you how to remove Excel formulas and keep the results so that you can confidently send a file knowing you aren’t disclosing confidential information inside of your formulas.
Learn how to move, copy and paste information in Excel. Once you have mastered Cut, Copy and Paste you will find yourself shifting data around easily and reusing copied data, saving you the need to recreate the same information again.
All Windows applications have access to the Windows Clipboard. This is a special area used for moving and copying information.
The ‘Cut’ command moves a selection to the Clipboard while the ‘Copy’ command copies a selection to the Clipboard.
Continue ReadingEver 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
Without 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
Learn how to copy and paste excluding hidden columns or rows.
Ever tried to copy and paste data thinking you will be pasting, excluding the hidden columns or rows?
Copying a data range that contains hidden data can be challenging. You may have tried this and found that the hidden data travels with the copied range.
In this post I’ll explain how to copy and paste only the visible data – hidden cells are excluded.
Continue Reading
