Special Paste Options

Copy the totals from row 38 on the January worksheet and paste just the values into cells B38 through M38 on the Forecasting worksheet.

1. If necessary, click the January worksheet tab
2. Select cells B38 through M38
3. In the Home tab, Clipboard group, click the Copy button
4. Click the Forecasting worksheet tab
5. Click cell B38
6. In the Clipboard group, click the Paste drop-down arrow
7. Click the Paste Values option

Autofill

Use AutoFill to add 12 months to row 2. Then, use AutoFill to fill the gym membership price of $10 a month through the month of December.

1. Click cell D2
2. Use the AutoFill feature to fill the cell values through cell P2
3. Click cell D3
4. Use the AutoFill feature to fill the cell values through cell M3

Insert Multiple Rows & Columns

Insert two columns between December and January. Then, insert two rows below the top row on the worksheet.

1. Click and drag to select columns N and O
2. In the Home tab, Cells group, click the Insert drop-down button
3. Click Insert Sheet Columns
4. Click and drag to select rows 2 and 3
5. In the Cells group, click the Insert drop-down button
6. Click Insert Sheet Rows

Insert and Delete Cells

Insert a cell above cell A7. Then, delete cell B2, shifting the remaining cells upward.

1. Ensure cell A7 is selected
2. In the Home tab, Cells group, click the Insert drop-down button
3. Click Insert Cells
4. Ensure the Shift cells down option is selected
5. Click the OK button
6. Click cell B2
7. In the Cells group, click the Delete drop-down button
8. Click Delete Cells
9. Ensure the Shift cells up option is selected
10. Click the OK button