Microsoft Office Tutorials and References
In Depth Information
Working with Columns and Rows
Figure 1-9
Customer orders for RipCity Digital
Working with Columns and Rows
Amanda has reviewed the customer order data you entered in the worksheet. She asks
you to make the data easier to read. You can do this by modifying the size of the columns
and rows in the worksheet.
Changing the Column Width or Row Height
• Drag the right border of the column heading left to decrease the column width or
right to increase the column width.
• Drag the bottom border of the row heading up to decrease the row height or down to
increase the row height.
or
• Double-click the right border of a column heading or the bottom border of a row
heading to autofit the column or row to the cell contents (or select one or more
columns or rows, click the Home tab on the Ribbon, click the Format button in the Cells
group, and then click AutoFit Column Width or AutoFit Row Height).
or
• Select one or more columns or rows.
• Click the Home tab on the Ribbon, click the Format button in the Cells group, and then
click Column Width or Row Height.
• Enter the column width or row height you want, and then click the OK button.
Setting Column Widths
The default sizes of the columns and rows in a worksheet might not always
accommodate the information you need to enter. This is what happened with the addresses
you entered in the worksheet when Excel wrapped the text in ways that made the
Search JabSto ::




Custom Search