Forum Discussion

Baysailor's avatar
Baysailor
Copper Contributor
Aug 10, 2022

Excel spreadsheet has incorrect line numbers

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?

Formulas and Functions
  • Icassatti's avatar
    Icassatti
    Brass Contributor
    Aug 10, 2022

    Hi Baysailor 

     

    Try select row 56 until row 63 pressing button shift.

     

    Then click right button of your mouse and choose option Unhide

     

    Hope it help you

    • Baysailor's avatar
      Baysailor
      Copper Contributor
      Aug 10, 2022
      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!
      • Icassatti's avatar
        Icassatti
        Brass Contributor
        Aug 10, 2022
        I am from Brazil.
        I am glad for it worked.
        Please accept post as a best response.

Resources