|
Let's assume for the moment you've just
finished setting up a spreadsheet to
show clients how the magic widget
improves sales tenfold.
You view your project with admiration,
and then realize you'll need something
just like it for other products, as
well.
Of course, you can copy and paste blocks
of your spreadsheet onto the next sheet
at the bottom of your workbook.
The two major problems with this are
that 1) it's extremely tedious, having
done the work already once; and 2) you
run a great risk of producing a
near-copy instead of an exact one.
Instead, do this:
- On the completed worksheet, click in
the top left cell to highlight the
entire sheet;
- Somewhere in the highlighted area in
an empty cell R-click and choose Copy;
- Click on Sheet 2 at the bottom to
open;
- Click in the corresponding cell on
the new sheet;
- Somewhere in the highlighted area
click R-click to paste.
You should see an exact duplicate. Don't
forget to save and rename your sheet at this
time if you want to.
In the example above, you might want to
keep the very last sheet of the workbook
as the blank template, and simply copy
for each new version.
To your small business/home business
success,
|
