Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
last cell on a worksheet
When I do CTRL-END, my cursor moves to cell N65527; it should be N1000. There
is no data between these two cells. I have tried 'clear-all' to no avail. I have tried deletiing all the rows from 1000 to the end of the worksheet which also didn't work. I do have some conditional formats set in the seemingly empty cells between where my data stops (around 500 or so) and N1000, but nothing beyond. Any suggestions on how I can get the 'last cell' to be N1000? thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
last cell on a worksheet
Jan, you need to reset the used range, have a look here for a way to do it
From: http://www.contextures.com/xlfaqApp.html#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 "Jan Buckley" wrote in message ... When I do CTRL-END, my cursor moves to cell N65527; it should be N1000. There is no data between these two cells. I have tried 'clear-all' to no avail. I have tried deletiing all the rows from 1000 to the end of the worksheet which also didn't work. I do have some conditional formats set in the seemingly empty cells between where my data stops (around 500 or so) and N1000, but nothing beyond. Any suggestions on how I can get the 'last cell' to be N1000? thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
last cell on a worksheet
Paul,
The article suggests all the same remedies I've already tried - i.e. deleting columns, rows adjacent and below my data. I tried them all again to no avail. Any other suggestions? "Paul B" wrote: Jan, you need to reset the used range, have a look here for a way to do it From: http://www.contextures.com/xlfaqApp.html#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 "Jan Buckley" wrote in message ... When I do CTRL-END, my cursor moves to cell N65527; it should be N1000. There is no data between these two cells. I have tried 'clear-all' to no avail. I have tried deletiing all the rows from 1000 to the end of the worksheet which also didn't work. I do have some conditional formats set in the seemingly empty cells between where my data stops (around 500 or so) and N1000, but nothing beyond. Any suggestions on how I can get the 'last cell' to be N1000? thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
last cell on a worksheet
Jan
You must save the file after deleting all the excess rows and columns. In some versions you have to save the file, close the file, and open the file. HTH Otto "Jan Buckley" wrote in message ... Paul, The article suggests all the same remedies I've already tried - i.e. deleting columns, rows adjacent and below my data. I tried them all again to no avail. Any other suggestions? "Paul B" wrote: Jan, you need to reset the used range, have a look here for a way to do it From: http://www.contextures.com/xlfaqApp.html#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 "Jan Buckley" wrote in message ... When I do CTRL-END, my cursor moves to cell N65527; it should be N1000. There is no data between these two cells. I have tried 'clear-all' to no avail. I have tried deletiing all the rows from 1000 to the end of the worksheet which also didn't work. I do have some conditional formats set in the seemingly empty cells between where my data stops (around 500 or so) and N1000, but nothing beyond. Any suggestions on how I can get the 'last cell' to be N1000? thanks. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
last cell on a worksheet
Did you try to code solution? I've tested that and it works. Although the
delete excess stuff and close and reopen generally works. "Jan Buckley" wrote: Paul, The article suggests all the same remedies I've already tried - i.e. deleting columns, rows adjacent and below my data. I tried them all again to no avail. Any other suggestions? "Paul B" wrote: Jan, you need to reset the used range, have a look here for a way to do it From: http://www.contextures.com/xlfaqApp.html#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 "Jan Buckley" wrote in message ... When I do CTRL-END, my cursor moves to cell N65527; it should be N1000. There is no data between these two cells. I have tried 'clear-all' to no avail. I have tried deletiing all the rows from 1000 to the end of the worksheet which also didn't work. I do have some conditional formats set in the seemingly empty cells between where my data stops (around 500 or so) and N1000, but nothing beyond. Any suggestions on how I can get the 'last cell' to be N1000? thanks. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
last cell on a worksheet
Just needed to save the file, close and reopen! Thanks, Otto and JLatham.
"Otto Moehrbach" wrote: Jan You must save the file after deleting all the excess rows and columns. In some versions you have to save the file, close the file, and open the file. HTH Otto "Jan Buckley" wrote in message ... Paul, The article suggests all the same remedies I've already tried - i.e. deleting columns, rows adjacent and below my data. I tried them all again to no avail. Any other suggestions? "Paul B" wrote: Jan, you need to reset the used range, have a look here for a way to do it From: http://www.contextures.com/xlfaqApp.html#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 "Jan Buckley" wrote in message ... When I do CTRL-END, my cursor moves to cell N65527; it should be N1000. There is no data between these two cells. I have tried 'clear-all' to no avail. I have tried deletiing all the rows from 1000 to the end of the worksheet which also didn't work. I do have some conditional formats set in the seemingly empty cells between where my data stops (around 500 or so) and N1000, but nothing beyond. Any suggestions on how I can get the 'last cell' to be N1000? thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How:Add New Worksheet that copies the cell of the previous sheet | Excel Worksheet Functions | |||
How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
fill cell with color from other worksheet | Excel Discussion (Misc queries) | |||
Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions |