Results 1 to 5 of 5

Thread: Sorting Causes Worksheet to End at 16,000 or So

  1. #1
    Acolyte jdanniel's Avatar
    Join Date
    Jul 2018
    Posts
    65
    Articles
    0
    Excel Version
    2016

    Sorting Causes Worksheet to End at 16,000 or So



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi everyone, I'm using Excel as part of Office 365. I have a spreadsheet for my music collection, and it does something that confuses me. It's not serious or critical, but I'd like to know why it does this, and if it can be prevented.

    I've converted the spreadsheet to a table, so I can use slicers. When I use CTRL + END to go to the end of the list, Excel goes precisely to the very last row that has been entered. This is perfect and exactly what I want.

    However, if I sort any column in the worksheet, then when I try scrolling down to the end via CTRL + END, it goes way, far down to the last blank row, which is something like 16,000!

    I know how to fix this when it happens, by using PAGE DOWN to get to the final row, and then entering new data in the next available open row. Not a big deal to fix, but I was wondering if there's a way to prevent Excel from going all the way to the very end whenever I sort. I'm wondering if I may not have created the table correctly? Or is there a reason why this happens when I sort a column?

    Thank you! Jd
    Attached Files Attached Files

  2. #2
    Conjurer Logit's Avatar
    Join Date
    Nov 2016
    Posts
    277
    Articles
    0
    Excel Version
    2007
    .
    If you use CTRL / DOWN ARROW it will get you to the last used row, after filtering.

  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,812
    Articles
    0
    Excel Version
    365
    Resize your table to:
    Click image for larger version. 

Name:	2020-10-27_004301.png 
Views:	8 
Size:	35.8 KB 
ID:	10123

    to get:
    Click image for larger version. 

Name:	2020-10-27_004426.png 
Views:	6 
Size:	7.7 KB 
ID:	10125

    It currently goes down a lot further:
    Click image for larger version. 

Name:	2020-10-27_004537.png 
Views:	7 
Size:	13.6 KB 
ID:	10124

    Click the pics to get a better view.
    Don't worry, adding data to the bottom of the table will automatically expand the table.
    Last edited by p45cal; 2020-11-07 at 03:59 PM.

  4. #4
    Acolyte jdanniel's Avatar
    Join Date
    Jul 2018
    Posts
    65
    Articles
    0
    Excel Version
    2016
    Thank you both for your replies and assistance. Jd

  5. #5
    Conjurer Logit's Avatar
    Join Date
    Nov 2016
    Posts
    277
    Articles
    0
    Excel Version
    2007
    You are welcome.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •