Find the end of data

AllenL · Apr 24th, 2002, 06:49 AM

I am wondering is there a way to go to the last row of the data with keyborad? so I don't have to use the scrollbar to find the end of my data
Thanks in advance

Audiojoe · Apr 24th, 2002, 06:52 AM

Yeah press CTRL and the right arrow key, or left depending on which way you want to go. This also works for up and down

Audiojoe

AllenL · Apr 24th, 2002, 07:03 AM

Nice
Thanks a lot

gareth · Apr 24th, 2002, 07:47 AM

Ctrl+dwn

nisht · Apr 24th, 2002, 08:00 AM

Try this,,

press end and arrow keys..

if you want to use mouse.. then skid..

double click on the thick selection border (on you see when cell is selected.) and you will see that you are on the end of the data
nishith desai
http://www.pexcel.com

Iain Lewis · Apr 24th, 2002, 08:18 AM

or you could do :

F5 then Alt + S followed by S

this will take you straight to the last used cell using Goto, special

Apr 24th, 2002, 07:47 AM	#4
gareth Board Regular Join Date: Apr 2002 Location: Cape Town,South Africa Posts: 234	Ctrl+dwn __________________ Regards Gareth Visit The Excel Maniacs :<>: Have a Chat! :<>: Free Stuff!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 06:49 AM	#1
AllenL Board Regular Join Date: Mar 2002 Posts: 67	I am wondering is there a way to go to the last row of the data with keyborad? so I don't have to use the scrollbar to find the end of my data Thanks in advance

Apr 24th, 2002, 06:52 AM	#2
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Yeah press CTRL and the right arrow key, or left depending on which way you want to go. This also works for up and down Audiojoe

Apr 24th, 2002, 07:03 AM	#3
AllenL Board Regular Join Date: Mar 2002 Posts: 67	Nice Thanks a lot

Apr 24th, 2002, 08:00 AM	#5
nisht Board Regular Join Date: Feb 2002 Location: Ahmedabad Gujarat Posts: 303	Try this,, press end and arrow keys.. if you want to use mouse.. then skid.. double click on the thick selection border (on you see when cell is selected.) and you will see that you are on the end of the data nishith desai http://www.pexcel.com

Apr 24th, 2002, 08:18 AM	#6
Iain Lewis Board Regular Join Date: Apr 2002 Location: Midlands, UK Posts: 217	or you could do : F5 then Alt + S followed by S this will take you straight to the last used cell using Goto, special