End of document
 

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?

End of document
 

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

"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?

End of document
 

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

€žSheeloo€� ezt Ã*rta:

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

"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?

End of document
 

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?