There are several ways to change cell size. Find out how they work to decide which one best suits your needs.
How to Autofit in Excel
Format one or more columns to automatically resize to fit the data entered. Once formatted, columns and cells will automatically expand to accommodate the longest string of data entered.
How to Change the Row Height to Autofit the Contents
If you have wrapped data, a very large font, or an object in one or more cells, format the rows to automatically change height in order to autofit the cell contents.
How to Match the Width of Another Column
If you want one column to precisely match the size of another existing column, you can copy and paste the width.
How to Resize Columns or Rows Using the Mouse
Although it is not a way to autofit in Excel, you can drag a column or row to a more appropriate size for your needs. If autofit isn’t enabled, when you drag the size of a column or row, it will then remain stationery; if the data extends beyond the expanded size, it will automatically be hidden behind the next cell. You can also use this method to change the default cell size in a worksheet. Select the column or rows you want to change, then drag the boundary to change the column width or the row height.
