In Excel column width can be modified, as can row height and width in Excel. Learn to modify Excel cells in this free Excel 2010 lesson.
When inserting new rows, columns, or cells, you will see the Insert Options button by the inserted cells. This button allows you to choose how Excel formats them. By default, Excel formats inserted rows with the same formatting as the cells in the row above them. To access more options, hover your mouse over the Insert Options button and click the drop-down arrow that appears.
By default, Excel formats inserted columns with the same formatting as the column to the left of them. To access more options, hover your mouse over the Insert Options button and click the drop-down arrow that appears.
When inserting rows and columns, make sure to select the row or column by clicking its heading so all of the cells in that row or column are selected. If you select just a cell in the row or column, only a new cell will be inserted.