First post, hopefully this question is allowed here. I'm making a spreadsheet of my products I work with (1000-1500 items) and how often they're distributed to create some averages to help with ordering.
I've set my column on the left to scroll to the right and the header column to scroll down. I search through the items using "find and replace" but when I type in a word to search for it kicks me back to the left and I have to scroll right again. Since this will be covering a years time with a column for each week of the year I'm hoping to stop this from happening.