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.
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).
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
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!