How to Copy Excel Row Numbers Into Word

by Shawn McClain

Microsoft Office 2010 programs are designed to work together, so that you can copy a range of cells from Excel and choose from several options to paste it into another Office program, like Word. Despite all this interoperability, the row numbers and column letters will not be included when you paste the cells. To include the row numbers, you need to use an Excel feature that lets you copy the cells as they would look when printed.

Copying a Picture of Excel

Step 1

Click on the "Page Layout" tab at the top of the screen. Look for the "Sheet Options" area and place a check mark next to "Print" under "Headings." This will make the row numbers and column letters show up in a printed document.

Step 2

Select the top, left cell from the area that you want to copy. Navigate to the bottom, right cell. Hold "Shift" and select this cell, highlighting the entire range of cells.

Step 3

Click on the "Home" tab at the top of the screen. Locate the "Clipboard" area and select the drop-down arrow next to the "Copy" button. Select "Copy as Picture" from the menu, which will open up a small window.

Step 4

Select "As shown when printed" from the window. This will copy the cells as they would look if you were to print the selected area, including the row numbers and column letters.

Open the Word document to which you want to paste the Excel information. Place your cursor where you want to add the cells and press "Ctrl" + "V" to paste the information.

About the Author

Shawn McClain has spent over 15 years as a journalist covering technology, business, culture and the arts. He has published numerous articles in both national and local publications, and online at various websites. He is currently pursuing his master's degree in journalism at Clarion University.

More Articles