Excel thing that annoys me

%3CLINGO-SUB%20id%3D%22lingo-sub-2505626%22%20slang%3D%22en-US%22%3EExcel%20thing%20that%20annoys%20me%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2505626%22%20slang%3D%22en-US%22%3E%3CP%3EOK%20probably%20easy%20solved%2C%20but.%3C%2FP%3E%3CP%3EWhen%20I%20press%20enter%20the%20whole%20page%20moves%20not%20just%20the%20active%20cell%20location%2C%20and%20it%20annoys%20me.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3Eeg.%20so%20I%20am%20working%20on%20my%20spreadsheet%20and%20this%20is%20my%20current%20screen%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20screen%20shows%20columns%20A-%20R%2C%20rows%20165%20-198%3B%20So%20top%20left%20cell%20is%20A%20165.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20I%20have%20a%20simple%20sum%20formula%2C%20I%20want%20to%20place%20in%20cell%26nbsp%3B%20Q189.%26nbsp%3B%20Pretty%20simple%2C%20so%20I%20press%20enter%20and%20the%20page%20adjusts%20so%20that%20my%20top%20left%20cell%20is%20now%20H%20172.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20this%20have%20to%20happen.%26nbsp%3B%20Because%20every%20time%20I%20place%20a%20sum%20formula%20or%20sometimes%20a%20simple%20copy%20paste%20command%20the%20page%20adjusts%20it%20location.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20want%20it%20to%20stay%20put%20at%20top%20left%20cell%20A%20165.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHelp%20please%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2505626%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2505900%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20thing%20that%20annoys%20me%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2505900%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1092776%22%20target%3D%22_blank%22%3E%40JohnH120163%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20please%20add%20a%20file%20(without%20sensitive%20data)%20and%20explain%20your%20subject%20on%20the%20basis%20of%20this%20file.%3CBR%20%2F%3EWhy%20does%20the%20helper%20have%20to%20create%20a%20file%20for%20you%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAt%20the%20same%20time%2C%20knowing%20the%20Excel%20version%20(365%3F%2C%20Home%2C%20web%2CPro%3F%2C%20etc.)%20and%20the%20operating%20system%20is%20always%20an%20advantage.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20read%20the%20information%20on%20this%20link%2C%20you%20will%20help%20yourself%20and%20all%20of%20us%20here%20in%20the%20forum.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_self%22%3E%3CSPAN%3EWelcome%20to%20your%20Excel%20discussion%20room!%3C%2FSPAN%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2509112%22%20slang%3D%22en-US%22%3EBetreff%3A%20Excel%20thing%20that%20annoys%20me%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2509112%22%20slang%3D%22en-US%22%3EOK%2C%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20new%20Laptop%2C%20running%20windows%20Pro%2010%2C%20and%20office%20365.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

OK probably easy solved, but.

When I press enter the whole page moves not just the active cell location, and it annoys me.  

eg. so I am working on my spreadsheet and this is my current screen 

My screen shows columns A- R, rows 165 -198; So top left cell is A 165.

 

Now I have a simple sum formula, I want to place in cell  Q189.  Pretty simple, so I press enter and the page adjusts so that my top left cell is now H 172.

 

Does this have to happen.  Because every time I place a sum formula or sometimes a simple copy paste command the page adjusts it location.

 

I just want it to stay put at top left cell A 165.

 

Help please

 

3 Replies

@JohnH120163 

With your permission, please add a file (without sensitive data) and explain your subject on the basis of this file.
Why does the helper have to create a file for you?

 

At the same time, knowing the Excel version (365?, Home, web,Pro?, etc.) and the operating system is always an advantage.

 

Please read the information on this link, you will help yourself and all of us here in the forum.

Willkommen in Ihrem Excel-Diskussionsraum!

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

OK,

So new Laptop, running windows Pro 10, and office 365.

the thing is I often use excel as a worksheet to import reports and manipulate them. The report has a format, like reports do. But if every time I press a sum command or a copy/paste command the page adjusts, I then have to reset the page so that the data I'm reviewing is in front of me, not out of screen or slightly off screen.