Skip to main content

How to Copy and Paste in Excel

 - From the previous section, you now have a spreadsheet that looks like this:
A Merged Heading in cell A11
If we're eating that many chocolate bars in one week, we'd like to know how much this habit is costing us! And what about the yearly cost of the addiction? Excel makes sums like this quite easy to calculate. First let's have some new headings.

Copy and Paste

To create your new headings, do this:
  • Locate cell A13 on your spreadsheet and click on it
  • Type Cost of Addiction
  • Merge the cells, in the same way you learned previously
  • Add a bit of formatting to the text, if you like
We're going to be needing the names of the chocolate bars again. These will go in cells A15 to A18. Instead of typing them all out by hand, Excel 2007 and Excel 2010 make it easy to copy and paste the names. Try this:
  • Highlight the cells A4, A5, A6 and A7
  • Locate the Clipboard panel in the Ribbon at the top of the page (on the Home menu)
  • From the Clipboard panel, click Copy
The Clipboard Panel in Excel 2007
You'll see some moving lines surrounding your highlighted cells - the so-called marching ants!
The Marching Ants
  • Once you see the marching ants, click into cell A15
  • To paste the copied text over, simply press the Enter key on your keyboard
  • You spreadsheet should now look something like ours below:
The text has been copied over
We need some new headings on the spreadsheet. Under these headings will be the price of each chocolate bar, how many of a particular chocolate bar we're eating each week, and how much this is costing us each week. So, do the following:
  • In cell B14 enter the word Price
  • In cell C14 enter the word Number
  • In cell D14 enter the word Cost
Your spreadsheet should now look like this:
New labels added
We're going to put the price of each chocolate bar in cells B15, B16, B17 and B18. We'll have the following for the prices:
Mars Bars £0.35
Twix £0.29
Bounty £0.32
Others £0.40
So go ahead and enter those prices in cells B15, B16, B17 and B18 of your spreadsheet. (You can have your own currency symbol, instead of the UK pound.)
When you're finished, your spreadsheet should look like this one.
Prices in the B column


For the Number column, we'll use a different form of Paste called Paste Special. You'll see how that works in the next part of this Excel tutorial.
Labels:

Comments

Post a Comment

Popular posts from this blog

Beginners PHP  -This is a complete and free PHP programming course for beginners. It's assumed that you already have some HTML skills. But you don't need to be a guru, by any means. If you need a refresher on HTML, then click the link for the Web Design course on the left of this page. Everything you need to get started with this PHP course is set out in section one below. Good luck! Home Page > PHP Section One - An Introduction to PHP 1. What is PHP and Why do I need it? 2. What you need to get started 3. Installing and testing Wampserver 4. Troubleshooting > PHP Two - Getting Started With Variables 1. What is a Variable? 2. Putting text into variables 3. Variables - some practice 4. More variable practice 5. Joining direct text and variable data 6. Adding up in PHP 7. Subtraction 8. Multiplication 9. Division 10. Floating point numbers > PHP Three - Conditional Logic 1. If Statements 2. Using If Statements 3....
Post a Comment
Read more
Visual Basic .NET Contents Page   -This computer course is an introduction to Visual Basic.NET programming for beginners. This course assumes that you have no programming experience whatsoever. It's a lot easier than you think, and can be a very rewarding hobby! You don't need to buy any software for this course! You can use the new FREE Visual Basic Express Edition from Microsoft. To see which version you need, click below: Getting the free Visual Studio Express - Which version do I need? > VB .NET One - Getting Started   1. Getting started with VB.NET 2. Visual Basic .NET Forms 3. Adding Controls using the Toolbox Home Page 4. Adding a Textbox to the Form 5. Visual Basic .NET and Properties 6. The Text Property 7. Adding a splash of colour 8. Saving your work 9. Create a New Project >   VB .NET Two - Write your first .NET code   1. What is a Variable? 2. Add a coding button to the Form 3. Writing y...
Post a Comment
Read more
The Excel SumIF Function  - Another useful Excel function is SumIF. This function is like CountIf, except it adds one more argument: SUMIF( range ,  criteria ,  sum_range ) Range and criteria are the same as with  CountIF  - the range of cells to search, and what you want Excel to look for. The Sum_Range is like range, but it searches a new range of cells. To clarify all that, here's what we'll use SumIF for. (Start a new spreadsheet for this.) Five people have ordered goods from us. Some have paid us, but some haven't. The five people are Elisa, Kelly, Steven, Euan, and Holly. We'll use SumIF to calculate how much in total has been paid to us, and how much is still owed. So in Column A, enter the names: In Column B enter how much each person owes: In Column C, enter TRUE or FALSE values. TRUE means they have paid up, and FALSE means they haven't: Add two more labels: Total Paid, and Still Owed. Your spreadsheet should look something li...
Post a Comment
Read more