facebook google plus twitter
Webucator's Free Introduction to Microsoft Excel 2013 Tutorial

Lesson: Working with Rows and Columns

Welcome to our free Introduction to Microsoft Excel 2013 tutorial. This tutorial is based on Webucator's Introduction to Microsoft Excel 2013 Training course.

In this lesson, you will work with rows and columns.

Lesson Goals

  • Insert rows and columns in Microsoft Excel worksheets.
  • Delete rows and columns in Microsoft Excel worksheets.
  • Transpose rows and columns.
  • Change row heights.
  • Change column widths.
  • Hide and unhide rows and columns.
  • Freeze panes.

Inserting Rows and Columns

To insert a row or a column into a Microsoft Excel worksheet:

  1. Select a cell in your worksheet where you would like the new row or column to be inserted. To insert multiple rows or columns, simply select multiple cells.
    1. New rows are inserted above the selected cell(s).
    2. New columns are inserted to the left of selected cell(s).
  2. On the HOME tab, in the Cells group, click the Insert command.Insert in Cells Group of Home Tab
  3. Select Insert Sheet Rows or Insert Sheet Columns:Insert Drop-Down List

Deleting Rows and Columns

To delete a row or a column in a Microsoft Excel worksheet:

  1. Select a cell in your worksheet in the row or column you wish to delete. To delete multiple rows or columns, simply select multiple cells.
  2. On the HOME tab, in the Cells group, click the Delete command.Delete in Cells Group of Home Tab
  3. Select Delete Sheet Rows or Delete Sheet Columns:Delete Drop-Down List

Transposing Rows and Columns

You may at times determine that data you have already entered in a worksheet would be presented more logically by transposing rows and columns.

To transpose rows and columns:

  1. Select the cells with the headings and the data that you want to flip. Selected Cells
  2. On the HOME tab, in the Clipboard group, select Copy. Copy in Clipboard Group of Home Tab
  3. Place your cursor in a blank cell in the worksheet, which will become the top-left cell in the transposed group. Cell Position for Transposition
  4. Right-click and select the Paste Special arrow, and then click Paste Special. Paste Special
  5. In the Paste Special dialog box, check the Transpose check box and click OK. Paste Special Dialog Box
  6. The data now appears with the rows and columns swapped.Transposed Data

Setting Row Height and Column Width

Set a Specific Height or Width

To change the row height or column width of rows and columns in a Microsoft Excel worksheet:

  1. Select a cell in your worksheet in the row or column of which you wish to change the height or width. To change the height or width of multiple rows or columns, simply select multiple cells.
  2. On the HOME tab, in the Cells group, click the Format command.Format in Cells Group of Home Tab
  3. Select Row Height or Column Width:Row Height or Column Width
  4. In the Row Height dialog box or the Column Width dialog box, enter the new size of the row or column:Dialog Box
    1. Rows are measured in points, with each point equaling approximately 1/72 of an inch.
    2. Columns are measured in characters, so the value entered is equal to the number of characters that will fit in the cell (assuming you are using the standard font).

AutoFit Row Height or Column Width

When you AutoFit the row height or column width, Excel sets the height or width based on the contents in the row or column. To AutoFit the row height or column width:

  1. Select a cell in your worksheet in the row or column of which you wish to change the height or width. To change the height or width of multiple rows or columns, simply select multiple cells.
  2. On the HOME tab, in the Cells group, click the Format command.Format in Cells Group of Home Tab
  3. Select AutoFit Row Height or AutoFit Column Width:AutoFit Row Height or AutoFit Column Width

Hiding and Unhiding Rows and Columns

Hiding Rows and Columns

To hide rows or columns in a Microsoft Excel worksheet:

  1. Select a cell in your worksheet in the row or column you wish to hide. To hide multiple rows or columns, simply select multiple cells.
  2. On the HOME tab, in the Cells group, click the Format command.Format in Cells Group of Home Tab
  3. Select Hide & Unhide and then Hide Rows or Hide Columns:Hide Rows or Columns

Unhiding Rows and Columns

To unhide rows or columns in a Microsoft Excel worksheet:

  1. Select cells on either side (above and below or to the left and right) of the row(s) or column(s) you wish to unhide. Note: use your Shift key or make sure you have the whole range. Example:If you hide column E, then you must select column D thru F (including E).
  2. On the HOME tab, in the Cells group, click the Format command.Format in Cells Group of Home Tab
  3. Select Hide & Unhide and then Unhide Rows or Unhide Columns:Unhide Rows or Columns

Freezing Panes

Freezing panes is a way of making one or more rows or columns stay at the top or left of your worksheet as you scroll through the worksheet. A common use of freezing panes is to keep a header row in view as you scroll through a large worksheet.

In the following example, notice that the top row includes labels for each column:Top Row Visible

After scrolling down in the worksheet, however, the top row is not visible:Top Row Not Visible

In the following image, the top row is frozen, so the labels are visible even after scrolling down in the worksheet:Top Row Frozen

To freeze panes in a Microsoft Excel worksheet:

  1. On the VIEW tab, in the Window group, click the Freeze Panes command.Freeze Panes in Window Group of View Tab
  2. Select Freeze Panes to freeze the rows above and the columns to the left of the selected cell.
  3. Select Freeze Top Row to freeze the top row only.
  4. Select Freeze First Column to freeze the first column only.

Freeze Panes Options

Working with Rows and Columns

Duration: 5 to 10 minutes.

In this exercise, you will insert rows into a Microsoft Excel worksheet, hide rows, and adjust column widths and row heights.

  1. Continue working in the workbook from the last exercise or open Dave's Lemonade Stand - Working with Rows and Columns.xlsx from your Excel2013.1/Exercises folder.
  2. Insert two rows between row 7 and row 8.
  3. Hide the inserted rows.
  4. Increase the width of column A to 25.
  5. Increase the width of columns B:E to 17.
  6. Autofit row heights for all active rows.
  7. Save the workbook.

Solution:

  1. Open or go to the specified file.
  2. Select cells in both row 8 and row 9 and then on the HOME tab, in the Cells group, click Insert and then Insert Sheet Rows:Insert Sheet Rows
  3. Select rows 8 and 9 and then on the HOME tab, in the Cells group, click Format and then Hide & Unhide and then Hide Rows:Hide Rows
  4. Select column A and then on the HOME tab, in the Cells group, click Format and then Column Width:Column Width
  5. In the Column Width dialog box, enter "25" and click OK:Column Width Dialog Box
  6. Select columns B:E and then on the HOME tab, in the Cells group, click Format and then Column Width:Column Width
  7. In the Column Width dialog box, enter "17" and click OK.
  8. Select all active rows and then on the HOME tab, in the Format group, click AutoFit Row Height:AutoFit Row Height
  9. Save the workbook.