+ Reply to Thread
Results 1 to 7 of 7

Rows will not resize

  1. #1
    Registered User
    Join Date
    07-12-2016
    Location
    Mount Olive, Alabama
    MS-Off Ver
    2013
    Posts
    47

    Rows will not resize

    A coworker gave me a spreadsheet that has a bunch of rows hidden (resized?).

    I have tried resizing the rows, but that does not work. I can resize a row, one at a time, by using the mouse, but there's over a thousand rows, and I don't have the patience for that.

    Anyone have any idea?

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

    Re: Rows will not resize

    Highlight all of them then right click and select row height then select the row height and click ok, would that work for you?
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    07-12-2016
    Location
    Mount Olive, Alabama
    MS-Off Ver
    2013
    Posts
    47

    Re: Rows will not resize

    Quote Originally Posted by Sambo kid View Post
    Highlight all of them then right click and select row height then select the row height and click ok, would that work for you?
    That was the first thing I tried. It doesn't work.

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

    Re: Rows will not resize

    and I suppose the second thing you tried was to highlight them all and then right click and hit unhide?
    If those two options don't work, any chance you can upload the workbook on here so people can have a look?

  5. #5
    Registered User
    Join Date
    07-12-2016
    Location
    Mount Olive, Alabama
    MS-Off Ver
    2013
    Posts
    47

    Re: Rows will not resize

    Quote Originally Posted by Sambo kid View Post
    and I suppose the second thing you tried was to highlight them all and then right click and hit unhide?
    If those two options don't work, any chance you can upload the workbook on here so people can have a look?
    Yes, that was the second thing I tried.
    Attached Files Attached Files

  6. #6
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,661

    Re: Rows will not resize

    Column E is filtered (notice the little funnel icon on the dropdown?). Click the dropdown and select ALL...
    Ben Van Johnson

  7. #7
    Registered User
    Join Date
    07-12-2016
    Location
    Mount Olive, Alabama
    MS-Off Ver
    2013
    Posts
    47

    Re: Rows will not resize

    Thanks.

    . .

+ 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] Delete certain rows that are empty and resize those that are not
    By hans222 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-28-2017, 12:31 PM
  2. Macro to Resize Rows
    By Cremorneguy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2014, 11:47 AM
  3. Resize the list box rows
    By nher482k in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-26-2013, 07:35 AM
  4. Can't Resize Table Rows in PowerPoint
    By daviddoria in forum Excel General
    Replies: 1
    Last Post: 09-06-2009, 09:31 AM
  5. [SOLVED] resize colums / rows in range
    By philcud in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-26-2005, 01:05 PM
  6. [SOLVED] How can I resize columns and rows to inches?
    By Max Gough in forum Excel General
    Replies: 4
    Last Post: 06-30-2005, 07:05 PM
  7. resize rows and column
    By newbie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2005, 04:06 AM

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