Excel 2010


Modifying Columns, Rows, and Cells
Working with columns, rows, and cells
By default, every row and column of a new workbook is always set to the same height and width. Excel allows you to modify column width and row height in many different ways.
To modify column width:
- Position your mouse over the column line in the column heading so the white cross
becomes a double arrow
.
Positioning mouse over the column line
- Click and drag the column to the right to increase the column width or to the left to decrease the column width.
Increasing the column width
- Release the mouse. The column width will be changed in your spreadsheet.
Increased column width
If you see pound signs (#######) in a cell, it means that the column is not wide enough to display the cell content. Simply increase the column width to show the cell content.
To set column width with a specific measurement:
- Select the columns you want to modify.
- Click the Format command on the Home tab. The format drop-down menu appears.
- Select Column Width.
Increasing the column width
- The Column Width dialog box appears. Enter a specific measurement.
Increasing column width to 258 pixels
- Click OK. The width of each selected column will be changed in your worksheet.
Select AutoFit Column Width from the format drop-down menu, and Excel will automatically adjust each selected column so all of the text will fit.