copy and paste a row doesn't get it all

[Firewire]

I use a 7 page wide spread sheet for text data setup with many columns. I
frequently need to copy a full row from one spreadsheet to another
spreadsheet. I use the mouse to highlight the entire row, right click, then
copy, and paste into the new spreadsheet. I recently have noticed that not
all the cells are copied even though the highlighted area goes all the way
across the spread sheets. And the cells are the same number of cells where
I paste the info.

Is there a sure-fire-way to be sure I copy and paste the whole row of cells
from one spreadsheet into another?

 

[Dave Peterson]

When you select those cells, are you selecting by clicking on (say) A1 and
dragging to IV1?

Or do your click on the row number to the left of the column A?

(I don't recall ever seeing some cells not being pasted (if they were selected
and copied).)

 

[Firewire]

I just use the mouse highlight to copy and paste. In looking at the problem
I think it might be more of a problem with the sort feature instead of copy
and paste. After I copy and paste I sort the new line into the alphabetical
first column.

I wonder if "sort" gets confused after the first page.

 

[Dave Peterson]

Some bad things can happen pretty easily when you sort.

If you don't select the whole range (letting excel decide the range to sort is a
bad idea in my book), maybe some columns are being sorted.

I just use the mouse highlight to copy and paste. In looking at the problem
I think it might be more of a problem with the sort feature instead of copy
and paste. After I copy and paste I sort the new line into the alphabetical
first column.

I wonder if "sort" gets confused after the first page.