Home » Modifying

Tag: Modifying

woman using desktop computer

Move, Copy and Paste information in Excel

woman using desktop computer

 

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 Reading
round Timex analog clock at 2:33

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

round Timex analog clock at 2:33

Ever 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 – Copy and paste excluding hidden columns or rows

Sharyn Baines

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

Excel – Copying or moving entire worksheets between workbooks

I’ve had a number of requests to cover copying entire worksheets between files. The number one problem seems to be when the data is pasted into the new worksheet Excel doesn’t resize the column widths to fit the pasted data. Instead the columns seem to reset themselves back to the default width. Possibly the best way to avoid this happening is to use the Move and Copy command in Excel. Continue Reading