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

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.

Steps

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!