Excel selecting different cells than what i click on

Copper Contributor

Hi,

 

I work in an architecture firm and in belgium we have a standardized document for social housing. I added a screenshot of the problem. When i try to select a row, it selects a row a few rows down. 

The rows i'm trying to select are the ones that have been linked to another tab and then have been removed in the other tab. 

 

I tried to click row 117, you can see that excel selects a whole different row.

 

(also is there a way to delete all rows that have been deleted in another tab?)

0 Replies