View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
bpeltzer
 
Posts: n/a
Default When I special paste and transpose....

Before you paste, you should select where to paste. The easiest approach
will be to select a single cell (that is, click in a single cell which will
be the first into which the data is pasted). You should also select it such
that, when pasting the transposed row, it will not cross the original source
region.
Ex: you've selected row 1 and hit edit copy. Now click in cell A2 and
THEN paste special, transpose.

"sml" wrote:

When I select my row, copy, special paste, and transpose a message that reads:

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 have no idea what this means. Any help out there?

Thanks