How to Copy Excel Row Numbers Into Wordby 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
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.
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.
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.
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.