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: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.
Next