Working with Rows and Columns - Exercise

Contact Us or call 1-877-932-8228
Working with Rows and Columns - Exercise

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:
  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:
  4. Select column A and then on the HOME tab, in the Cells group, click Format and then Column Width:
  5. In the Column Width dialog box, enter "25" and click OK:
  6. Select columns B:E and then on the HOME tab, in the Cells group, click Format and then 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:
  9. Save the workbook.
Next