Comma Training Page 54

Before You Begin

This discussion begins by creating a sample spreadsheet that combines all of the dates and product sales forecast from three different spreadsheets. This lesson introduces a common copy/paste error, and methods for correcting it.

1. Try it: Open a Sample Spreadsheet

Open the spreadsheet you created in the previous lesson Legs Eggs Pigs 2013.xlsx
Go to the Pigs spreadsheet.

Select Row 5 through Row 28.

(Do not include the Total in Row 29.)

Go to Home->Clipboard->Copy.

Go to a new spreadsheet.

Select Cell A1.

Go to Home->Clipboard->Paste.

Keep going...!

Memo to Self: You can download and open the sample file or continue with the "Legs Eggs and Pigs" spreadsheet from the previous lesson.

There may be a yellow security banner at the top of the spreadsheet. Click ENABLE so you can work on this lesson, please. .