Is there a way to 'prevent' a worksheet from scrolling?

I have created a worksheet, but it will appear differently on users pc's based on their screen resolution. I would like to be able to only show the horizontal scrollbar if it is actually required because the user's screen resolution isn't high enough to show the whole screen.

I can turn the scrollbars off in the advanced settings, but this doesn't prevent the sheet from scrolling, is ther any way to achieve this if a specified number of columns can be viewed without the need to scroll and to then show the horizintal scrollbar if not?