+ Reply to Thread
Results 1 to 7 of 7

Can not find hidden row in excel

  1. #1
    Forum Contributor
    Join Date
    06-19-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2019
    Posts
    151

    Can not find hidden row in excel

    Hi.

    I have an excel document and row 1 seems hidden for some reason. It is also too small to drag and make bigger and I can not unhide it. Is there a way to find it again as I need to delete that row?

    Thanks.

  2. #2
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Office 365
    Posts
    452

    Re: Can not find hidden row in excel

    select entire row >right click >row height
    give a number for row height eg. 15

  3. #3
    Forum Contributor
    Join Date
    06-19-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2019
    Posts
    151

    Re: Can not find hidden row in excel

    Hi.

    Unfortunatly I can not select the row either to do.

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,496

    Re: Can not find hidden row in excel

    Can you select the rows on either side of it then do as Sadath31 recommended? To get more help you might have to upload the file unless it contains sensitive information.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  5. #5
    Forum Contributor
    Join Date
    06-19-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2019
    Posts
    151

    Re: Can not find hidden row in excel

    Unfortunately, it can not upload it.

    i can select row two but cant unhide row 1 no

  6. #6
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,496

    Re: Can not find hidden row in excel

    I tried on a sheet of my own, if row 1 is hidden, I can drag it down by clicking at the top edge of row 2. I can also highlight the entire sheet then right click and use row height to adjust the height and that unhides row 1 again. Did you create the sheet? Is there any possibility it is password protected?

  7. #7
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Can not find hidden row in excel

    Please Login or Register  to view this content.
    Kind regards
    Leo

+ 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] Hidden Frames, cannot find them
    By ciresuark in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2015, 04:26 PM
  2. Replies: 2
    Last Post: 03-21-2014, 11:32 AM
  3. [SOLVED] trying to access the excel sheets/Tabs in the hidden/very hidden mode through hyperlinks
    By Kiran Kurapati in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-30-2013, 06:50 AM
  4. How can I find/unhide hidden excel sheet tabs on a worksheet?
    By magician in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-13-2012, 05:37 PM
  5. [SOLVED] how to find if an excel sheet has any hidden values in a cell in VB.NET
    By sparrow in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-14-2006, 01:50 AM
  6. Find Excel files that have hidden workbook
    By sparrow in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-02-2006, 02:00 PM
  7. How to find hidden names on an Excel worksheet ?
    By Jon Sipworth in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-13-2005, 02:20 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