Microsoft Office Tutorials and References
In Depth Information
Inserting rows, columns, and cells
SET UP You need the RouteVolume workbook located in the Chapter01 practice file
folder to complete this exercise. Open the workbook, and then follow the steps.
On the May 12 worksheet, select cell A1 .
On the Home tab, in the Cells group, click the Insert arrow, and then in the list, click
Insert Sheet Columns to create a new column A .
In the Insert list, click Insert Sheet Rows to create a new row 1 .
Click the Insert Options button that appears below the lower-right corner of the
selected cell, and then click Clear Formatting to remove the formatting from the
new row 1 .
Right-click the column header of column E , and then click Hide to remove column E
from the display.
On the tab bar, click the May 13 sheet tab to display the worksheet of the same
Click cell B6 .
On the Home tab, in the Cells group, click the Delete arrow, and then in the list, click
Delete Cells to open the Delete dialog box.