When you try to print a Excel, the dimensions of the document never match those of the paper on which you have to print it? You're not the only one who happens to be quiet, but luckily Excel includes a function that allows you to easily optimize your spreadsheets for printing.
Follow the directions I am about to give you and in no time you will learn how to adapt an excel sheet on all major software platforms: Windows, macOS and mobile device operating systems. For the tutorial I will use Office 2016, which is the most recent version of the Microsoft suite and is available for both Windows and macOS, but the instructions below are valid for all the most recent editions of Microsoft Office, let's say from 2007 onwards.
As for smartphones and tablets, Microsoft Excel is available for free on all devices that have dimensions equal to or less than 10.1 "and includes many of the features also present in the desktop version of the application. The printing functions are not as detailed and varied as those present in Excel for Windows and macOS, but you can't complain. Read on and you'll find out everything.
Adapt an Excel Sheet on PC and Mac
Be vuoi scoprire how to adapt an excel sheet, the first step you have to take is to activate the print view by clicking on the button Layout on the pagina located in the lower right corner (the second button located to the left of the zoom adjustment bar).
Now select the tab Layout on the pagina from the Excel toolbar (top), expand the drop-down menu Width and set the option 1 page in this last. By doing so, the spreadsheet will be optimized to be printed on A4 size sheets in the wide part. In height, the document will be automatically split into multiple pages based on its length (i.e. based on the number of lines it contains).
If you want, you can disable automatic document splitting across multiple pages by setting the value 1 page in the drop-down menu Height. By doing this, you will be able to merge all the content of the document into a single A4 sheet but, beware, the spreadsheet will almost certainly appear deformed when printing.
To make sure that the final result is satisfactory, before starting to print your Excel document, select the item Print from the menu Fillet and check that everything is in order in the print preview.
If you notice any errors in the margins or proportions of the document to be printed, access the advanced printing properties by clicking on the button Fillet Excel (top left), by selecting the item Print from the menu that opens and clicking on the item Set page located at the bottom of the left sidebar. If you are using a Mac, to access the advanced printing properties, go to the menu Fillet Excel (top left) and select the item Set page from the latter.
In the window that opens, select the tab Page and choose whether to print the document pages in horizontal o vertical putting the check mark next to one of the two available options and choose the format of sheet on which to print the spreadsheet (eg. A4) from the appropriate drop-down menu.
Then switch to the tab Edges and use the text fields around the document page thumbnail to set the margin thickness top, lower, right, left, of heading and footer.
Finally, select the tab Sheet and, if you deem it appropriate, activate one of the print options available at the bottom left: Grid, Bianco e nero, Draft quality o row and column headers.
After adjusting all the settings of your preference, go back to the Excel print menu, check the print preview again and, if you are satisfied with what you see, start printing your spreadsheet by pressing the appropriate button.
Do you want to adapt an Excel sheet so that the size of the columns and rows match their content? No problem, this is an extremely simple and intuitive operation.
If you want to adapt the Excel cells to the length or height of their content, select the cells to be optimized with the mouse, click on the button Format located at the top right of the tab Home Excel (top right) and select the item Fit Column Width or the voice Fit row height give the menu to compare.
There is also a way to set all cells in the spreadsheet to be the same size. All you have to do is select all the cells in the worksheet by clicking on the little triangle which is at the top left (between the indicators A e 1), click on Format located on the tab Home Excel and select the item Default width from the menu that opens. Then type the size you want to make all the cells of the worksheet assume in the window that opens and click on OK per salvare i Cambiomenti.
For more information on the procedure for adapting Excel cells to the content, consult my tutorial dedicated to the subject: there you will find all the steps necessary to optimize the rows and columns of the spreadsheets so that they adhere perfectly to the cell contents .
For further information, you can also visit the Microsoft Office website which includes various indications on how to adapt an Excel sheet when printing.
Adapt an Excel Spreadsheet on Smartphones and Tablets
Come già accennato in opening of the post, Microsoft Excel is also available as an app for Android, iOS and Windows Phone and is free for all devices that are 10.1 "or smaller (otherwise a subscription to the Office 365 service is required). To use it you need a normal free Microsoft account.
The mobile version of Excel includes many functions present in the desktop version of the program (except the most advanced ones), and among these there are also functions to change the aspect ratio and the size of the sheets to be printed. If you've never noticed it, now I'll explain how to access it.
First, start Excel on your smartphone or tablet and open the spreadsheet you want to print (you can open a file from the internal memory of your device or from a cloud storage service, such as dropbox, iCloud Drive o Google Drive). With the document loaded, "tap" on the icon sheet located at the top left, select the command print from the menu that appears and choose one of the printing technologies (eg. AirPrint on iOS) from the box that appears on the screen.
At this point, choose whether to print the document in horizontal o vertical placing the check mark next to one of the two available options, choose the format of the sheet on which to print the document via the menu Paper size i went his Resizing to choose whether to resize the spreadsheet to fit it on one page, fit all lines on a page o fit all columns on a page.
Finally, "tap" the button Following, check the print preview and, if you are satisfied with it, confirm the printing of your Excel file by pressing the appropriate button.
Mobile versions of Excel also allow you to adapt spreadsheet cells to their content. To take advantage of this function, select the cells to edit, "tap" the button Cell size format (the blue cell) present in the card Home of the app and select the option Fit Column Width or the option Fit row height give the menu check if you press.
If you act as a smartphone, in order to view the card Home of Excel and consequently the button Cell size format, you have to press the icon of pencil located at the top right and activate the tab Home from the drop-down menu that appears at the bottom left. After that you have to scroll through the menu that opens and go up first Cell size format and then Fit Column Width or the option Fit row height. Easy, right?
If any step is not clear to you and / or you want more information on the procedure to adapt the Excel cells to the content, consult the tutorial I wrote on the subject.
Adapt an Online Excel Sheet
As you most likely already know, Excel is also available in an online version that works directly from the browser and is completely free (just log in with a Microsoft account to use it), which includes many features of the desktop version of the application but not, unfortunately, those related to the print settings that I dealt with in this tutorial. Of course, you can adjust some print settings by acting directly from the browser menu, but it's not the same thing.
Instead, it is possible to take advantage of Excel Online to adapt the spreadsheet cells to their content, and the procedure to follow is practically identical to that which can also be followed in the desktop version of Excel: just locate the column that contains the cells to resize and double click on the outer margin of the indicator of the latter (ex. A for column A).
Instead, right-click on rows and columns and select items Column width o Row height from the menu that opens it is possible to specify exact dimensions for columns and rows of the spreadsheet. For further information you can always refer to my tutorial on how to adapt Excel cells to the content.