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: Create a Sample Spreadsheet

Open the spreadsheet you created in the previous lesson: Legs Eggs Pigs 2010.xlsx

Go to the Pigs spreadsheet.

Select Row 5 through Row 24.

(Do not include the Total in Row 25.)

Go to Home->Copy.

 
Go to a new spreadsheet.

Select Cell A1.

Go to Home->Paste.

Keep going...!

You can use the sample spreadsheet  or enter your own data if you wish.

Home->Copy

 

Exam 77-882: Microsoft Excel 2010 Core

2. Creating Cell Data

2.1. Construct cell data