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

[tina SPEILBERG]

I have 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

 

[Kim Mitchell]

You are probably selecting the entire sheet to copy and then trying to paste
in the area below other data. When you copy an entire sheet, you are
copying 35,536 rows and 256 columns. When you paste, you are trying to
paste 35,536 rows below x number of rows creating 65,536 + x rows. Excel
only allows 65,536 rows. When you copy/cut your data, you should select
only the portion of the worksheet that has data. When you paste your data,
select only one cell. It you remain within Excel's row and column limits,
you should have no problem. HTH

Kim