Microsoft Excel 2007: Moving Data with Cut, Copy and Paste (Part 3)
Explore “Moving Data with Cut, Copy and Paste” in this Microsoft Excel 2007 lesson. Part 3 of the five-part series brings together the source material and lesson topics. Use the contents links to find a section, read the notes, and consult the complete original teaching slides below.
Lesson topics
- Please note that all the information in the rows below the new row has shifted down a row.
- To delete a row, select it, then right click on “Delete.”
- HELPFUL HINT: Use the “Undo” button to undo actions you’ve done and want to undo
- Data can be moved around or copied by using Cut, Copy, and Paste.
- Cut, Copy, and Paste
Contents
- Read the original document
- To insert a NEW row, highlight the row that you wish to place the new row on top of, then click “Insert”
- Please note that all the information in the rows below the new row has shifted down a row.
- To delete a row, select it, then right click on “Delete.”
- Highlight cells A5 through C7, right click and select “Clear Contents” to clear the data we added.
- HELPFUL HINT: Use the “Undo” button to undo actions you’ve done and want to undo
- Data can be moved around or copied by using Cut, Copy, and Paste.
- Cut, Copy, and Paste
- Go to Sheet 2, then fill in the following Information.
- Select the data to be moved and click on “Cut.”
- Place the cursor in the cell or cells you want the data to be placed in (A7) and click on “Paste.”
- The data is deleted from the original location and is pasted in the new location.
- Now try to cut and paste again replacing the info in the original spot.
- Using “Copy” and “Paste” does not delete the data from the original location, but instead keeps the origi
- Select the data from before (A7-C10) and click on “Copy.”
- Put the cursor where you want the data to be copied, cell A1 and click “Paste.”
- ** Clearing contents will not clear the cell format.
- Using Autofill
- Using AutoFill can save work by copying data or repeating patterns.
- Go back to the Worksheet we named “Practice”
- Fill in the following data into cells A2-B6. Then highlight cells A2-B6.
- The “Fill Handle” is the square in the lower right corner.
- Type the word “Fishers” in cell E2 under “City” heading.
- Click on the “Fill Handle” in the cell and drag it down to E6. The Autofill feature fills in city as “Fis
- Excel can recognize some common patterns when using Autofill. Try typing “January” in A1 and auto fill un
- Try typing “Almonds” in A1 and Apples in B1. Now highlight these 2 cells, then grab the autofill handle a
- If Autofill doesn’t recognize a common pattern, then it will copy the original data.
- Try typing the numbers “5” and “10” in cells A1 and B1.
- Highlight cells A1-B1 then drag the Autofill Handle across. The autofill will continue on a +5 pattern. P
- In Cell A10, Type Sunday, and try to use Autofill feature to fill out the rest of the days of the week.
- Examples of Recognized Autofill
- Now take a minute and try to autofill on your own.
- Formatting
- Data formatting is done in a similar manner to Microsoft Word.
- Click on the “Font Color” icon to change the color.
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
Read the original source document
Microsoft Excel – Presentation 01: original teaching slides for this study series.
To insert a NEW row, highlight the row that you wish to place the new row on top of, then click “Insert”
To insert a NEW row, highlight the row that you wish to place the new row on top of, then click “Insert” then choose “Insert Sheet Rows”
Please note that all the information in the rows below the new row has shifted down a row.
Please note that all the information in the rows below the new row has shifted down a row.
To delete a row, select it, then right click on “Delete.”
To delete a row, select it, then right click on “Delete.”
Highlight cells A5 through C7, right click and select “Clear Contents” to clear the data we added.
Highlight cells A5 through C7, right click and select “Clear Contents” to clear the data we added.
HELPFUL HINT: Use the “Undo” button to undo actions you’ve done and want to undo
HELPFUL HINT: Use the “Undo” button to undo actions you’ve done and want to undo
Data can be moved around or copied by using Cut, Copy, and Paste.
Data can be moved around or copied by using Cut, Copy, and Paste.
Cut, Copy, and Paste
Cut, Copy, and Paste Ctrl + X Ctrl + C Ctrl + V Format Painter (will discuss later)
Go to Sheet 2, then fill in the following Information.
Go to Sheet 2, then fill in the following Information. (A1) Lastname (B1) Hickerson (C1) VanNoy (A2) Firstname (B2) Andrew (C2) Julie (A3) City (B3) Indpls (C3) Fishers (A4) State (B4) Indiana (C4) Indiana
Select the data to be moved and click on “Cut.”
Select the data to be moved and click on “Cut.”
Place the cursor in the cell or cells you want the data to be placed in (A7) and click on “Paste.”
Place the cursor in the cell or cells you want the data to be placed in (A7) and click on “Paste.”
The data is deleted from the original location and is pasted in the new location.
The data is deleted from the original location and is pasted in the new location.
Now try to cut and paste again replacing the info in the original spot.
Now try to cut and paste again replacing the info in the original spot.
Using “Copy” and “Paste” does not delete the data from the original location, but instead keeps the origi
Using “Copy” and “Paste” does not delete the data from the original location, but instead keeps the original and the replica.
Select the data from before (A7-C10) and click on “Copy.”
Select the data from before (A7-C10) and click on “Copy.”
Put the cursor where you want the data to be copied, cell A1 and click “Paste.”
Put the cursor where you want the data to be copied, cell A1 and click “Paste.”
** Clearing contents will not clear the cell format.
Select the cells we were working with (A4-C16), right click and select “Clear Contents”. This action clears all data out of the highlighted cells. Clearing contents will not clear the cell format.
Using Autofill
Using Autofill
Using AutoFill can save work by copying data or repeating patterns.
Using AutoFill can save work by copying data or repeating patterns.
Go back to the Worksheet we named “Practice”
Go back to the Worksheet we named “Practice”
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
Fill in the following data into cells A2-B6. Then highlight cells A2-B6.
Fill in the following data into cells A2-B6. Then highlight cells A2-B6.
The “Fill Handle” is the square in the lower right corner.
The “Fill Handle” is the square in the lower right corner.
Type the word “Fishers” in cell E2 under “City” heading.
Type the word “Fishers” in cell E2 under “City” heading.
Click on the “Fill Handle” in the cell and drag it down to E6. The Autofill feature fills in city as “Fis
Click on the “Fill Handle” in the cell and drag it down to E6. The Autofill feature fills in city as “Fishers” for all those cells you selected.
Excel can recognize some common patterns when using Autofill. Try typing “January” in A1 and auto fill un
Excel can recognize some common patterns when using Autofill. Try typing “January” in A1 and auto fill until you reach K1.
Try typing “Almonds” in A1 and Apples in B1. Now highlight these 2 cells, then grab the autofill handle a
Try typing “Almonds” in A1 and Apples in B1. Now highlight these 2 cells, then grab the autofill handle and drag across row 1 until you reach L1.
If Autofill doesn’t recognize a common pattern, then it will copy the original data.
If Autofill doesn’t recognize a common pattern, then it will copy the original data.
Try typing the numbers “5” and “10” in cells A1 and B1.
Try typing the numbers “5” and “10” in cells A1 and B1.
Highlight cells A1-B1 then drag the Autofill Handle across. The autofill will continue on a +5 pattern. P
Highlight cells A1-B1 then drag the Autofill Handle across. The autofill will continue on a +5 pattern. Please note – Autofill requires at least two cells to detect a numerical pattern.
In Cell A10, Type Sunday, and try to use Autofill feature to fill out the rest of the days of the week.
In Cell A10, Type Sunday, and try to use Autofill feature to fill out the rest of the days of the week.
Examples of Recognized Autofill
Examples of Recognized Autofill
Now take a minute and try to autofill on your own.
Now take a minute and try to autofill on your own. Any Questions?
Formatting
Formatting.
Data formatting is done in a similar manner to Microsoft Word.
Data formatting is done in a similar manner to Microsoft Word.
Click on the “Font Color” icon to change the color.
Click on the “Font Color” icon to change the color.
Review questions and answers
What are the key points about To insert a NEW row, highlight the row that you wish to place the new row on top of, then click “Insert” ?
To insert a NEW row, highlight the row that you wish to place the new row on top of, then click “Insert” then choose “Insert Sheet Rows”
What are the key points about Please note that all the information in the rows below the new row has shifted down a row.?
Please note that all the information in the rows below the new row has shifted down a row.
What are the key points about Highlight cells A5 through C7, right click and select “Clear Contents” to clear the data we added.?
Highlight cells A5 through C7, right click and select “Clear Contents” to clear the data we added.
What are the key points about HELPFUL HINT: Use the “Undo” button to undo actions you’ve done and want to undo?
HELPFUL HINT: Use the “Undo” button to undo actions you’ve done and want to undo
What are the key points about Data can be moved around or copied by using Cut, Copy, and Paste.?
Data can be moved around or copied by using Cut, Copy, and Paste.
More lessons from this document
- Microsoft Excel – Presentation 01 — Part 1
- Microsoft Excel – Presentation 01 — Part 2
- Microsoft Excel – Presentation 01 — Part 3
- Microsoft Excel – Presentation 01 — Part 4
- Microsoft Excel – Presentation 01 — Part 5
Conclusion
The important points in Data can be moved around or copied by using Cut, Copy, and Paste. should be reviewed alongside the definitions, examples and comparisons given above. Continue with the other four articles to cover the rest of the source material.