Home » Excel » Basics » Copy, Paste, and Move Data

Copy, Paste, and Move Data

Navigate

As we continue to lay a baseline for working with your data, we will now cover how you can start manipulating it to make the data work for you.

Autofit

Before we start moving things around, let’s make sure we can see all of the data we are working with.
The names in column B below are being cut off by column C because column B is not wide enough to display all of the information in it. To fix this, we will Autofit all of our columns which will change their size to the max width of the data; in this case, Bookerson,Greg.

Click the “Select All” button (Ctrl+A)
Double left click in between any column letter. I prefer A and B
autofit


Copy and Paste

Knowing how to copy and paste data is integral to anyone using excel as it allows you to easily transfer information between your worksheets and workbooks, and also to other programs on your computer.

Copy

There are three options for copying.
-Choose Copy from the menu
-Right Click your selected data and choose Copy
-Press Ctrl+C

Now that your data is copied, let’s paste it.

Paste

Pasting can be a bit more complicated depending on the types of data you are working with. Data stored as Numbers or Text can change depending on how and where you are pasting, but let’s hold on that discussion for another time.

For now, paste the data

There are four options for pasting.
-Choose Paste from the menu
-Press Ctrl+V
-Right Click where you want to paste and choose the Paste option
-Right Click where you want to paste and choose the Paste Special

Once you have pasted the data, you may notice that it did not keep certain attributes such as the column widths we had from our Autofit. You can repeat the Select All process we did earlier to fix this, or you can:
-Right Click where you just pasted
-Choose Paste Special
-Choose Column Widths
This while copy and paste over the same column widths from your copied data

pasteautofit


Moving data

Pretty short and sweet, but just be careful when you are moving data around, especially if the data is in a template that has formulas, pivots, and other functions tied to it.

Quick example below shows how moving the data can adversely affect a template.

Note how my yellow highlighted cell is summing the Hours in Range E3 through E10. Moving some of my data around changes that formula result.
moving data


1 Comment

  1. Sums says:

    […] the previous post we showed how moving data around can impact a sum formula. Below we will go over what a Sum is and […]

Leave a Reply

%d bloggers like this: