just curious

[greg kramer]

so if you hit cntrl home you go to cell a1.

how would one change that such that if you hit cntrl home you might go somewhere else like say, a5.

saw that done somewhere & wondered how the heck they did that.

Thanks!

 

[Peter_SSs]

The sheet possibly had Frozen Panes.

Select A5 then Freeze Panes (View ribbon tab in Excel 2007+ or Window menu in Excel 2003-)
Now scroll well down and across and select a cell
Ctrl+Home

 

[Hermanito]

Another possibility is that they had a scroll-area defined for that worksheet.
You can only do this in the VBE editor:

rightclick the sheet tab, and select View Code
check the Properties window (press F4 if you don't see a Properties window) for ScrollArea
If there is a range in there, you cannot navigate to cells outside that range in that worksheet

 

[Peter_SSs]

Another possibility is that they had a scroll-area defined for that worksheet.
You can only do this in the VBE editor:

rightclick the sheet tab, and select View Code
check the Properties window (press F4 if you don't see a Properties window) for ScrollArea
If there is a range in there, you cannot navigate to cells outside that range in that worksheet

But Ctrl+Home doesn't take you to the top left (or anywhere) in this circumstance does it?

 

[Hermanito]

hmm, strange...

you are totally right Peter, a lot of the navigational keyboard stuff doesn't work anymore with ScrollArea set... at least in 2007, can't test other versions right now...

 

[greg kramer]

maybe it was just simply freezing panes. although for some reason i thought it was more sophisticated than that.

maybe it was a scroll-area defined for that worksheet.

however, either way, it answered my question. there is no trick to do this that everyone in excel-world knows except me

thanks for the replies!