Find the end of data

AllenL

Board Regular
Joined
Mar 14, 2002
Messages
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
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
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
 
Upvote 0
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
ni****h desai
http://www.pexcel.com
 
Upvote 0
or you could do :

F5 then Alt + S followed by S

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

Forum statistics

Threads
1,213,494
Messages
6,113,981
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top