Alter Spreadsheet Resolution For Free

Note: you can also use Control + mouse scroll wheel to zoom in and out on both Windows and Mac. On Windows, the shortcut appears to be new with Excel 2016, and decreases the zoom level shown in the lower right of the worksheet by 15% each time Control - is used. Use Ctrl Alt + to zoom out by 15%.

To change your screen resolution. Open Screen Resolution by clicking the Start button , clicking Control Panel, and then, under Appearance and Personalization, clicking Adjust screen resolution. Click the drop-down list next to Resolution, move the slider to the resolution you want, and then click Apply.

To change the default resolution to high fidelity in Word or Excel (version 2016 or newer): Click File > Options > Advanced. Under Image Size and Quality, select High fidelity in the Default resolution list.

Click the worksheet for which you want to change the print resolution.On the Page Layout tab, in the Page Setup group, click the Launcher .On the Page tab, in the Print quality box, click the resolution that you want to use. Note: The dpi settings that are available depend on the type of printer that you are using.

Scale your Excel spreadsheet to fit your screenSelect one row of cells from the spreadsheet range you want to see (e.g. from A4 to H4.Choose View, Zoom, then select Fit Selection.Click OK.

It sounds like Protect Workbook - Protect Windows is enabled. Have a look at the Review tab to see if the button is pressed in or go to Tools> Protection in the menu to see if Unprotect Workbook is listed.

Scale a worksheetClick the Page Layout tab on the ribbon.In the Scale to Fit group, in the Width box, select 1 page, and in the Height box, select Automatic.To print your worksheet, press CTRL+P to open the Print dialog box, and then click OK.