This also only works on columns that are not completely empty.īecause the default row height is affected by the font and font size assigned to the cells in each row, you cannot specify a value for the default row height. The column width changes to fit the widest cell contents in that column. You can also automatically change the width of a column to fit the widest contents in that column by moving the mouse over the border on the desired column heading until it turns into a bar with an double (left and right) arrow, just like when you dragged the border to change the column width. Otherwise, if all the cells in the column are empty, the size of that column will not be affected. When you select one or more columns and then select “AutoFit Column Width” from the “Cell Size” menu in the Cells section of the Home tab, a selected column will only change size if there is content in any cell in that column. The AutoFit Row Height options automatically changes the row height to fit the largest font and font size whether or not there is any content in any cells in that row. 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)
