MS Excel Sheets...how to copy and paste ?

[tina SPEILBERG]

I have MS Excel 97

How to merge 2 or more MS excel Sheets ?

MS Excel Sheets...how to copy and paste one excel sheet into another?

I've tried this like I would normally do with Notepad or Word and it
says:

The information cannot be pasted because the Copy area and the paste
area are not the same size and shape. Try one of the following:

..Click a single cell and then paste.
..Select a rectangle that's the same size and shape, and then paste.

I tried everything but I cannot do a simple cut and paste.

can anyone please help me

Thanks in advance,

Tina

 

[Abdul salam]

hi tina,

for the first part...

You can copy one sheet to another by first selecting the
whole sheet (by clicking on the left most corner empty
part -before Column heading A and on top of Row label 1)
and select Edit>Copy (or right click and select copy).
Select the next sheet and paste.

Second part..

what you mean by merging?

copy the from first sheet below the data of another
sheet ?


Abdul salam

 

[tina SPEILBERG]

Hi Abdul,

I have Excel 97.

Yes, I have done exactly as you said.

I want the data to be copied (list 2) to be pasted after the FIRST
list..like a continuation of the first list. But it doesn't allow me
to do so.


When I point to the cell where I want the second list to be pasted...I
get the error message:

****************
The information cannot be pasted because the Copy area and the paste**********************************

I point to the first empty cell in column A after list #1.

IF I point to the very first cell in LIST no.1 then list 2 gets pasted
but list 1 disappears.


Why is this happening ?

I just want to be able to do a simple cut and paste.


Can anyone PLEASE HELP ?

Thanks

Tina