How to use Cut Paste in Excel to make an exact copy of a spreadsheet.
- For updated video clips in structured Excel courses with practical example files, have a look at our MS Excel online training courses . You can even try the Free MS Excel tips and tricks course.
- To see if this video matches your skill level (see the suggested skill score below) do our free MS Excel skills assessment.
- If you are based in South Africa look at the live courses we offer in Johannesburg and Cape Town.
Cut Paste to make an exact copy in Excel
The cut paste in Excel is a very useful tool to create exact copies of sections. But first let me explain the problem.
Here we’ve got a product A section – you’ll see we’ve set it up. We’ve got some nice calculations, etc and my temptation will be to take this, copy it and just to paste it here. As shown in other video clips, the problem is, depending on how you did the formula, you’ll see the dollar signs mean that we think we wanted the formulas to look within themselves but because of the dollar sign it is looking at product A. I’m just deleting this. We can make use of cut and paste to avoid this. First what you need to do is just create a new sheet – a new spreadsheet. I’m just going to open a new spreadsheet – so I’ve got this blank spreadsheet. Now this is key – what I am going to do is I am going to take this section and instead of copying it, I’m actually going to cut it. I’m going to cut it and put it anywhere in the blank spreadsheet. So now we’ve got it sitting there. Come back to the original spreadsheet – I’ve removed it from Product A. The key here is I’m going to now close down this spreadsheet but very important I’m not going to save it – no saving. Close it down. Then immediately just open it up again – you’ll see because we didn’t save it, Product A is still sitting there and go back to the new sheet – again I will cut it, come back to the original spreadsheet, put it in the right place and I paste it. And now what you’ll see is that whereas previously this formula looked up here because it was a copy and paste. Using cut and paste we have now kept the integrity of that whole block and in a fairly simple way we have safely made an exact copy of this section.