How do I freeze Excel table rows and columns?

Source: Internet
Author: User
Tags split

Sometimes our Excel tables have very many rows and columns of data, so when you move to the bottom of the data, the table head can not see, if the number of columns, once the right to move, the left of the serial number and see, so very inconvenient, there is no way to put the table head and serial number fixed it, of course, We can use the Excel Freeze pane feature to achieve this.

The Excel table freezes specific methods as follows:

Method One, Frozen pane method

Position the cursor on the next line of the header row (which can be one or more lines) that you want to freeze, and then select window → freeze pane in the menu bar.

In this way, when scrolling around the screen, the frozen header row or serial number is always displayed on the top or the left, greatly enhancing the visibility of table editing.

If you do not want to fix the header and serial number, you can click on the menu "Unfreeze pane" on it, home said that in some machines or Excel version of the Freeze pane will fail, then use the following method to determine is achievable, it is to split the table, you can also implement the Excel table freeze.

Method Two, table split method

Position the cursor on the next line of the header row (which can be one or more lines) that you want to freeze, and then select Window → split in the menu bar.

This can also achieve the Excel table freezing function, this is to split the Excel table into two tables, data independent, the same function also enhances the intuitive table editing.

If you do not want to fix the header and serial number, you can click "Cancel Split" on the menu to cancel the Excel form freeze.

Of course, the above two methods interface is still a little bit different, the second method has a thicker box the first method is not, but a black side, the specific difference or let you go to practice it.

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: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.