How do I set the row height and column width in an Excel spreadsheet?

Source: Internet
Author: User

How do I set the row height and column width in an Excel spreadsheet? Making tables is the most basic and common thing to do when working with Excel spreadsheets, but for starters, how to set row heights and column widths, and sometimes even hop or skip columns. The following small series for everyone to introduce the details, to see it.


In the process of making the table, it is necessary to adjust the row height and the column width, the general beginners will choose to pull directly. In fact, the direct field can be, but sometimes not very normative.

Select the line you want to set, click on the title bar "5" on the right button will pop-up toolbar, click "Row height" enter.

Enter the corresponding number in the Row Height Tool dialog box, and if the input number is too large or too small, you can repeat it to the standard.

Sometimes it takes a few lines to set the same row height, then move the mouse to the first line, such as "3" line, pull down to the last line, such as "7" line, click Right to set row height.

Does that require hop (interlaced) to be set uniformly? Click the first line, such as "3" line, hold down the CTRL key, click the line you want to set, such as "5", "7" line, and so on. Click on the selected line right click on the settings can be.

can also be directly from the "3" line to the "9" line, click the right button settings.

You can also click on the first line, such as "3" line, hold down the SHIFT key, and then click the last line, such as "9" can be.

Sets the column width and row height method the same.

The above is the Excel spreadsheet in the row height and column width how to set up the method introduction, the operation is very simple, everybody has learned? Hope this article can be helpful to everybody!

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.