Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change the end cell (Ctrl end) in a excel spreadsheet?
I import data into an Excel spreadsheet.
If I go to the end of the spreasheet (by pressing CTRL End) I am on line 5,000 I then delete approx. 500 lines. The end of my data is now on line 4,500, but when I press CTRL End it still goes to line 5,000, but my totals are all on line 4,500, and there are 500 blank lines between the end of my data and the CTRL End point. Can I change the place where CTRL end takes me to? Many thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change the end cell (Ctrl end) in a excel spreadsheet?
If you just delete the data in the 500 rows, the last row will not be
reset. You need to use Edit | Delete | Entire Rows and this should reset the counter to 4,500. Pete |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change the end cell (Ctrl end) in a excel spreadsheet?
tusk, have a look here for the way to change the "last cell",
http://www.contextures.com/Unused -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "tusk" wrote in message ... I import data into an Excel spreadsheet. If I go to the end of the spreasheet (by pressing CTRL End) I am on line 5,000 I then delete approx. 500 lines. The end of my data is now on line 4,500, but when I press CTRL End it still goes to line 5,000, but my totals are all on line 4,500, and there are 500 blank lines between the end of my data and the CTRL End point. Can I change the place where CTRL end takes me to? Many thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamicly change spreadsheet tab names depending on cell value | Excel Discussion (Misc queries) | |||
How do I link a folder to a cell in an Excel spreadsheet | Excel Worksheet Functions | |||
Change individual cell heights/widths in Microsoft Excel 2000 like Microsoft Word | Excel Discussion (Misc queries) | |||
Excel will not change cell border colours | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions |