+ Reply to Thread
Results 1 to 9 of 9

Row Number shows blank

  1. #1
    Forum Contributor
    Join Date
    12-19-2011
    Location
    Central Europe
    MS-Off Ver
    Excel O365
    Posts
    361

    Row Number shows blank

    Hi all

    My file has multiple sheets, however, on Sheet2, in row 1, 2 and 3 Excel does not show the row number - please see hereunder attached

    RowNumber.jpg

    How can I get Excel to display these?
    Opening and Closing does not help, btw.

    Thanks
    FD

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Row Number shows blank

    Why part of the screenshot?

    Please show a full screenshot


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Contributor
    Join Date
    12-19-2011
    Location
    Central Europe
    MS-Off Ver
    Excel O365
    Posts
    361

    Re: Row Number shows blank

    Hi, sorry, can' t do that due to confidential data being on there - any idea would coud "suppress" the row number from showing?

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Row Number shows blank

    You just duplicate the worksheet and delete the data in the duplicated worksheet and take the blank sheet screen shot

  5. #5
    Forum Contributor
    Join Date
    12-19-2011
    Location
    Central Europe
    MS-Off Ver
    Excel O365
    Posts
    361

    Re: Row Number shows blank

    You won't see much more

    Rows Missing.jpg

    Any idea why the first three row numbers don't show?

  6. #6
    Forum Contributor
    Join Date
    12-19-2011
    Location
    Central Europe
    MS-Off Ver
    Excel O365
    Posts
    361

    Re: Row Number shows blank

    Good day all

    Any clue what could cause this?

  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Row Number shows blank

    I am unable to fix

    Don't worry, I call all members help for this thread

  8. #8
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,463

    Re: Row Number shows blank

    Try to open excel menu File, Option/Advanced : Cut,Copy and paste and be sure 3 boxes are checked.
    Quang PT

  9. #9
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,425

    Re: Row Number shows blank

    Maybe this thread will throw up some ideas.

    https://social.technet.microsoft.com...s-disappearing


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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] Looking value in last row, it shows only blank
    By Thuch Vannarath in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-01-2014, 11:43 AM
  2. [SOLVED] Cell referenced in formula has no information displayed (shows blank), return blank cell
    By nunayobinezz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-07-2013, 04:51 PM
  3. Replies: 4
    Last Post: 04-12-2013, 01:17 PM
  4. 0 shows as blank
    By rookie37 in forum Excel General
    Replies: 2
    Last Post: 11-18-2010, 11:56 PM
  5. Blank cell shows 0 or 12:00 AM if there is formula
    By fun123 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-25-2009, 03:38 PM

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