End of document

[Carykiwi]

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?

 

[Sheeloo]

Select the first blank row by clicking on the row number (Row 51?)
Press SHIFT-CTRL-END
this will select the rows upto you end of doc
Right-click and choose delete
This should reset your end of doc

 

[Stefi]

Only after saving the new state of the workbook!
Regards,
Stefi

„Sheeloo†ezt írta:

 

[Jacob Skaria]

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