The best way to freeze the first row and the first column in Excel

Source: Internet
Author: User
Tags split first row

Step one: In Excel, click to select the B2 pane, perform the window → split command (Figure 1), and then the effect shown in Figure 2 shows that the window split was unsuccessful if the effect shown in Figure 2 does not appear.

Step Two: Click to select the A1 cell in the upper-left corner and perform the window → Freeze panes command (Figure 3).

This is the perfect time to freeze the first row, the first column effect (Figure 4). For some more data tables, the need for a fixed header or the first column, frozen after the view is much more convenient. Have you met the Xiuxiu teacher's problem yet? Don't hurry to learn the trick.

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.