Three methods to help you quickly adjust Excel row height and column width!

In daily work, we often need to use Excel tables. If the row height and column width of the opened Excel table are not what we want, how can we adjust it to the appropriate size? The editor below has compiled three simple and quick adjustment methods for you, come and try it!

Method 1: Open the Excel table, press the [Ctrl+A] shortcut key to select all tables (or click the small gray triangle at the intersection of row numbers and column labels in the upper left corner of the table to select the entire table), move the mouse to The intersection of column labels (such as the intersection of column A and column B).

At this time, the mouse arrow changes to the left and right arrow shape as shown in the picture above. Click twice in succession to quickly adjust the column widthof all selected tables (if there is no data in the cell, double-clicking will have no effect) ); or directly hold down the left mouse button and move the mouse left or right to adjust the column widthof the selected table.

How to adjust table column width? When working with tables, adjusting column widths is a common need. PHP editor Yuzai will introduce two simple methods to adjust the table column width. Method 1: Use mouse adjustment to hover the mouse over the edge of the column title bar. When the mouse pointer changes to a left or right arrow, hold down the left mouse button and drag left or right. Drag to the desired width and release the mouse. Method 2: Use shortcut keys to adjust. Hold down the Shift key and click on the column title bar that needs to be adjusted. Just follow the above method to make adjustments.

Method 2

Select the columns that need to be adjusted (you can also select all tables with [Ctrl+A]), click [Start], continue to click [Format], and then click [Column Width] to pop upColumn WidthIn the settings window, enter thecolumn widthvalue and click [OK].

Method 2

1. Select the column whose width you want to adjust.
2. Hold down the Shift key and select the other columns whose width you want to adjust.
3. Enter the column width value in the pop-up box.
4. Click [OK].

Method 3

1. Click [Start].
2. Click [Format].
3. Click [Automatically adjust column width].

At this time, the column width will automatically adjust according to the content length, and the auto-adjusting row height will automatically adjust according to the text font size.

This adaptive adjustment method can display all the content in the cells, but the content display format is not uniform enough and the table is not beautiful.

The above is the detailed content of Three methods to help you quickly adjust Excel row height and column width!. For more information, please follow other related articles on the PHP Chinese website!