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...
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.
    • Baysailor's avatar
      Baysailor
      Copper Contributor
      Aug 11, 2022

      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

Resources