How do you find the rows and columns that Excel hides?

Source: Internet
Author: User

How do you find the rows and columns that Excel hides? In the daily work, we often hide some rows and columns to print the need, but the printing is done to hide the ranks of the display, frequent hidden display feeling very troublesome, then Excel hidden rows and columns How to find it? The following small series for you to introduce, to see it.


Find rows and columns that cannot be hidden. Where did they all go? such as "Swallow Primary school third grade Chinese discipline Unit Test score statistics" in the 第6-26 line.

Select a line or two lines before and after the hidden rows ... (Note that you should check both before and after.) Click the right button to set "row height" in the function key.

Then enter the same high value as the other rows, as high as the other rows, or enter the values you need to row high.

Selected as Method 1.

Move the mouse over line 27th, a cross symbol with a horizontal line and a portrait arrow appears, and then press and hold the left mouse button to gently pull. Miracles have arisen.

Let's see if the previously hidden lines are back to normal!

If you want to set the column width that has been hidden, use the same method.

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.