finding the "end"
I'm creating a high school directory using Excel 2002. Once in a while I
will get typing a little too fast and turn off Num Lock and then I end up in the wrong cell. I'd like to be able to return to the last line in the table; I thought Ctrl-End would take me there, because Ctrl-Home always takes me to A1. But even though the last entered line is (currently) 243, Ctrl-End takes me to 10098. Help! Julia |
Visit Debra Dalgleish's site for some techniques for resetting that
lastusedcell. http://www.contextures.com/xlfaqApp.html#Unused Julia wrote: I'm creating a high school directory using Excel 2002. Once in a while I will get typing a little too fast and turn off Num Lock and then I end up in the wrong cell. I'd like to be able to return to the last line in the table; I thought Ctrl-End would take me there, because Ctrl-Home always takes me to A1. But even though the last entered line is (currently) 243, Ctrl-End takes me to 10098. Help! Julia -- Dave Peterson |
Thank you! That worked.
Julia "Dave Peterson" wrote in message ... Visit Debra Dalgleish's site for some techniques for resetting that lastusedcell. http://www.contextures.com/xlfaqApp.html#Unused Julia wrote: I'm creating a high school directory using Excel 2002. Once in a while I will get typing a little too fast and turn off Num Lock and then I end up in the wrong cell. I'd like to be able to return to the last line in the table; I thought Ctrl-End would take me there, because Ctrl-Home always takes me to A1. But even though the last entered line is (currently) 243, Ctrl-End takes me to 10098. Help! Julia -- Dave Peterson |
All times are GMT +1. The time now is 11:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com