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.