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 5T review: Hands-on

Illustrator Andrés Lozano on his improv line work, brazen use of colours & hand sketching

iPhone X review

Comment envoyer gratuitement des gros fichiers ?