+ Reply to Thread
Results 1 to 5 of 5

first row not visible in Excel 2016

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Microsoft Home and Business 2016

    first row not visible in Excel 2016

    Hi, not sure if this question is in the right place...

    I have a data file where the first row is not showing up. Yes, some of the panes are frozen. I have tried a few things but none of them have worked. Because this is sensitive data, I can't just post pictures here. I could send them via PM. Thanks.
    Last edited by 6StringJazzer; 01-22-2020 at 03:16 PM. Reason: Moved from Outlook Formatting & Functions

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019

    Re: first row not visible in Excel 2016

    Our PM system does not support file attachments. Our thread posts do. I recommend you remove sensitive data or replace it with a minimal amount of dummy data to demonstrate the problem.
    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會
    Please read the rules
    If someone helped you, click on the star icon at the bottom of their post
    If your problem is solved, go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

  3. #3
    Forum Expert
    Join Date
    New York
    MS-Off Ver
    Excel 2003, 2010, 2016 (Windows)

    Re: first row not visible in Excel 2016

    Try using Ctr-A to select everything (or click the box to the upper left of Cell A1) and then set the row height to anything other than 0, by either right-clicking the row labels and choosing "Row height" or by hovering over a row boundary in the row label area and clicking and dragging when the cursor changes to a double-headed arrow icon.
    Bernie Deitrick
    Excel MVP 2000-2010

  4. #4
    Forum Contributor
    Join Date
    MS-Off Ver

    Re: first row not visible in Excel 2016

    Can you share the sample file also??
    *If you wish you click on *,a way to say ThankYou

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    Ipswich, England
    MS-Off Ver
    Office 365 (Win 10 - Work) & Office 365 Subscription Insider (Win 10 - Home)

    Re: first row not visible in Excel 2016

    Even if the PM system did support attachments, you should NEVER share sensitive data with an unknown third party: you don't know any of us, and I suspect you'd be in breach of data protection measures if you did.

    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

+ 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. Replies: 0
    Last Post: 11-20-2019, 04:05 AM
  2. [SOLVED] No value given for one or more parameters - Access 2016 - Excel 2016
    By schulzy175 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2018, 10:11 PM
  3. Replies: 1
    Last Post: 09-18-2017, 08:27 AM
  4. [SOLVED] Issue send email with excel 2016 true outlook 2016
    By kirana2014 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-12-2017, 11:34 AM
  5. Help! Automated Email coding for Excel 2016 and Outlook 2016 problems
    By lisa6421 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-01-2017, 08:07 AM
  6. [SOLVED] custom menu through .xlam Addin visible but not working Office 2016
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-15-2016, 12:29 PM
  7. Replies: 6
    Last Post: 06-21-2005, 06:05 PM


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