Excel spreadsheet has incorrect line numbers

New Contributor

I have a somewhat complex and very important financial spreadsheet. All of a sudden the LINE NUMBERS (far left column) are incorrect (out of sequence). Line 56 is followed by line 63! This is causing my formulas to work differently than designed. This just started happening today.

 

Any ideas on how to correct?

4 Replies

Hi @Baysailor 

 

Try select row 56 until row 63 pressing button shift.

Icasstti_0-1660101497418.png

 

Then click right button of your mouse and choose option Unhide

Icasstti_1-1660101610458.png

 

Hope it help you

IT WORKED!!!! Thank you soooo much!!
It was driving me crazy
Where do you live, icasatti? (Country, state?) This is my first time to use Tech Community. Great!
I am from Brazil.
I am glad for it worked.
Please accept post as a best response.

@Icassatti 

 

I just gave you HIGH marks.

 

I am in Alabama on the gulf coast of USA. Amazing how this peer support system works! 

Best Wishes,

 

**bleep** Scott