Test Your Worksheet on Different Screen Resolutions

Excel Spreadsheets

One of the most common (and annoying) problems when working out a spreadsheet is screen resolution. For example, our monitor has 1920 × 1200 resolution and is perfect on our monitor. However, if opened on a computer that has the 800 × 600 resolution, much of the information will not be displayed on the screen, and a scroll will be created at the bottom of the screen. Nothing more annoying than filling in data and having to keep manipulating a scroll.

It is like operating a computer the crank, every time you have to stop your work to scrolland display the missing part. And irritation is not just a problem. In addition to increasing the stress of your employee, it will probably require much more time and energy to accomplish the filling of the table. Yield can even drop by half.

Fortunately, there is a solution to eliminate this problem: a gagdet called ASAP. With this gagdet, you can test and create spreadsheets at any resolution. See how easy it is to test the preview for other users:

Adapting your worksheet in different screen resolutions

First you must download the ASAP gagdet. It is a tool full of utilities for anyone who works with Excel. The program has a free version, which can be downloaded through this link. If you like it a lot, you can use the paid version for only $ 49,00.

Perform the installation and be careful to choose the student version. For our task of testing and creating tables and various resolutions, the free version is sufficient.

Now, open the worksheet you want to test. Note that a menu called ASAP Utilities was created, as highlighted in figure 1 below. This menu will give you many functions that will make your day-to-day life easier.

Test Your Worksheet on Different 1 Screen Resolutions

But since what matters to us now is to test and create the table in various resolutions, let's stick to that. Click the menu ASAP Utilities. Now click on the File & System. Now, click on the Resize the Excel window to standard screen resolutions ... (as shown in figure 2).

Test Your Worksheet on Different 2 Screen Resolutions

A window will appear in which you can adapt your table to any resolution. To do this, click on the field Resize the window to the follow resolution. You will be presented with many resolution options, so now choose which option you want to test as shown in Figure 3. Once this is done, click Ok

Test Your Worksheet on Different 3 Screen Resolutions

Ready! Your table is now displayed at the resolution you want. Test in all the options you want. You can even assemble your table based on the selected resolution and make the necessary adjustments. You can also create multiple models according to your PC's resolution. So your team can use the spreadsheet that best fits it. Doing this test, believe me, it will save you and your team a lot of time.

And you, have any questions about how to use this application? Tell us in the comments section below!

Excel Spreadsheets
previous articleWhen is CLT Applicable?
Next article5 Ways to Use Sheets in Google Sheets
Administrator and turismologist, passionate about the possibilities that Excel gives to managers, entrepreneurs and students. He is the managing partner of the spreadsheet department at LUZ - Spreadsheets (luz.vc) and is responsible for the development of spreadsheets with business and personal focus commercialized in its website. He also teaches online Excel courses (cursos.luz.vc) and likes to help thousands of planners through the LUZ Forum and Blog.


  1. Good afternoon, in that case would it also work if it were the same file for several different resolution computers? Here's what happens: We have a worksheet where it's opened on other computers and the resolution always changes. On my pc I format it one way and the other computers always get messy!


Please, write your comment
Please enter your name