Often, you may find that you can use the same elements from a previous worksheet again, whether on the same worksheet, another worksheet, in another workbook, or even in another Office document. In this video, learn how to cut, copy, and paste your data e
- [Instructor] When you add headings, formatting, and data to a worksheet, you'll often find that you can use those same elements again, whether on the same worksheet, another worksheet, or even in another workbook. In this movie I will show you how to cut, copy, and paste your data effectively. My sample file is the CopyPaste workbook, and you can find it in the chapter three folder of your exercise files collection. This workbook contains monthly revenue data for the years 2013 through 2018. And let's say that I want to do some copying and pasting to move things around.
I can start by noticing that the year subheader in cell H2 is out place, it looks like it would be much more effective in cell I3, above the second instance of calendar year 2014. If I want to cut the value from H2 and remove it and place it in I3, then I can select H2 and then press Command + X, which will cut the cell's contents. I could've also clicked the Cut button on the Home tab of the ribbon.
Then I'll click my destination cell, I3. Press Command + V to paste, I could have also clicked the Paste button on the Home tab, and the value is pasted over. Now let's say that I want to copy a value from one cell to another, for example, monthly revenue, if I want to copy that over to cell I1. For my copy, I can click cell A1 and then press Command + C, which is for copy. I could have also clicked the Copy button on the Home tab.
Then I'll click cell I1, press Command + V to paste, and there it is. The problem, of course, is that the values in the area over on the right side in columns I and J aren't exactly monthly. So what I'd like to do is to instead copy over just the word Revenue with the existing formatting. So with I1 selected, I will press Delete to delete its contents, and then I will go back to cell A1. And then on the Formula tab, I will copy the word Revenue.
Press Command + C, press Escape to stop editing cell A1, which is what I was doing, then click cell I1. Press Command + V to paste, and I just get the word Revenue, which is all I wanted. If I want to copy multiple cells, I can just select them. So for example, for calendar year 2014, if I want to copy this entire column here, I can select cells C5 through C16. I won't include the total, in this case. Then I'll press Command + C to copy.
Click cell I5, press Command + V and there are the values. And notice, also, that the format was copied over with them. One last thing I'll show you is in cell J5. So I click that cell and you notice that, instead of just a value, in fact, there's a formula, and that is equal to G17, which is the total for calendar year 2018, you can see it here. If I want to replace the formula with the value generated by the formula, then I can click cell J5, which for me is already selected, press Command + C.
And then on the Home tab of the ribbon, I will go to the Paste button and click its down arrow. And under Paste Values, I will just click Paste Values. I could also do Value & Number Formatting or Value & Source Formatting. In this case, I can just do Paste Values. And you notice that, instead of having the formula on the Formula bar, we now have the value. There's also a Paste Options action button to the right. If I click that, and this appears after any paste action, you'll see that I can do Values Only, Values and Number Formatting, or Values and Source Formatting.
So if I had forgotten to select Values Only, I could've done so here. The techniques I've shown you in this movie will help you avoid entering the same data and formatting more than once. After you enter the elements you want in your worksheet, you can cut or copy them and use them again in Excel or wherever else you like.
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks
Skill Level Beginner
What you should know1m 11s
1. Getting Started with Excel
2. Managing Workbooks
3. Working with Worksheets, Cells, and Cell Data
4. Sorting, Filtering, and Managing Worksheets
5. Summarizing Data Using Formulas and Functions
6. Formatting Worksheet Elements
7. Working with Charts
8. Working with External Data and Objects
9. Exploring PivotTables
10. Reviewing and Sharing Spreadsheets
Further information1m 2s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.