How to adjust cell size in Microsoft Excel

Cell size adjustment is an essential aspect of working with Excel. When creating a spreadsheet, adjusting the size of cells allows you to fit more information into a single cell, making your spreadsheet more organized and visually appealing. Adjusting cell size can be crucial when printing spreadsheets. If cells are too large or too small, it can make it difficult to print the spreadsheet correctly. By adjusting cell size before printing, you can ensure that your data is presented clearly and professionally.

In this tutorial we will learn how to adjust cell size in Microsoft Excel.Proper cell size adjustment can make your data easier to read and understand, as well as enhance the overall layout of your spreadsheet. Excel allows you to adjust cell size by manually dragging the boundary lines of a cell, or by using the “AutoFit” feature to automatically adjust cell size based on the content within the cell. To adjust the size of the cell we need to adjust the column width and the row height.

At present, our data set displays name text strings that appear cramped and don’t fit within their respective cells. To enhance the visual appeal of the spreadsheet, we plan to adjust the cell width and height to accommodate the entire text string.

Method 1 : Adjust Cell Size by Manually Dragging the Boundary Lines

Step 1 – Select the Cell 

  • Select the cell to adjust its size.

Step 2 – Hover the Cursor to the Column Header

  • Hover the cursor to the vertical line in between the next column header and the header  of the column in which the cell is placed.
  • The cursor will change into a double headed arrow.

Step 3 – Click , Hold and Drag the Cursor to Increase Cell Width

  • To increase the width of a cell, click on it and hold down the mouse button while dragging the cursor.
  •  Release the mouse button when the desired width has been achieved.

Step 4 – Hover the Cursor to the Row Header

  • Hover the cursor to the horizontal in between the next row header and the header  of the row in which the cell is placed.
  • The cursor will change into a double headed arrow.

Step 5 – Click , Hold and Drag the Cursor to Increase Cell Height

  • To increase the height of a cell, click on it and hold down the mouse button while dragging the cursor.
  • ¬†Release the mouse button when the desired height¬† has been achieved.

Method 2 : Adjusting Column Width using the Autofit Feature

Step 1 – Select the Cell 

  • Select the cell  to be adjusted.

Step 2 – Go to the Home Tab

  • Go to the Home tab in the menu bar.

Step 3 – Click on the Format Button

  • Click on the Format button in the Cells section in the Home tab.
  • A drop-down menu will appear.

Step 4 – Click on the Autofit Column Width Option

  • Click on the Autofit Column Width option in the drop-down menu.
  • The Width of the cell will be resized according to the data in it.

Step 5 – Click on the Autofit Row Height Option

  • Click on the Autofit Row Height option in the drop-down menu.
  • The height of the cell will be resized according to the data in it.

Leave a Comment