+ Reply to Thread
Results 1 to 4 of 4

Ctrl + end on my excel sheet takes me to row 1048576 but last data is in row 5139

  1. #1
    Forum Contributor
    Join Date
    06-14-2014
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    186

    Ctrl + end on my excel sheet takes me to row 1048576 but last data is in row 5139

    Hi,

    I have an excel file that is currently 27,421KB.
    It was previously 33,000KB but I have taken out 15 tabs sheets and packaged this up as a separate file.

    I still think I can bring it down further by clearing it up and one thing I am doing is stepping through each tab sheet and pressing ctrl + end.
    And I noticed that a lot of them are taking me way far too down than where my last data actually is.

    I am trying to clear these blank excess rows by deleting them but I get a warning message saying this operation affects a large number of cells > I click ok and then I get an Excel error message Excel ran out of resources.

    I do not have any other applications running when I am doing this.

    Is there anyone out there that has dealt with this kind of issue successfully?

    Thank You

  2. #2
    Forum Contributor Dante Amor's Avatar
    Join Date
    07-24-2020
    Location
    MEXICO
    MS-Off Ver
    Excel 2013
    Posts
    212

    Re: Ctrl + end on my excel sheet takes me to row 1048576 but last data is in row 5139

    Try he following:
    Create a new book with the same number of sheets and sheet names from your "problem" book.
    In your "problem" book
    1. select sheet1
    2. select only cells that contain data
    3. copy
    4. Select sheet1 of the new workbook
    5. paste the data
    Repeat the steps for each of the sheets.

  3. #3
    Registered User
    Join Date
    12-26-2016
    Location
    SA, KSA
    MS-Off Ver
    2010, 2013, 2016, 2019
    Posts
    44

    Re: Ctrl + end on my excel sheet takes me to row 1048576 but last data is in row 5139

    Try clearing the excess formatting.

    you can read more about it at below links.

    https://support.microsoft.com/en-us/...9-4874f7474738
    https://support.microsoft.com/en-us/...rs=en-us&ad=us

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

    Re: Ctrl + end on my excel sheet takes me to row 1048576 but last data is in row 5139

    .
    Have you created a cell border that extends to every cell in a Column ? Down to row 1048576 ? That will cause the issue.

    The same will occur if you have colored the cell interior / background for every cell in a column.

+ 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: 3
    Last Post: 04-16-2020, 07:43 PM
  2. Disable Ctrl+A, Ctrl+C and Ctrl+V in Excel
    By wedzmer in forum Excel General
    Replies: 5
    Last Post: 05-10-2018, 03:59 AM
  3. opem csv in excel more than 1048576 rows
    By kamlesh0905 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 02-16-2017, 10:43 AM
  4. [SOLVED] Why my workbook takes too much time after pressing Ctrl+S to save
    By ImranBhatti in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-04-2015, 03:49 AM
  5. Create a data validation list takes data from another sheet
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-02-2015, 05:54 AM
  6. USEDRANGE Problem - Excel 2010 and LastRow is 1048576
    By marzoumm in forum Excel General
    Replies: 2
    Last Post: 05-02-2014, 10:49 AM
  7. Replies: 0
    Last Post: 01-30-2013, 08:18 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