Home

Excel selecting different cells than what i click on

%3CLINGO-SUB%20id%3D%22lingo-sub-695576%22%20slang%3D%22en-US%22%3EExcel%20selecting%20different%20cells%20than%20what%20i%20click%20on%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-695576%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20work%20in%20an%20architecture%20firm%20and%20in%20belgium%20we%20have%20a%20standardized%20document%20for%20social%20housing.%20I%20added%20a%20screenshot%20of%20the%20problem.%20When%20i%20try%20to%20select%20a%20row%2C%20it%20selects%20a%20row%20a%20few%20rows%20down.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20rows%20i'm%20trying%20to%20select%20are%20the%20ones%20that%20have%20been%20linked%20to%20another%20tab%20and%20then%20have%20been%20removed%20in%20the%20other%20tab.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20click%20row%20117%2C%20you%20can%20see%20that%20excel%20selects%20a%20whole%20different%20row.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(also%20is%20there%20a%20way%20to%20delete%20all%20rows%20that%20have%20been%20deleted%20in%20another%20tab%3F)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-695576%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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?)

Related Conversations
DATEIF 30th v 31st of Month calculating months
alangibson in Excel on
0 Replies
How to keep a customer list current all the time
shotgun-68 in Excel on
1 Replies
New Member - Formula Help
Eddy_the_Surveyor in Excel on
5 Replies
Disappearing Waterfall Chart
Yomighty in Excel on
0 Replies
Pick list
Daveg86 in Excel on
4 Replies
Alt+ Enter not working
Nikhil_Shetty in Excel on
2 Replies