How to Modifying Columns, Rows and Cells in Excel?


By default, every column, row and cell is set to be fixed height and width. Excel allows users to modify these items, including increasing or decreeing of height, width and merging cells etc.

To change column width
1. Position the mouse over the column line in the column heading to the white cross becomes a double arrow.

2. Click, hold, and drag the mouse to increase or decrease the column width

3. Remember If you see a pound or hash signs (#######) in a cell, it means that the column is not enough to display the cell text content. To solve this error simply increase the column width to show the cell content