Fixed Position of Cursor Cell When Typing Enter/CTRL+Down Arrow

[diderooy]

I've Googled for an hour and have not found the answer. I suspect there is a way to do what I want, but I'm not using the right vocabulary to find it. Apologies in advance.

• I have a large spreadsheet (120,000 rows) and am modifying one column of it.
• Each row is for a given person for a given year; some people show up only once, some people twenty times.
• Individuals are already sorted by name and then by year so that I can view a few individuals' tenures simultaneously.
• In the column I am modifying, most cells are empty; some cells (20% maybe) have Xs.
• I am manually replacing the Xs with typed notes, and don't think there's any formula I can apply to plug in the needed data for every X in the column.
• Some individuals have Xs for several years of their tenure, and I need to be able to see all of their Xs at once before I start making notes for that individual.
• I need to be able to see the rows without Xs in the column I'm working on, so I can't just hide blanks to save a bunch of space.

Obviously, this involves a lot of scrolling...I can see 3-7 individuals at a time, most of the time, and then have to scroll (being careful not to scroll too far).

Is there a way to fix the position of the cursor towards the top of the pane, so that when I hit Enter (or CTRL+Down Arrow to the next X) , instead of the cursor "moving" on my screen, the spreadsheet "moves up"? I'd like to keep my hands on the keyboard because it took me a few weeks to get through the first quarter of the spreadsheet.

Again, I'm sorry. This is probably a really easy problem to solve. Thank you for your assistance.

 

[Peter_SSs]

Another option would be to put your workbook into a 'Trusted Location' (you may possibly have to make a suitable Trusted Location first - if IT will allow you to).
Trusted Locations are also found in the Trust Center settings.