Excel XP

  Macaonasa 12:57 30 Jan 03
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 03

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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…