How does Excel have row and column headings when copying a table?

Source: Internet
Author: User

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!

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.