If you have multiple lines of text in a cell in your spreadsheet, then you may have noticed that Excel 2013 may not be displaying all of it.
So if you need to know how to expand all of oyur rows in Excel, you may be looking for a way to do so. Occasionally there tools with have options that specifically apply to an entire worksheet, but many only apply to the current selection. Under Default cell spacing, select the Allow spacing between cells check box, and then enter the measurement you want.Many of the formatting changes that you can use in Excel are visible on one of the tabs in the navigational ribbon. Under Default cell margins, enter the measurement you want to adjust the Top, Bottom, Left, or Right margins.
On the Layout tab, in the Alignment group, click Cell Margins, and then in the Table Options dialog box Cell spacing is between the cells, like the orange arrow on the bottom. To add space inside your table, you can adjust cell margins or cell spacing.Ĭell margins are inside the table cell, like the blue arrow on the top of the graphic. Top of Page Add or change the space inside the table ĭrag the table boundary until the table is the size you want. Rest the cursor on the table resize handle until it becomes a double-headed arrow. Rest the cursor on the table until the table resize handle appears at the lower-right corner of the table. Top of Page Resize an entire table manually If you don’t want AutoFit to automatically adjust your table or column width, you can turn it off. Note: Row height automatically adjusts to the size of the content until you manually change it. To adjust table width automatically, click AutoFit Window. To adjust column width automatically, click AutoFit Contents. On the Layout tab, in the Cell Size group, click AutoFit. Top of Page Resize a column or table automatically with AutoFitĪutomatically adjust your table or columns to fit the size of your content by using the AutoFit button. Rest the pointer over the table until the table move handle appears, and then click the table move handle.Ĭlick the column's top gridline or border. On the Layout tab, in the Cell Size group, click Distribute Columns or Distribute Rows. You can press CTRL while you select to choose several sections that are not next to each other. Select the columns or rows you want to make the same size. Top of Page Make multiple columns or rows the same size If you want to see the exact measurement of row on the ruler, hold down ALT as you drag the marker. To use the ruler, select a cell in the table, and then drag the markers on the ruler. On the Layout tab, in the Cell Size group, click in the Table Row Height box, and then specify the height you want. To set the row height to a specific measurement, click a cell in the row that you want to resize.
To use your mouse, rest the pointer on the row boundary you want to move until it becomes a resize pointer, and then drag the boundary. To change the row height, do one of the following: If you want to see the exact measurement of the column on the ruler, hold down ALT as you drag the marker. On the Layout tab, in the Cell Size group, click AutoFit, and then click AutoFit Contents. To make the columns in a table automatically fit the contents, click on your table. On the Layout tab, in the Cell Size group, click in the Table Column Width box, and then specify the options you want. To change the width to a specific measurement, click a cell in the column that you want to resize. To use your mouse, rest the cursor on right side of the column boundary you want to move until it becomes a resize cursor, and then drag the boundary until the column is the width you want. To change the column width, do one of the following: Resize a column or table automatically with AutoFit Make multiple columns or rows the same size If you need to add a table to your Word document, see Insert a table. You can change the size of multiple columns or rows and modify the space between cells. LessĪdjust the table size, column width, or row height manually or automatically. Word for Microsoft 365 Outlook for Microsoft 365 Word 2021 Outlook 2021 Word 2019 Outlook 2019 Word 2016 Outlook 2016 Word 2013 Outlook 2013 Word 2010 Word 2007 More.