CTRL+END seems to jump to K1048576

**King Mustard** · 12-19-2019, 07:28 AM

I have a worksheet with content in every cell between A1 and K1755.

The general idea of CTRL+END is to select the bottom-right cell in a worksheet. In this worksheet, that should be K1755.

However, when I use CTRL+END on this worksheet, it jumps to K1048576.

I have selected rows 1756 to 1048576 twice, one time to right-click on the selected rows and select Delete and the second time to go to Clear > Clear All.

However, CTRL+END is still jumping to K1048576, as if there's content somewhere.

Any ideas?

Due to the contents of the worksheet, I can not attach it.

**Pepe Le Mokko** · 12-19-2019, 07:30 AM

Does this help ? https://www.techrepublic.com/blog/mi...orkbook-bloat/

**King Mustard** · 12-19-2019, 10:05 AM

Originally Posted by Pepe Le Mokko

Does this help ? https://www.techrepublic.com/blog/mi...orkbook-bloat/

Unfortunately, I don't think it does, as I've already moved data and formatting.

**FDibbins** · 12-20-2019, 01:47 AM

Have not followed the link, so if this is a repeat, please ignore.

click end/home and see where you end up. If it is nowhere near where you know where your data ends, start CAREFULLY deleting rows and columns till you get to where you now your data ends

**DangerNoodle** · 12-20-2019, 03:12 AM

i found i had a similar problem (plus the file size would blow out, deleteing blank rows would do nothing, etc) when using Control Shift Enter (Array formulas) very poorly, do you have anything like this in your sheets,this can also happen by applying a formula to a column, just because the result is blank it still refills them after you delete them.

you could try making a backup, then deleteing columns off the backup until you find the problem column.

CTRL+END seems to jump to K1048576

LinkBack

Thread Tools

Rate This Thread

Display

CTRL+END seems to jump to K1048576

Re: CTRL+END seems to jump to K1048576

Re: CTRL+END seems to jump to K1048576

Re: CTRL+END seems to jump to K1048576

Re: CTRL+END seems to jump to K1048576

Thread Information

Users Browsing this Thread

Similar Threads

How to set “Ctrl + F12” as excel shortcut for “jump to the next active sheet”, using macro

Disable Ctrl+A, Ctrl+C and Ctrl+V in Excel

[SOLVED] Ctrl + Down arrow, jump to end Macro

Disable cut,copy,paste(including ctrl x, ctrl c n ctrl v)

[SOLVED] Ctrl+pgup pgdn can't jump worksheets

Ctrl+pgup pgdn can't jump worksheets

[SOLVED] How do I "CTRL [" (jump to a precedent cell) from a European keybo

Bookmarks

Bookmarks

Posting Permissions