Hi "Carykiwi"

Both Ctrl+End and Ctrl+Shift+End works around the Used Range.

If you want to set this to say row 100 and still use Ctrl+End. Select the
rows 101 to 1700 and delete and save the workbook to reset the used range.

If this post helps click Yes
---------------
Jacob Skaria


"Carykiwi" wrote:

I have a spreadsheet about 50 rows but when I go CTRL end it goes to cell
1700! How do I make the final cell where I want it, at the end of the data?