How to disable automatic movement of my view when I change something in the table
When I copy and paste a set of rows, or delete one, my display is moved to the right (with 85% zoom, my standard), at the end of the cells, this is hugely annoying as I have to do this several times in the spreadsheet.
Is there any solution?
Huge thanks!
teste.xlsx
Last edited by GmanJP; 01-26-2024 at 09:10 AM.
Which version of Excel? There is no 2020 version ... Is it 365?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
2019 pro plus
Yes, get rid of those merged cells. They are nothing but troubleIs there any solution?
In fact, you are right.
The problem is that I can't get rid of them at the moment, they are part of a much larger spreadsheet that integrates all the data.
You can see an example below, I have three rows of phase, neutral and ground, but anyway, I would like to know if there is any way to fix it without having to redo everything, as it is not an option.
Attachment 857252
That attachment comes up as invalid. I very much doubt you can change the behaviour your getting (without using VBA), it's one of the many problems with merging cells.
Ok, thanks!
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks