How to change the size of cells in Excel

You can watch a video tutorial here.

Cells in Excel are, by default, a uniform size. When formatting a spreadsheet, you may need to change the size of a cell or cells so that the text is properly displayed. 

Option 1 – Use the column and row headers

Step 1 – Select the column and row lines

• Move the cursor to the line that borders the column
• When the cursor changes to a cross, either double-click or drag the line to the desired width
• Move the cursor to the line that borders the row
• When the cursor changes to a cross, either double-click or drag the line to the desired height

Step 2 – View the result

• The size of the cell increases and the text is displayed properly

Option 2 – Use the menu option

Step 1 – Select the rows

• Select the row or rows that are to be made bigger
• Right-click and select Row Height  from the context menu

Note: The Row Height option is also available on the menu Home >  Cells > Format

Step 2 – Enter the row height

• In the box, increase the height of the row
• Click OK

Step 3 – Select the columns

• Select the column or columns that are to be made bigger
• Right-click and select Column Width from the context menu

Note: The Column Width option is also available on the menu Home >  Cells > Format

Step 4 – Enter the column width

• In the box, increase the width of the column 
• Click OK 

Step 5 – View the result

• The size of the cell is increased

Option 3 – Use the Autofit option

Step 1 – Increase the column width

• Position the cursor on the column line and drag it to increase the width

Step 2 – Autofit the column

• Select the column
• From Home > Cells > Format  select Autofit Column Width

Step 3 – Autofit the row

• Select the rows
• From Home > Cells > Format  select Autofit Row Height

Step 4 – View the result

• The size of the cells is changed