How does Excel have row and column headings when copying a table? We know the row and column headings are the default names of cells, and here we teach you how to copy a table, with the row and column headings together, the following for you to introduce a look at it!
First we open a work sample as an example.
Select the entire table and copy and paste. We can see the result without the row and column sequence.
We found the Print option in the Page Layout tab panel, and then checked the previous check box.
Select the entire worksheet and click Copy Shortcuts in the Start tab panel and choose Copy as a picture in the Drop-down menu.
In the new pop-up panel, click on the print effect, and press OK.
Select the blank area and paste it to get the results we want.
But here we see the pasted is a picture, that the table can only print, cannot be modified, and because of the font, the display effect is not good. So we have to choose the regular font.
As shown in the picture, the above image uses the Microsoft Jas, and this example uses the song body. We can try more.
In addition, if you want to print, please remove the Print check box in the page layout to avoid repeating the print sequence title.
The above is how Excel in the Copy table with row and column headings introduced, the operation is very simple, we have learned? Hope to be helpful to everyone!