How to set the Excel row height

Source: Internet
Author: User

First open Excel, all the forms are uniform width and height, which for our various data entry, I am afraid it does not look so beautiful, so we need to adjust the size of the cell width. Take the first horizontal cell, we want to make it a little taller.

Let's put the mouse pointer over the middle line between 1 and 2, allowing the mouse to turn into a cross. This turns the mouse into a state that can be dragged up and down.

Dragging this middle line down, you want to let it get a lot of distance, until you reach the desired height, release the mouse, so that an entire row of cell height to achieve the same height you need.

If you want to set a whole column of cells to the same height, use the left mouse button to select the left side of the number bar, drag down. Select the cells you want to change the format to.

Likewise, drag the middle line between the two cells with the mouse pointer and drag to the desired size, releasing the mouse. At this point, the cells you select are the same size.


Changes the width and height of the cell so that it not only facilitates the aesthetic setting of the entire document, but also facilitates the operation of related tables.

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.