Change row height for auto fit mac excel

broken image

The current default height will be one that fits the largest font and font size used in that row.

broken image

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”.

broken image

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.