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.
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
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.
There are three options for copying.
-Choose Copy from the menu
-Right Click your selected data and choose Copy
Now that your data is copied, let’s paste it.
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
-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
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.