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.
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.