Copying Excel Data into Word

Data presentation in a Word document can be done by creating a table (Alt a i t) or by copying data from Excel.  Maybe you have inserted a chart into Word and want to display the content for that chart.  You will need to have both Excel and Word open.  Set up your content in Excel.  Move to the first cell containing the content.  Let's assume that there are no blank rows or columns in your Excel content.  Press and hold down the Control and Shift keys, right arrow one or more times, then down arrow one or more times.  All of your content is highlighted.  Release the Control and Shift keys.  Press and hold down the Control key and hit the letter c to copy the Excel content.  Release the Control key.  Press and hold down the Alt key and hit the Tab key to move to Word.  Release the Control key.  Move to the area of the Word document where you want to paste the Excel content.  Press and hold down the Control key and hit the letter v to paste the Excel content into the Word document.  Once you have pasted the Excel content, hit the applications key one time.  down arrow two times to the "Paste Options" menu item.  Right arrow to the "Keep Text Only" item, and then hit the Enter key one time.  You now have two tables. with the same content, and are at the bottom of the second table.  Up arrow to the bottom of the first table.  Press and hold the Shift key and up arrow until the first table is completely highlighted.  Hit the Delete key (6-Pac bottom right key) one time and the first table will be gone, giving you a lined up table (the second table) to display your Excel content.  There is much more you can do with the Applications key and the original table, such as setting up borders for the cells.  Experiment to increase your skills.

Do the following to increase your skills.

1.  Open Word.
2.  Open Excel.
3.  Right arrow one time to cell b1.
4.  Type "January" (without the quotes).
5.  Hit the right arrow or Tab key one time to move to cell c1.
6.  Type "February" (without the quotes).
7.  Hit the right arrow or Tab key one time to move to cell d1.
8.  Type "March" (without the quotes).
9.  Shift Tab or left arrow back to cell a1.
10.  Hit Enter or down arrow one time.
11.  Type "Coke" (without the quotes).
12.  Hit Enter or down arrow one time.
13.  Type "Chips" (without the quotes).
14.  Hit Enter or down arrow one time.
15.  Type "Candy" (without the quotes).
16.  Up arrow to cell a2.
17.  Hit Tab or right arrow one time to cell b2.
18.  Type the number 20.
19.  Hit Tab or right arrow one time to cell c2.
20.  Type the number 25.
21.  Hit Tab or right arrow one time to cell d2.
22.  Type the number 23.
23.  Shift Tab or left arrow back to cell b2.
24.  Hit down arrow one time to move to cell b3.
25.  Type the number 15.
26.  Hit Tab or right arrow one time to cell c3.
27.  Type the number 18.
28.  Hit Tab or right arrow one time to cell d3.
29.  Type the number 14.
30.  Shift Tab or left arrow back to cell b3.
31.  Hit down arrow one time to move to cell b4.
32.  Type the number 35.
33.  Hit Tab or right arrow one time to cell c4.
34.  Type the number 32.
35.  Hit Tab or right arrow one time to cell d4.
36.  Press and hold down the Control key and hit the Home key to move to cell a1.
37.  Press and hold down the Shift key and hit the right arrow key the number of times it takes to highlight the top row of content.
38.  Keey the Shift key held down and down arrow to highlight all of the rows of content.
39.  Release the Shift key.
40.  Press and hold down the Control key and hit the letter c to copy the highlighted content.
41.  Release the Control key.
42.  Press and hold down the Alt key had hit the Tab key to move to your Word document.
43.  Move to the place in the document where you want to paste your Excel (table) content.
44.  Press and hold down the Control key and hit the letter v to pasted the Excel content into your Word document.
45.  Release the Control key.
46.  If you wish, immediately hit the Applications key.
47.  Down arrow two times to the "Paste Options" items.
48.  Hit right arrow to move to the "Keep Text Only" or other option you want.
49.  Hit the Enter key one time.  You are at the bottom of the second table.
50.  Hit up arrow the number of times it takes to get to the bottom of the first table.
51.  Press and hold down the Shift key and hit the up arrow key the number of times it takes to highlight the entire first table.
52.  Hit the Delete key one time and the first table will be gone.

NOTE:  This skill will take a lot of practice because you are working in multiple programs, and are having to do a lot of key commands and navigation.  Practice until you are quick and accurate.

BACK