Home

EXCEL HELP! cells not matching up with row highlighted

%3CLINGO-SUB%20id%3D%22lingo-sub-307502%22%20slang%3D%22en-US%22%3EEXCEL%20HELP!%20cells%20not%20matching%20up%20with%20row%20highlighted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307502%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20morning.%20%26nbsp%3BI%20am%20not%20a%20pro%20in%20Excel%2C%20but%20it%20is%20what%20I%20use%20to%20build%20my%20budgets%20on%20for%20work.%20%26nbsp%3BI%20have%20recently%20bought%20a%20new%20MacBook%20Pro%20and%20the%20latest%20Microsoft%2FExcel.%20%26nbsp%3BI%20have%20this%20problem%20when%20I%20get%20to%20the%20second%20page%20of%20my%20budget....the%20first%204%20lines%20at%20the%20top%20are%20out%20of%20sorts...for%20instance%20if%20I%20click%20on%26nbsp%3BRow%2061...the%20indicator%20on%20the%20left%20shows%20that%20I%20am%20on%20Row%2064...and%20it%20keeps%20'jumping'%20at%20those%20rows...and%20that%20makes%20it%20add%20wrong%2C%20and%20total%20wrong...and%20it's%20a%20nightmare.%20%26nbsp%3BI%20am%20supposed%20to%20work%20on%205%20budgets%20during%20this%20holiday%20and%20can't%20get%20past%20the%20first%20one%2Fsecond%20page.%20%26nbsp%3BPLEASE%20HELP%20-%20I%20am%20in%20a%20full%20blown%20panic.%20Thank%20you%2C%20Michele%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-307502%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-516157%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20HELP!%20cells%20not%20matching%20up%20with%20row%20highlighted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-516157%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20you%20responded%20to%20a%20similar%20problem%20I%20am%20having%20in%20Excel.%3C%2FP%3E%3CP%3EI%20am%20working%20in%20a%20worksheet.%20%26nbsp%3BThe%20formatting%20is%20normal.%3C%2FP%3E%3CP%3EThen%2C%20I%20get%20to%20the%20bottom%20rows%20and%20when%20I%20highlight%20a%20cell%20to%20modify%20it%2C%20the%20highlighted%20cell%20is%20not%20discreet%20(meaning%20it%20doesn't%20line%20up%20exactly%20to%20the%20cell%20I%20am%20trying%20to%20highlight)%20and%20it%20actually%20selects%20a%20cell%202%20or%203%20rows%20down.%3C%2FP%3E%3CP%3EI%20can't%20seem%20to%20reformat%20it%20to%20be%20normal.%20%26nbsp%3BAny%20suggestions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-307524%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20HELP!%20cells%20not%20matching%20up%20with%20row%20highlighted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307524%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Michele%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20didn't%20catch%20this%20problem!%3C%2FP%3E%3CP%3EA%20bunch%20of%20text%20sometimes%20doesn't%20help!%3C%2FP%3E%3CP%3EPlease%20provide%20further%20explanation%2C%20screenshots%2C%20or%20the%20workbook%20itself%20if%20you%20can%2C%20in%20order%20to%20figure%20out%20the%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EHaytham%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-523271%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20HELP!%20cells%20not%20matching%20up%20with%20row%20highlighted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-523271%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F332198%22%20target%3D%22_blank%22%3E%40BJA3633%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20guess%20that%20the%20cell%20you've%20selected%20is%20merged%20with%20another%20cell!%3C%2FP%3E%3CP%3EPlease%20check%20out%20this%20link%20below%20learn%20more%20about%20Merge%20and%20Unmerge%20cells%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-ie%2Farticle%2Fmerge-and-unmerge-cells-5cbd15d5-9375-4540-907f-c673a93fcedf%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-ie%2Farticle%2Fmerge-and-unmerge-cells-5cbd15d5-9375-4540-907f-c673a93fcedf%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E
minniebake
Occasional Visitor

Good morning.  I am not a pro in Excel, but it is what I use to build my budgets on for work.  I have recently bought a new MacBook Pro and the latest Microsoft/Excel.  I have this problem when I get to the second page of my budget....the first 4 lines at the top are out of sorts...for instance if I click on Row 61...the indicator on the left shows that I am on Row 64...and it keeps 'jumping' at those rows...and that makes it add wrong, and total wrong...and it's a nightmare.  I am supposed to work on 5 budgets during this holiday and can't get past the first one/second page.  PLEASE HELP - I am in a full blown panic. Thank you, Michele

3 Replies

Hi Michele,

 

I didn't catch this problem!

A bunch of text sometimes doesn't help!

Please provide further explanation, screenshots, or the workbook itself if you can, in order to figure out the problem.

 

Regards,

Haytham

@Haytham Amairah 

I think you responded to a similar problem I am having in Excel.

I am working in a worksheet.  The formatting is normal.

Then, I get to the bottom rows and when I highlight a cell to modify it, the highlighted cell is not discreet (meaning it doesn't line up exactly to the cell I am trying to highlight) and it actually selects a cell 2 or 3 rows down.

I can't seem to reformat it to be normal.  Any suggestions?

 

Hi@BJA3633

 

I guess that the cell you've selected is merged with another cell!

Please check out this link below learn more about Merge and Unmerge cells:

https://support.office.com/en-ie/article/merge-and-unmerge-cells-5cbd15d5-9375-4540-907f-c673a93fced...

 

Hope that helps

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies