Ctr Key + ? to reset excel sheet to start

**bnwash** · 12-09-2014, 06:15 AM

Hi,
My excel sheet is large and data entry takes the cursor to AZ range and beyond and
as far down as 2000
What I was looking for is perhaps a Control key + so the sheet would reset to the top Rows 1 - 24 across to Col O
It would save a great deal of time to be able to press perhaps a ctr+ or is there a better way.
A button would not work unless it floated with the work book movement
Any suggestions ?

**Sam Capricci** · 12-09-2014, 06:21 AM

control and the up, down or left or right arrows will get you to the next spot where there is a break in the data. So if you have solid data from A1 to AZ2000 and you are in cell AZ2000, hold down control and hit the up arrow and you'll go to AZ1, then hit control and left arrow and you'll go to A1. Other way is just plug in A1 in the box beside the function area and enter and it'll take you right there.

**FlameRetired** · 12-09-2014, 06:26 AM

Ctrl + Home works well, too. Takes you to A1.

**bnwash** · 12-09-2014, 04:53 PM

Sambo Kid
What do you mean by "Other way is just plug in A1 in the box beside the function area and enter and it'll take you there"

**bnwash** · 12-10-2014, 12:23 AM

If anyone out there has a better solution it would be appreciated trying to return to the start area each time is driving me crazy

**kbryant414** · 12-10-2014, 12:51 AM

As FlameRetired said, the easiest way is Ctrl + Home

To explain what Sambo Kid meant, though: when you click on any cell, in the upper left, you see the address of the cell. It's to the left of the formula bar. You can click there, and type any cell or range you would like to select.

If you're using VBA macros to input data, you can add this line at the end of the macro to return to A1:

Application.Goto Range("A1"), 1

**bnwash** · 12-10-2014, 02:04 AM

Thanks I will try that
Appreciate the assistance

**Sam Capricci** · 12-10-2014, 06:26 AM

in the "box" to the left of fx where you would see your formula, if for example you are in cell x2000 it will list that as the address in that box. Put your cursor in that box and type in A1 then hit enter and that is where you will go immediately. In fact if you are in A1 and type in AX55000, then hit enter that is where you will go. It shows the cell address where you are or can take you to the address where you want to go to. Easy.