Ctrl+End goes beyond Data

[smithgt]

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

 

[VoG]

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

 

[Peter_SSs]

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.

 

[Sektor]

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.

 

[smithgt]

Thanks - thats worked.

 

[dleeper47]

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

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.

 

[itsmekarak]

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!