There is also an option to autofit the width of selected columns, but it works slightly differently. The row height changes to fit the largest font and font size used in that row. To automatically fit one row, you can move the mouse over the bottom border of the desired row heading until it turns into a bar with a double (up and down) arrow, just like when you dragged the border to change the row height. To automatically fit the row height, select the rows you want to resize to their default height, make sure the Home tab is active, click “Format” in the Cells section, and then select “AutoFit Row Height” from the Cell Size drop-down menu. In other words, the row height of the selected row will be changed to automatically fit the contents of that row. The current default height will be one that fits the largest font and font size used in that row. You can change the row height back to the default height, but it many not necessarily be the standard default height. Here’s what our worksheet looks like with the height of the first three rows and the width of the first three columns changed. Then, press Shift+F10 and select “Column Width” from the popup menu.Įnter an exact width for the selected columns on the Column Width dialog box and click “OK”. Select the columns using the column headings, just like you did for the rows, but drag left or right to select multiple contiguous rows.
You can specify an exact width for one or more columns the same way. NOTE: You should note what the default, or original, values for row height and column width are before changing them, in case you want to revert back to those values. Select “Row Height” from the popup menu.Įnter a new value for the row height for the selected rows on the Row Height dialog box and click “OK”. If the rows you want to select are not contiguous, click the first row heading and then press Ctrl and click on the headings for the other rows you want to select, just like you do to select multiple files in File (or Windows) Explorer.Įither right-click on any selected row or press Shift+F10 on your keyboard.
To select more than one row, click on the first row heading you want to select and drag up or down to select contiguous rows.
0 kommentar(er)
