What is an Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column?

When you begin working on a spreadsheet, all the rows and columns are the same size. As information is entered into the worksheet, some of the columns or rows may not be large enough to display the information they contain.

When you see ##### in a cell, it means the column width is not wide enough to show all the cell contents. Once the column width is adjusted, and the data will reappear.

Adjust Column Width

1. Click and drag a column header’s right border to the left or right.
   

   When you position the cursor over a column heading's border, a two-headed black arrow appears. This needs to be showing before clicking and dragging.

Adjust Row Height

1. Click and drag a row header’s bottom border up or down.
   

A line appears as you drag, showing you where the new row border will be.

AutoFit Columns or Rows

The AutoFit feature automatically resizes columns or rows to fit the cell in each column or row that has the widest or tallest contents.

1. Double-click the column header’s right border (or the row header's bottom border).
   

Set a Row or Column Value

If you know exactly what size you want a column or row to be, you can set a precise value.

1. Select a cell in the column or row you want to adjust.
2. Click the Format button arrow on the Home tab.
3. Select Row Height or Column Width.
4. Type a row height or column width and click OK.
   

BIOL 105

Medical Terminology

Harrisburg Area Community College Harrisburg

An Excel file that contains one or more worksheets

Another name for a worksheet

The intersection of a column and a row

The labels along the lower border of the Excel window that identify each worksheet

A vertical group of cells in a worksheet

A horizontal group of cells in a worksheet

Anything typed into a cell

Text or numbers in a cell

Numbers, text, dates, or times of day that you type into a cell

An equation that performs mathematical calculations on values in a worksheet

Constant values consisting of only numbers

Another name for a cell reference

Another name for a constant value

The small black square in the lower right corner of a selected cell

The graphic representation of data in a worksheet

On startup, Excel displays a new blank _____

An element in the Excel window that displays the value or formula contained in the active cell is the _____

An element of the Excel window that displays the name of the selected cell, table, chart, or object is the _____

A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the _____

A cell surrounded by a black border and ready to receive data is the _____

The Excel feature that generates and extends values into adjacent cells based on the values of selected cells is _____

The default format that Excel applies to numbers is the _____

The data that displays in the Formula Bar is referred to as the _____

The type of cell reference that refers to cells by their fixed position in a worksheet is _____

Tiny charts embedded in a cell that give a visual trend summary alongside your data are _____

An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is _____

The symbols with which you can specify the type of calculation you want to perform in an Excel formula are _____

A feature that displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas is called _____

The area along the bottom of a chart that identifies the categories of data is the _____

A feature that outlines cells in color to indicate which cells are used in a formula is called _____

What is the Excel feature that generates and extends values into adjacent cells based on the values of selected cells?

What are the symbols with which you can specify the type of calculation you want to perform in an Excel formula?

How do I increase the width of a cell in Excel?

How do you change the cell size to fit text in Excel?