Changing the Row Height to a Specific Number
Open your project in Excel. You can open your project within Excel by clicking Open from the File tab, or you can right-click on the file in a file browser and click Open With and Excel. This method works for newer versions of Excel on either PC or Mac.
Click the row you want to change. You can click the row number to select the entire row. The row should highlight to indicate that it's selected. You can select multiple rows by dragging your mouse over each row.
Click the Home tab. You'll find this in the editing ribbon above your document.
Click Format. You'll find this in the Cells grouping with Insert and Delete. In the mobile app, tap Format Cell Size.
Click Row Height. You'll see this listed under the "Cell Size" header. A box will pop-up after you click this menu item. In the mobile app, you'll see the box to input a row height. Tap in the box to activate your keyboard.
Enter the height you want. This in in pixels, like font sizes.
Click OK. You'll see your changes applied as the pop-up box disappears.
Changing the Row Height to Automatic
Open your project in Excel. You can open your project within Excel by clicking Open from the File tab, or you can right-click on the file in a file browser and click Open With and Excel. This method works for newer versions of Excel on either PC or Mac.
Click the row you want to change. You can click the row number to select the entire row. The row should highlight to indicate that it's selected. You can select multiple rows by dragging your mouse over each row.
Click the Home tab. You'll find this in the editing ribbon above your document.
Click Format. You'll find this in the Cells grouping with Insert and Delete. In the mobile app, tap Format Cell Size.
Click AutoFit Row Height. You'll see this listed under the "Cell Size" header. In the mobile app, tap AutoFit Row Height and your cells will automatically adjust. You can also double-click a row boundary in a selected row to auto-fit the content.
Comments
0 comment