Fixing Horizontal Scrolling Issues When Selecting Excel Columns

Hello, Copy and pasting cells and when I go to select a section of a column I click the first cell and press tab so that I can select the section of the column that I want to copy and instead of just allowing me to do that the whole page scrolls to the right or left, really annoying. What can I do so that the page doesn't scroll across the screen and loose the space my column is viewing on the screen ? Hope that makes sense, there's gotta be others that have experienced this and resolved it!