spreadsheets

Resizing Columns or Rows

You can improve the display of the data in a spreadsheet by increasing or decreasing the width of a column or the height of a row.

To change a column's width, in the gray bar at the top of the spreadsheet where the letters of the columns are displayed, move your mouse cursor to the border between any two columns.

Your mouse cursor will change from a hand icon to a vertical bar with a right-pointing arrow.

Click, hold down your mouse button and drag the bar to the right to increase the width of a column, or to the left to decrease the width of a column.

Similarly, to change a row's height, in the gray bar at the far left of the spreadsheet where the numbers of the rows are displayed, move your mouse cursor to the border between any two rows.

Your mouse cursor will change from a hand icon to a horizontal bar with a upward-pointing arrow.

Click, hold down your mouse button and drag the bar down to increase the height of a row, or up to decrease the height of a row.

Note for Excel:  if you narrow the width of a column displaying a number too much, you will see a series of pound signs displayed in the cell:

###

This doesn't mean you've lost any data - you just made the column width too narrow to fit some of the numbers in the cells in that column.

To fix this, in the gray bar at the top of the spreadsheet just drag the right vertical border of that column to the right to increase the width enough to display all the contents of each cell. The pound signs will disappear and be replaced by the original data in the cells.

Note for Excel: You can speed up the resizing of columns and avoid making them too narrow by moving your mouse cursor to the border separating two columns in the gray bar at the top and double-clicking on the border.

This will automatically resize the column to the left, making it just wide enough to fit the longest entry on any row in that column.