Question

How can youcopy the totals from row 38 on the January worksheet and paste only the values into cells B38 through M38 on the Forecasting worksheet?

Answer 1

To copy the totals from row 38 on the January worksheet and paste only the values into cells B38 through M38 on the Forecasting worksheet, you can use the 'Copy' and 'Paste Special' feature.

Step-by-step explanation:

To copy the totals from row 38 on the January worksheet and paste only the values into cells B38 through M38 on the Forecasting worksheet, follow these steps:

1. Select and copy row 38 on the January worksheet using the Ctrl+C shortcut.
2. Switch to the Forecasting worksheet.
3. Select cells B38 to M38.
4. Right-click and choose 'Paste Special'.
5. In the 'Paste Special' dialog box, select 'Values' and click 'OK'.

This will paste only the values from row 38 on the January worksheet into cells B38 through M38 on the Forecasting worksheet, without any formulas or formatting.

Learn more about Copy and Paste