Search results
Results From The WOW.Com Content Network
You can manually adjust the column width or row height or automatically resize columns and rows to fit the data. Note: The boundary is the line between cells, columns, and rows. If a column is too narrow to display the data, you will see ### in the cell.
If you find yourself needing to expand or reduce Excel row widths and column heights, there are several ways to adjust them. If you're working in Page Layout view ( View > Workbook Views > Page Layout ), you can specify a column width or row height in inches, centimeters and millimeters.
You can manually adjust the column width or row height or automatically resize columns and rows to fit the data. Note: The boundary is the line between cells, columns, and rows. If a column is too narrow to display the data, you will see ### in the cell.
Change the row height. To change the height of a single row, drag the boundary below the row heading until the row is the height you want. To decrease the height, drag the bottom boundary up.
To set the row height to a specific measurement, select a cell in the row that you want to resize. On the Layout tab, in the Cell Size group, click in the Table Row Height box, and then specify the height you want.
Change the row height to fit the contents. Double-click the separator. Change the row height to any size. Drag the separator until the row is the height that you want.
To change the height, do one of the following: To make all rows in the table the same height, select Layout > Distribute Rows. To make all the columns in the table the same height, select Layout > Distribute Columns. Note: In Excel, select Home > Format, and then select Row Height.
Adjust the row height to make all wrapped text visible. Select the cell or range for which you want to adjust the row height. On the Home tab, in the Cells group, select Format. Under Cell Size, do one of the following: To automatically adjust the row height, select AutoFit Row Height.
Although Excel offers no direct control for line spacing within a cell, you can use several text alignment strategies to adjust white space or make the text more readable. You can also add a text box, which offers more control.
Follow these steps: Click the Page Layout tab on the ribbon. In the Scale to Fit group, in the Width box, select 1 page, and in the Height box, select Automatic. Columns will now appear on one page, but the rows may extend to more than one page. To print your worksheet on a single page, choose 1 page in the Height box.