Newbie Quest. On Pasting Data Between Two Spreadsheets

[Robert11]

Hello:

Using Excel 97 SR 1 with W98.
Pretty new at using spreadsheets, although I'm using a fairly old
version. But, it's been doing pretty much what i want.

Am stumped with this, however:

I have copied 5 rows of contiguous data from one spreadsheet.
I'd like to past these 5 lines into a second spreadsheet, betweeen rows of
existing data.

So, I insereted a blank row in the second spreadsheet where I want these 5
lines to start.
I thought it would move all the following rows down to enable these 5 lines
to
be pastedthere.

But it is overwriting the following 4 rows of data in this second
spreadsheet, rather than
moving them down to make room.

Do i havbe to make room for the 5 lines first, by inserting 5 blank lines ?
I thought it would do this automatically, as long as I started on a single
blank line.

What might I be doing wrong ?

Thanks,
Bob

 

[RagDyeR]

If you're copying *entire* rows (selecting the row numbers), then try right
clicking on the row number of the sheet where you intend to start the
insertion, and choose "Insert Copied Cells" from the pop-up menu.

This will *automatically* make room for all the rows on the clipboard.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hello:

Using Excel 97 SR 1 with W98.
Pretty new at using spreadsheets, although I'm using a fairly old
version. But, it's been doing pretty much what i want.

Am stumped with this, however:

I have copied 5 rows of contiguous data from one spreadsheet.
I'd like to past these 5 lines into a second spreadsheet, betweeen rows of
existing data.

So, I insereted a blank row in the second spreadsheet where I want these 5
lines to start.
I thought it would move all the following rows down to enable these 5 lines
to
be pastedthere.

But it is overwriting the following 4 rows of data in this second
spreadsheet, rather than
moving them down to make room.

Do i havbe to make room for the 5 lines first, by inserting 5 blank lines ?
I thought it would do this automatically, as long as I started on a single
blank line.

What might I be doing wrong ?

Thanks,
Bob