Hello,
I'm viewing an .xls file in MS excel 2007 that contains a large formatted
table. When I insert a new copied row, my data in other cells disappear. To
view them, I would have to highlight the cell range or double-click on the
whole worksheet. I wanted to move a row to a different area of the table, so
I did the following:

1) Insert a new row.
2) Select the row I want to move and right click, and then choose cut.
3) Go to the row that I inserted in step 1 and right-click, and then choose
insert copied cells.

Some of my data in other row cells disappear (invisible). To reveal them,
I would have to either highlight them or double-click on the entire worksheet.

Any ideas why this is happening?