Stop Excel from auto-scrolling to active cell when changing

**jrainbow** · 11-08-2012, 02:22 PM

I've created a spreadsheet and I want to be able to arrow down to the next cell without the spreadsheet scrolling back up to that cell. Is this possible?

**tlafferty** · 11-08-2012, 08:26 PM

I'm not sure what you mean by "scrolling back up to that cell," but I'd suggest trying the scroll lock key on your keyboard...

**Medpack** · 11-08-2012, 08:37 PM

What he means is - if the cell is not in your current view, and you invoke Cells.Select, it will move your display window to incorporate that item in your view.

The better idea here is - why do you need to select a cell that you can't see? If you need the value of a cell, rather than grabbing it from selection, just use Cell(row, column).Value to pull it.

**tlafferty** · 11-09-2012, 03:40 PM

Medpack is correct - it's always best to avoid selecting a cell unless it's absolutely necessary. It's inefficient, and unless your code has some good built in error trapping, it's easy to lose track of which cell is active/selected. As Medpack pointed out, if you select a cell and then take its value, you've taken two steps, when you could simply refer to the range in any one of several ways with .Value at the end of your reference.

**Caddyshack** · 11-26-2019, 10:21 AM

Hi, I'd like an answer to the original question as well. scenario: I'm currently viewing two pages side-by-side but not synchronized scrolling. I've clicked in cell A1 on left page (LP) and then scrolled down to cell A608 but did not make any cell near it active. Then I click on the right page (RP) so that i can scroll down or up to what i need to see there. When i click back onto LP, it will have "auto-scrolled" or "snapped back" to the active cell, which is A1. Is there a way to turn off this "feature"?

**FDibbins** · 11-27-2019, 01:27 AM

Originally Posted by Caddyshack

Hi, I'd like an answer to the original question as well. scenario: I'm currently viewing two pages side-by-side but not synchronized scrolling. I've clicked in cell A1 on left page (LP) and then scrolled down to cell A608 but did not make any cell near it active. Then I click on the right page (RP) so that i can scroll down or up to what i need to see there. When i click back onto LP, it will have "auto-scrolled" or "snapped back" to the active cell, which is A1. Is there a way to turn off this "feature"?

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread