ctrl+end in Excel

[bj6264]

Hello, can someone help please? If I use ctrl+ end on one of my spreadsheets, the cursor goes all the way to the bottom ie row 1048576 and to the last column I have used. I only have about 50 rows on this spreadsheet. Is there a way I can ensure that ctrl+ end only goes to the furthest populated row? Thanks.

 

[saltkev]

Hi

Delete All the unsed rows after your last row, they will re-esablish themselves. Then save. Ctrl End should work then.


Kev

 

[bj6264]

Hi Kev, I had tried this but it didn't work but it worked this time! many thanks. B