Hi Excel gurus
I will try to explain what I'm trying to achieve as much as possible, I hope this will be clear.
There is a form, where on my 27' screen (full hd resolution) I have centered my sheet to show a nice table that is located in column M4 so it looks nice and neat.
Simply I have same lenght from the left to the left border and the same size from the right border to the right.
Now the problem is that if you open the spreadsheet on another pc that has different screen size this is not centered anymore, obviously.
I've been thinking... you know how you can center a userforms and regardless to the screen size or resolution these are always centered?
Could we not ask excel to always display M column at the specific place? lets say centered? to achieve we could change the sizes of columns A:L so M can finds it's place?
So I'm more like looking for this:
Read how many columns is visible on the screen, read their sizes (lengths) and adjust these so M shows on the middle all the time.
Then I will be able to insert my table somewhere at L or K to center it on the screen.
Is this possible? lol
Bookmarks