how can I paste all the copied cells

When doing copy, paste using Excel 2003, only the first 2 columns are being
pasted. Have you any idea how to change that

How many columns are you attempting to copy/paste and from where to where?

More detail please.


Gord Dibben MS Excel MVP

On Wed, 3 Jan 2007 09:08:02 -0800, Lura66
wrote:

When doing copy, paste using Excel 2003, only the first 2 columns are being
pasted. Have you any idea how to change that

Probably a case of mistaken identity. Excel is likely copying/pasting what
you tell it to, but the formatting for the destination is such that your
perception is that only the two colums are appearing. Oftentimes, people try
to "duplicate" a worksheet by copying and pasting into a blank worksheet.
This is not the best way when you want to copy the entire worksheet. If you
want to duplicate a worksheet, do the following: When within the worksheet
you want to duplicate, right click on the tab at bottom, choose "move or
copy", check the box that says "create a copy", and (right above the check
box) scroll down to "(move to end)", and click "ok". This creates an exact
copy of the parent worksheet under a new tab at the end.

Let us know if this is not what you are trying to do.
--
Y


"Lura66" wrote:

When doing copy, paste using Excel 2003, only the first 2 columns are being
pasted. Have you any idea how to change that