| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert an Excel document to a Word Document | Setting up and Configuration of Excel | |||
| convert excel document to word document (not a picture) | Excel Discussion (Misc queries) | |||
| How to create a formatted 'readable' document based on Excel document? | Excel Discussion (Misc queries) | |||
| how do i rotate a document or print small document on envelope | New Users to Excel | |||
| Changing a Word Document to a CSV Formated Document | New Users to Excel | |||
Hybrid Mode
