4 ways to adjust row heights for Excel tables

Source: Internet
Author: User
Tags first row

I. Direct positioning method

First, add a secondary column at the end of the table. Enter the number "1" in the cell in the first row of the column, and then enter the formula "=1/0" in the cell in the second row, and get a "#DIV/0!" after the carriage return. The error message. Now select the two cells, position the mouse over the fill handle in the lower-right corner of the selection, press the right mouse button, and drag down to the last line. After you release the mouse, select Copy Cells from the shortcut menu that pops up. OK, now the odd row of the column is number 1, and even-numbered rows are "#DIV/0!." Error prompts, as shown in Figure 1.

Click menu command "edit → position", in the Open Positioning dialog box, tap the Positioning Condition button, and then in the Open Criteria dialog box, select the formula Single option, and deselect any options other than error, as shown in Figure 2. When you are sure, you will see that all the error prompt cells are selected.

All we need to do now is to click on the menu command "format → row → row height" and then set the new row height value on the Open Row Height dialog box, as shown in Figure 3. When the row height adjustment is complete, remember to delete the secondary column.

Second, the screening method

Also add a secondary column first. Then enter the number "0" in the first cell of the column, and enter "1" in the cell in the second row. Select the two cells, then press the right mouse button and drag the fill handle down and select Copy Cells from the shortcut menu that pops up.

Now click on the menu command "data → filter → AutoFilter". Click the Drop-down button in the first cell of the secondary column and select "1" in the list, as shown in Figure 4. After you click, you can filter the cells that have a value of "1".

Select the cell with all values of 1, and click the menu command "format → row → row height" to set the desired row height. Finally, do not forget, click the menu command "data → filter → AutoFilter", cancel the "AutoFilter" before the check, so that all the data normal display.

Third, the selective pasting method

By contrast, this approach is much simpler to say. Select the second row first, and adjust the line spacing to fit. Then click on the left line number, select the first row and the second line, click the "Copy" button. Then click on the left line number to select the remaining lines. Click the menu command "edit → paste" to open the Paste Selective dialog box. Click on the "format" single option, as shown in Figure 5. In this way, you can get the desired effect.

While this method is simple, it is only suitable for situations where the format of each row is exactly the same. This method is less useful if you have merged cells in a row, or if the format of the rows and rows is not exactly the same.

Four, Format brush method

If the selective pasting method can be used, then, of course, the format brush can also be used.

As above, adjust the first and second lines first, select them, and click the Format Painter button. When the mouse changes to a small brush shape, click the left line number to the desired selection. In this way, you can get the purpose of adjusting the row heights.

It should be noted that the lines should be in exactly the same format. In addition, you must click on the left line number to select the entire line of operation, otherwise, the row height is not adjusted.

All right, I've learned all these tricks. You see, is not very easy ah? The above actions are passed in Excel 2003.

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.