Step by Step 1: Insert and Delete Rows and Columns GET READY. Before you begin these steps, be sure to launch Microsoft Excel. Open the workbook named 07 Messenger Row-Column. Click the row 14 heading to select the entire row. On the HOME tab, in the Cells group, click the Insert button arrow and select Insert Sheet Rows, as shown below. A new blank row appears as row 14. To insert several rows at once, click the row 25 heading, hold down the Ctrl key, and then click row headings 34 and 43. Right-click any of the selected rows and select Insert from the shortcut menu. Blank rows appear above the selected rows, so that data for each messenger is separated by a blank row. Click the column D heading to select the entire column. This column contains the delivery zone. On the HOME tab, in the group, click the Delete button arrow and select Delete Sheet Columns. The Zone column disappears. the row 3 heading and select Insert from the shortcut menu. In cell A3, type Zone 1. Select A3:I3. On the HOME tab, in the Alignment group, click the Merge & Center button. The 1” text is centered across the data columns. “Zone SAVE the workbook. PAUSE. Leave the workbook open to use in the next exercise. Step by Step 2: Modify Row Height and Column Width GET READY. USE the workbook from the previous exercise. Double-click the boundary to the right of the column G heading (below), which adjusts the column width to show all content in column G.
Step by Step 1: Insert and Delete Rows and Columns GET READY. Before you begin these steps, be sure to launch Microsoft Excel. Open the workbook named 07 Messenger Row-Column. Click the row 14 heading to select the entire row. On the HOME tab, in the Cells group, click the Insert button arrow and select Insert Sheet Rows, as shown below. A new blank row appears as row 14. To insert several rows at once, click the row 25 heading, hold down the Ctrl key, and then click row headings 34 and 43. Right-click any of the selected rows and select Insert from the shortcut menu. Blank rows appear above the selected rows, so that data for each messenger is separated by a blank row. Click the column D heading to select the entire column. This column contains the delivery zone. On the HOME tab, in the group, click the Delete button arrow and select Delete Sheet Columns. The Zone column disappears. the row 3 heading and select Insert from the shortcut menu. In cell A3, type Zone 1. Select A3:I3. On the HOME tab, in the Alignment group, click the Merge & Center button. The “Zone 1” text is centered across the data columns. SAVE the workbook. PAUSE. Leave the workbook open to use in the next exercise. Step by Step 2: Modify Row Height and Column Width GET READY. USE the workbook from the previous exercise. Double-click the boundary to the right of the column G heading (below), which adjusts the column width to show all content in column G.
step_by_step_7-_excel.docx