Where is the excel2007 freeze window?

Source: Internet
Author: User

On the web, there are a lot of problems with excel2007 freezing windows. In fact, the excel2007 freeze window should be precisely: excel2007 Freeze pane, because, use this function is can freeze a row, a column or other form of window, so that the data is not modified to achieve the purpose. Below, together to see how excel2007 freeze Windows!

Excel2007 freeze a row by freezing the window horizontally:

1, if you want to freeze a row, first need to select the line below it. The simple thing is: if we need to freeze the "A2" line now, then we have to select the "A3" line (pictured below).


2, then go to the View tab, click Freeze pane in the Window option group, and choose Freeze split panes from the following menu!


After setting the freezing window, we can see that there is a line in the "A2". (pictured below)

Excel2007 freeze a row method for vertical freezing of a window:

Excel vertical The same method of freezing, this is skipped.

excel2007 Freeze Horizontal, vertical (row, and column) methods while freezing a window:

I do not know if you have found that in the above method we cannot fix "a row and a column", either freeze a row, or freeze a column. Here's how to fix "a row and a column" at the same time.

How do we want to freeze "A2 rows" and "A1 columns" now, as in the following illustration?


1, click the mouse to select the "B3" cell, and then click the View--"Frozen pane--" Frozen split pane on it.

2, set the freezing window will appear after two black lines, which proves that the OK, the following figure.

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.