The Size of a Cell

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

The Size of a Cell

Introduction

A cell uses a combination of the width of its parent column and the height of its parent role to determine its size. This means that the width of a cell is the width of its column and its height is that of its row. Therefore, to change or specify the size of a cell, you use the technique of setting the width of columns or the height of cells as we saw in Lessons 3 and 4.

Controlling the Widths of Cells

In future lessons, we will see how to enter values in cells. We will find out that it is not unusual that the content of a cell goes beyond its normal size. To show the hidden content of a cell, you can resize it.

As seen in Lesson 2:

  • To control the width of all cells of a column, position the mouse on the separating line between two column headers. Drag left or right until you get the desire width. Then release the mouse.
  • To change the widths of cells of a group of columns, first select the columns, whether in a range or randomly. Position the mouse on the column header border of one of the selected columns. Click and drag left or right in the direction of your choice until you get the desired with. Then release the mouse.
  • If a cell under a column header displays the width you want, click the box that has the desired width. Then:
    • Double-click the separating line between the column header
    • On the Ribbon, click Home. In the Cells section, click Format and click AutoFit Column Width
  • If many columns have some cells width a desired width, select those cells as we saw earlier. Then:
    • Double-click the separating line on one side of the column headers
    • On the Ribbon, click Home. In the Cells section, click Format and click AutoFit Column Width
  • To precisely set the width of cells under a column:
    • Right-click the column header and click Column Width...
    • Click a column header or any of its cells. On the Ribbon, click Home. In the Cells section, click Format and click Column Width...
  • To specify the same width for many columns:
    • Select a range of columns. Right-click either one of the column headers or inside the selection and click Column Width...
    • Randomly select a group of (non-adjacent) columns. Right-click one of the column headers and click Column Width...
    • Select the columns, whether in a range or randomly (non-adjacent). On the Ribbon, click Home. In the Cells section, click Format and click Column Width...
    Any of these actions would open the Column Width dialog box. From there, accept or enter the desired value and click OK

To undo any of these actions:

  • On the Quick Access toolbar, click the Undo button Undo
  • Press Ctrl + Z

Practical Learning: Setting the Widths of Cells

  1. Click Cell D4 to select it
  2. On the Ribbon, click Home if necessary.
    In the Cells section, click Format and click AutoFit Column Width
  3. Select Cells E4:I4
  4. In the Cells section of the Ribbon, click Format and click Column Width...
  5. Type 10 and click OK
  6. Press Ctrl + Home

Controlling the Heights of Cells

In Lesson 3, we saw different techniques of setting or controlling the heights of rows. Actually, these apply to cells on the right side of the rows. As a reminder:

  • To change the height of the cells of a row, click the lower border of a row header. Drag up or down until you get the desired height. Then release the mouse
  • To change the height of cells on the right sides of a group of rows, first select the rows. Position the mouse on the bottom border of one of the selected rows. Click and drag up or down in the direction of your choice until you get the desired height. Then release the mouse.
  • If the cells on the right side of a row header are too short or too tall, to change their height:
    • Double-click the bottom border of the row header
    • Click the row header. On the Ribbon, click Home. In the Cells section, click Format and click AutoFit Row Height
  • To precisely specify the height of cells of a row:
    • Right-click the row header and click Row Height...
    • Click a row header or any box on its right side. Then, on the Ribbon, click Home. In the Cells section, click Format and click Row Height...
  • To precisely set the same height for cells of many rows:
    • Select a range of rows. Right-click either one of the row headers or inside the selection and click Row Height...
    • Randomly select a group of (non-adjacent) rows. Right-click one of the row headers and click Row Height...
    • Select the rows. On the Ribbon, click Home. In the Cells section, click Format and click Row Height...
    This would call the Row Height dialog box where you can type the desired value and click OK or press Enter

To undo any of these actions:

  • On the Quick Access toolbar, click the Undo button Undo
  • Press Ctrl + Z