Jun 30 2021 11:50 PM
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
Jul 01 2021 01:20 AM
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)
Jul 01 2021 04:22 PM
Jul 01 2021 04:27 PM