Excel XP

  Macaonasa 12:57 30 Jan 2003
Locked

Example 1:
I have 5 rows together. If I cut, say, row 3 and move down the page and paste, the row pastes okay and rows 4 and 5 move up in the original group to become 3 and 4.

Example 2:
This is fine. However, when I paste row 3 into another worksheet, it pastes fine but the original row on the first sheet appears as a blank row insteading of disappearing.

Any ideas?

  VoG™ 13:05 30 Jan 2003

I don't have access to XP at the moment but I think it is a "feature".

As a workaround, select the rows and Data/Sort. That will eliminate the blanks (well, move the blank rows to the bottom).

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?