How to use Cut Paste in Excel to make an exact copy of a spreadsheet
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.
Advanced Excel Course – June 2013 in South Africa Our next advanced excel course is running during June 2013 in Johannesburg. During the week of the 10th June we offer the following options. You can either attend the full 5 … Continue reading
A very popular chart is the waterfall chart which shows the impact of various items on a total e.g. the various components that explain the move from budgeted profit to actual profit. A common way to build this is using … Continue reading
We have used Audit Excel/Miracle Solutions for all our Excel training requirements for the past 18 months, the assessment is a good tool to determine that the trainee is allocated to the correct training.– KRONES Lifecycle Service Center Africa