Quickly adjust the most appropriate row heights and column widths for Excel

Source: Internet
Author: User
Tags first row

When we are sorting the Excel document table, we often encounter too much text in the cell causing the content to be incomplete, or if the text is too small to cause extra whitespace, we need to adjust the row height or the column width to the appropriate size. But if it all depends on manual adjustment, it is also more troublesome. Is there any easier and quicker way? Of course, and it's available in both Excel2003 and 2007 versions. Here's an example.

Quickly adjust to the most appropriate column width

For example, column A is too wide and needs to be adjusted. We move the mouse between columns A and B, and when the mouse pointer changes to a double-headed arrow (the Red box section below), double-click the left mouse button and column A adjusts to the most appropriate column width immediately.

If you have more than one column to adjust, we can select the cells that need to be adjusted, select the menu "format-column-Most appropriate column width" To complete the column width adjustment of multiple cells.

Computer Tutorials

Quickly adjust to the most suitable row height

Similar to the previous approach, such as the first row is too small, move the mouse to the first to second row, when the mouse pointer into a double-headed arrow, double-click the left mouse button, the first row immediately adjust to the most appropriate row height.

If you have more than one line to adjust, we can select the cells that need to be adjusted, select the menu "format-row-most appropriate row height" to complete the column width adjustment of multiple cells.

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.