+ Reply to Thread
Results 1 to 7 of 7

Why can't I unhide row/format every row as 15 height?

  1. #1
    Registered User
    Join Date
    08-09-2019
    Location
    Massachusetts, United States
    MS-Off Ver
    Office16
    Posts
    4

    Thumbs up Why can't I unhide row/format every row as 15 height?

    I get a workbook from a colleague at work once a week. For some reason this time, when I go to search for the names, they don't pop up. There should be 10,393 rows, which it actually says there are, but I can only see 187 Rows. There are so many rows hidden in between each cell and for some reason, the only way I can see them is if I manually click and drag on each cell manually. For everything good and holy, I do not want to do this 10,000 times... literally. I have already tried selecting everything (ctrl + A), clicking unhide, or reformating everything to a 15 height. Neither of these worked. The only way I can see a cell is if I MANUALLY click and drag the height of a cell from 0 to 15. I need to get this report out by noon. Does anyone know of anything that can help me? I am happy to provide any information I can, but this is a work document containing information that is best off not shared. Thanks in advance!

    Edit: This was actually a simple fix. The person who edited the document last left a filter on the sheet, which was messing with the formatting and not allowing me to unhide rows.
    Last edited by Jeplonski; 09-27-2019 at 10:29 AM. Reason: Fixed issue

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Why can't I unhide row/format every row as 15 height?

    please upload your file

  3. #3
    Registered User
    Join Date
    12-20-2013
    Location
    United States
    MS-Off Ver
    Excel 2016
    Posts
    88

    Re: Why can't I unhide row/format every row as 15 height?

    have you tried copying the all the cells and pasting it into a new sheet? just an idea.

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

    Re: Why can't I unhide row/format every row as 15 height?

    Has the sheet been filtered?

  5. #5
    Registered User
    Join Date
    08-09-2019
    Location
    Massachusetts, United States
    MS-Off Ver
    Office16
    Posts
    4

    Re: Why can't I unhide row/format every row as 15 height?

    Sorry, I couldn't upload it. It has sensitive work information. The issue is fixed however

  6. #6
    Registered User
    Join Date
    08-09-2019
    Location
    Massachusetts, United States
    MS-Off Ver
    Office16
    Posts
    4

    Re: Why can't I unhide row/format every row as 15 height?

    It was filtered yes. I actually checked for this under a specific column but didn't think to clear all the filters for some reason. Thanks for the help guys.

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

    Re: Why can't I unhide row/format every row as 15 height?

    Glad it's sorted & thanks for the feedback

+ 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. Format - Auto fit row height
    By lostsoul65 in forum Excel General
    Replies: 1
    Last Post: 01-01-2015, 04:35 PM
  2. Format AutoRow Height
    By fjdesjardins in forum Excel General
    Replies: 3
    Last Post: 08-18-2014, 01:22 PM
  3. Format cell to accept height measurement
    By cadking in forum Excel General
    Replies: 3
    Last Post: 09-22-2013, 06:51 PM
  4. Allow hide/unhide of columns/rows but not height/width adjustment?
    By drew.j.harrison in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-19-2013, 11:43 PM
  5. Replies: 4
    Last Post: 03-29-2006, 07:55 AM
  6. VBA Format Row Height
    By gti_jobert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2006, 06:21 AM
  7. [SOLVED] Conditionally format row height
    By CDAK in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-08-2005, 05:05 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