+ Reply to Thread
Results 1 to 7 of 7

How to Expand These Rows

  1. #1
    Registered User
    Join Date
    12-04-2018
    Location
    Illinois
    MS-Off Ver
    Excel, Word
    Posts
    3

    Angry How to Expand These Rows

    Newbie question, how do I expand these rows in the picture? See the double lines circled, there are additional rows hiding behind these. I've tried unhide/hide all, unfreeze panes, and other options, but still to no avail. Any help would be appreciated.

    Regards.

    How To Expand in Excel.PNG

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,012

    Re: How to Expand These Rows

    Left click row 3 and hold. Drag down to row # 258. Release.

    Right click highlighted rows, select UNHIDE.

  3. #3
    Registered User
    Join Date
    12-04-2018
    Location
    Illinois
    MS-Off Ver
    Excel, Word
    Posts
    3

    Re: How to Expand These Rows

    Thanks Logit, but this doesn't seem to work. I just tried various ways of doing this as well.

  4. #4
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: How to Expand These Rows

    Try turning any filters off (in Data tab) and also unfreezing panes (in View tab).

  5. #5
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: How to Expand These Rows

    May be row height set as zero do the following

    select rows from 3:258
    Press Alt, O, R, E or
    Alt, H, O, H then set row height to 20 (as per your need)
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  6. #6
    Registered User
    Join Date
    12-04-2018
    Location
    Illinois
    MS-Off Ver
    Excel, Word
    Posts
    3

    Re: How to Expand These Rows

    I've tried the row height already, it didn't work. It was the filter option that needed to be cleared, and that resolved the issue. Thanks all.

  7. #7
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,012

    Re: How to Expand These Rows

    .
    Glad you have it corrected. Cheers !

+ 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] Expand rows automatically based on grouped rows(Expansion and Contraction)
    By paradise2sr in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-22-2016, 11:20 PM
  2. How To Expand Rows
    By midwest trader in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-08-2014, 12:00 PM
  3. Replies: 1
    Last Post: 11-19-2012, 04:16 PM
  4. How to get rows to expand in excel
    By runt1 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 12-01-2010, 10:35 AM
  5. Expand Worksheet Rows using One to Many
    By mitchellm in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-19-2010, 03:16 PM
  6. auto expand rows
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-14-2005, 03:50 AM
  7. auto expand rows
    By [email protected] in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-14-2005, 03:50 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