Search results
Results from the WOW.Com Content Network
How to change the column width and row height, including how to use the AutoFit feature, in your Excel worksheet.
On the Home tab, select Format > Row Width (or Row Height). Type the row width and select OK. Select a column or a range of columns. On the Home tab, select Format > Column Width (or Column Height). Type the column width and select OK. Automatically resize all columns and rows to fit the data.
You can use the Resize command in Excel to add rows and columns to a table: Click anywhere in the table, and the Table Tools option appears. Click Design > Resize Table. Select the entire range of cells you want your table to include, starting with the upper-leftmost cell. In the example shown below, the original table covers the range A1:C5.
On the Home tab, select Format > Row Width (or Row Height). Type the row width and select OK. Select a column or a range of columns. On the Home tab, select Format > Column Width (or Column Height). Type the column width and select OK. Automatically resize all columns and rows to fit the data.
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.
In Excel, you can scale a worksheet for printing by shrinking or enlarging its size to better fit the printed pages. You can also scale a worksheet to fit the paper width of printed pages, or specify the number of pages that you want to use for the printed worksheet.
Select the cell or range for which you want to adjust the row height. On the Home tab, in the Cells group, select Format. To automatically adjust the row height, select AutoFit Row Height. To specify a row height, select Row Height, and then type the row height that you want in the Row height box.
Increase the spacing for text in a cell. If your cell has white space, and you want to increase the line space to fill it evenly, change the vertical spacing to Justify. Right-click in the cell you want, and click Format cells.
Formatting cells on your worksheet can make the right information easy to see at a glance, but formatting cells that aren't being used (especially entire rows and columns) can cause your workbook's file size to grow quickly.
To help prevent reaching an Excel limit, make sure you’re using the .xlsx format instead of the .xls format to take advantage of the much larger limit. If you know your data set exceeds the .xlsx limit, use alternative workarounds to open and view all data. Tip: Be sure to cross-check that all data was imported when you open a data set in Excel.
To use specific height and width measurements, on the Format tab, in the Size group, enter the size in the Height and Width box. To change the size and scaling of the chart, on the Format tab, in the Size group, click the Dialog Box Launcher .