+ Reply to Thread
Results 1 to 18 of 18

Missing row numbers, but not rows

  1. #1
    Forum Contributor
    Join Date
    08-30-2015
    Location
    Tresfjord, Norway
    MS-Off Ver
    365
    Posts
    180

    Missing row numbers, but not rows

    Hi

    I have searched the web, but to no use,
    I am missing row numbers, but not rows.
    See image.
    What is wrong, do you think?
    Attached Images Attached Images
    Last edited by Tresfjording; 07-28-2024 at 08:45 AM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,703

    Re: Missing row numbers, but not rows

    Suggest you read the banner at the top of this screen and post a file as we cannot manipulate pictures.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,377

    Re: Missing row numbers, but not rows

    Is this in one particular workbook or generally? Have you tried unhiding the hidden columns (A and B) to see if the row numbers reappear? Wat have you tried?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  4. #4
    Forum Contributor
    Join Date
    08-30-2015
    Location
    Tresfjord, Norway
    MS-Off Ver
    365
    Posts
    180

    Re: Missing row numbers, but not rows

    There are no rows to unhide.
    I checked the Data tab for searches, filter and sorting, but I can't see anything wrong.
    I have toggled the view headings in the Page Layout tab
    I have checked the options menu, but I didn't find anything suspicious there either.

    It's only in this certain file. I can't recreate this, and I'm sorry I can' send you the file.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,377

    Re: Missing row numbers, but not rows

    I think you misunderstood. I asked, "Have you tried unhiding the hidden columns (A and B) to see if the row numbers reappear?"

    If it's only one file, then I suggest you copy its data to a new file and ditch the old one - it may be corrupted.

  6. #6
    Forum Contributor
    Join Date
    08-30-2015
    Location
    Tresfjord, Norway
    MS-Off Ver
    365
    Posts
    180

    Re: Missing row numbers, but not rows

    Column a and B is not missing or hidden.

  7. #7
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,703

    Re: Missing row numbers, but not rows

    Tough to analyze without documentation. Good Luck. I'm Out!

  8. #8
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,740

    Re: Missing row numbers, but not rows

    Try selecting those rows & change the vertical alignment to Center.

  9. #9
    Forum Contributor
    Join Date
    08-30-2015
    Location
    Tresfjord, Norway
    MS-Off Ver
    365
    Posts
    180

    Thumbs up Re: Missing row numbers, but not rows

    HI!!

    That did it ...
    Thanks a lot ... (and I mean a lot!)

    PS; I can't give you a star reputation, upon doing so I get an error. But here's one:https://www.excelforum.com/images/icons/icon14.png
    Last edited by Tresfjording; 07-28-2024 at 09:35 AM.

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,377

    Re: Missing row numbers, but not rows

    Column a and B is not missing or hidden.
    How can I tell that from your screenshot? You were asked to attach a workbook and refused, so all we had to go on was a picture!

    If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

    Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

  11. #11
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,740

    Re: Missing row numbers, but not rows

    Glad to help & thanks for the feedback.

  12. #12
    Forum Contributor
    Join Date
    08-30-2015
    Location
    Tresfjord, Norway
    MS-Off Ver
    365
    Posts
    180

    Re: Missing row numbers, but not rows

    Sorry, but ...

    Attachment 875561

  13. #13
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,377

    Re: Missing row numbers, but not rows

    That just means that you can't give Fluff any more rep until you've repped another member or two. It's a precaution built in to stop misuse of the rep system.

  14. #14
    Forum Contributor
    Join Date
    08-30-2015
    Location
    Tresfjord, Norway
    MS-Off Ver
    365
    Posts
    180

    Re: Missing row numbers, but not rows

    .. I guess all possible downsides with this rule, has been thoroughly considered.
    But rules are rules ...

  15. #15
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,377

    Re: Missing row numbers, but not rows

    It's not so much a rule as a security measure set up by the site owner. They will have done it for good reason.

  16. #16
    Forum Contributor
    Join Date
    08-30-2015
    Location
    Tresfjord, Norway
    MS-Off Ver
    365
    Posts
    180

    Re: Missing row numbers, but not rows

    I guess so, but this time Fluff13 has been "deprived" of a well-deserved token of his helpfulness.
    Clearly, there must be other solutions to this problem, or...?

    What about an easy accessed ranked list of contributors governed by the site owners?
    Ranked on two criteria, like how many threads they have been active in, compared to how many solutions they have been credited?
    But this is another thread, isn't it?
    Last edited by Tresfjording; 07-28-2024 at 10:39 AM.

  17. #17
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,377

    Re: Missing row numbers, but not rows

    Yes - please feel free top open a thread here: https://www.excelforum.com/suggestions-for-improvement/

    You can give Fluff that rep at any time in the future after you've repped some other members.

  18. #18
    Forum Contributor
    Join Date
    08-30-2015
    Location
    Tresfjord, Norway
    MS-Off Ver
    365
    Posts
    180

    Re: Missing row numbers, but not rows

    May be I will do just that ...
    Thanks to the forum anyway!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Find missing number in rows from given set of numbers
    By JM6544088 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-25-2023, 05:20 AM
  2. Replies: 2
    Last Post: 06-01-2022, 12:18 PM
  3. [SOLVED] Add missing numbers but allow duplicates in the rows
    By stubyh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-08-2021, 11:41 AM
  4. Replies: 4
    Last Post: 10-19-2017, 08:12 AM
  5. [SOLVED] Repeat rows to complete missing numbers in a series
    By jenmc84 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-22-2015, 05:57 AM
  6. Adding rows and filling in missing numbers
    By flatlander88 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-14-2013, 01:39 PM
  7. to find missing serial numbers in randomly generated numbers
    By B.H. Hadi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-01-2005, 07:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1