+ Reply to Thread
Results 1 to 8 of 8

Only 20 rows show up at a time

  1. #1
    Registered User
    Join Date
    11-01-2016
    Location
    Here
    MS-Off Ver
    2013
    Posts
    5

    Question Only 20 rows show up at a time

    I'm using Excel 2013 on a Windows 8.1 laptop.

    I have a spreadsheet that's 60 rows down.

    However, I must have hit some hot key by mistake or something.

    All of a sudden, only 20 rows are viewable, I have to scroll down and the next 20 rows pop up. It's really irritating. lol

    How can I get all the rows to show up like Excel normally displays?

    Thanks in advance to anyone who can help in any way.

  2. #2
    Registered User
    Join Date
    04-28-2014
    Location
    Florida
    MS-Off Ver
    Excel 2007, 2010, 2011 Mac. 2013,2016. I use 2011 and 2016 the most
    Posts
    90

    Re: Only 20 rows show up at a time

    Did you by chance hit Freeze Panes

  3. #3
    Registered User
    Join Date
    11-01-2016
    Location
    Here
    MS-Off Ver
    2013
    Posts
    5

    Re: Only 20 rows show up at a time

    Gosh, I don't know. Where is that located?

    When I zoom out, it looks as though its separating the spreadsheet, 20 rows per page, but when I print it, it prints fine on one page.

  4. #4
    Registered User
    Join Date
    11-01-2016
    Location
    Here
    MS-Off Ver
    2013
    Posts
    5

    Re: Only 20 rows show up at a time

    I just found the Freeze Pane control on the View Tab. It's greyed out so I can't select anything from it.

  5. #5
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Only 20 rows show up at a time

    By any chance are you scrolling with the mouse wheel? It happened to me from time to time Win 8.1 ... usually after an update.

    If so I just reset the system mouse settings.
    Last edited by FlameRetired; 11-01-2016 at 11:59 PM.
    Dave

  6. #6
    Registered User
    Join Date
    11-01-2016
    Location
    Here
    MS-Off Ver
    2013
    Posts
    5

    Re: Only 20 rows show up at a time

    I might have been. How do I go about resetting the mouse settings?

  7. #7
    Registered User
    Join Date
    11-01-2016
    Location
    Here
    MS-Off Ver
    2013
    Posts
    5

    Re: Only 20 rows show up at a time

    Ha, I just figured it out.

    On the View tab, I just hit "Normal" for the workbook view. I must have selected Page Layout somehow.

    Thanks to everyone who replied in this thread!

  8. #8
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Only 20 rows show up at a time

    You're welcome. Glad you found solution, and 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. Replies: 1
    Last Post: 02-16-2015, 11:46 AM
  2. Replies: 10
    Last Post: 11-08-2014, 04:51 PM
  3. [SOLVED] Show the date and time in a specific cell of last time we run a macro
    By dragon_m0nsta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2012, 04:49 AM
  4. Replies: 1
    Last Post: 01-20-2012, 07:17 AM
  5. Replies: 6
    Last Post: 11-29-2011, 09:12 AM
  6. Show Data Lables show Amount & Persentage at the same time
    By ComcoDG in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-29-2008, 04:54 AM
  7. [SOLVED] Show timesheet time in and out in regular time versus military tim
    By John in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-11-2005, 01:20 AM

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