Ctrl+End goes beyond Data

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• May 9, 2011

• #2

Try using ASAP Utilities to reset the last cell http://www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=41&utilities=20&lang=en_us

 

Upvote 0

Peter_SSs

MrExcel MVP, Moderator

Joined

May 28, 2005

Messages

63,880

Office Version

1. 365

Platform

1. Windows

• May 9, 2011

• #3

If you are sure the extra columns contain nothing (not even formatting) then try saving the file and then try Ctrl+End again.

If it is possible that there is something (eg formatting) lurking somewhere in those extra columns and you don't need them then try deleting them, saving the file and try again.

 

Upvote 0

Sektor

Well-known Member

Joined

May 6, 2011

Messages

2,878

Office Version

1. 365

Platform

1. Windows

• May 9, 2011

• #4

This is because Excel treats cells with deleted formatting as existing.
To get rid of these "extra" cells, do the following:
1. Press Alt+F11.
2. Press Ctrl+G.
3. Type: ActiveSheet.UsedRange
4. Press Enter.
5. Save workbook.

 

Upvote 0

smithgt

Board Regular

Joined

Jan 22, 2010

Messages

193

• May 9, 2011

• #5

Thanks - thats worked.

 

Upvote 0

D

dleeper47

New Member

Joined

Jul 1, 2014

Messages

1

• Jul 1, 2014

• #6

smithgt said:

Hi,

How can I reset where Excel thinks the end of may data is?

When I press Ctrl+End it highlishts column ANC when really my data now finished at Column AC

thanks

Click to expand...

I had this problem and couldn't seem to clear it. A simple fix was to open a new sheet, copy just the material that was "in range" to that new sheet, confirm the new sheet had all the data I wanted and the right format, and then delete the old sheet with the problem.

 

Upvote 0

I

itsmekarak

New Member

Joined

Sep 29, 2014

Messages

30

• Jun 17, 2015

• #7

This is an old post, but it worked. Thank you for your help!!!

Does this work for all excel workbooks on this pc from here on out or do I need to do this for each? I download a lot of reports that make this an ongoing issue. Thank you!

 

Last edited: Jun 17, 2015

Upvote 0