Excel freeze pane-freeze row and column titles

Source: Internet
Author: User
Over the years of work, more and more powerful microsoftware has been found. They also began to use Excel for their own plans and various event records.
To be honest, I may not be able to use 10% of the powerful functions!
For the "Freeze pane" function, I was able to see a friend using it to lock the row title. At that time, I suddenly realized that "this function was still available !" . Because there have been a lot of lines of Excel documents, after a screen flip, if there are a lot of columns, it will really be confused what each column means. The most obvious result is in a digital report. So I am very happy to know this function.
But in the process of use, I can't lock the header? Otherwise, the lock is incorrect. How can this problem be solved? The question mark is put in my mind. Later, with multiple failures, I accidentally discovered that it was a decisive factor to click on the "Freeze pane" time mark to focus on which row and column. For example, if the first row is frozen, the cursor is not placed on the first row, but the second row is selected, and the column is the same.
Today, I need to lock both the first row and the first column. In my mind, select the second row and the second column at the same time. It turns out that I was wrong. I couldn't get it all. So I turned to the Internet and found the animation. It turned out that I wanted to lock the row and column titles, select the cells in the next and next rows of the columns to be frozen, for example, locking the first row and first column, then select the cells in the second row and second column, click "Freeze pane.

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.