Tired of seeing your Excel prints cut and chaotic? Follow the easiest way to print Excel and the complete guide from ApkVenue!
For those of you who often work with large amounts of data, you must have dealt with magical products Microsoft which name is Microsoft Excel.
Unlike other Microsoft products such as Microsoft WordUnfortunately, Excel is a bit difficult to use and there are a lot of complex techniques hidden in Excel, guys!
Well, to help those of you who are still in the learning process using Excel, here Jaka will help explain how to print excel easily!
The Easiest & Most Complete Way to Print Excel
Actually, how to print Excel simply by pressing shortcutsCtrl + P in keyboard but this method will only produce messy prints, gang!
If you want to confirm the data contained in the spreadsheet can be printed neatly, there are several steps you must do before printing.
Without further ado, here Jaka will explain how to print excel so as not to get cut off which you can easily follow!
Oh yes, as a side note, in this example Jaka uses the version Microsoft Excel 2016 affiliated with softwareMicrosoft Office 2016, gang.
Microsoft Corporation Office & Business Tools Apps DOWNLOAD How to Print Excel so it doesn't get cut off
Tired of seeing your data cut off when printed? That means you are still not very good at formatting your data in Excel, gang!
Here, Jaka will only discuss basic tips for processing data which includes how to print Excel without being cut off, gang.
- Step 1 - Press Ctrl + A to select all the data in the Sheet.
- On the menu Home, click option Format as Table and select the desired table type as a way to create an Excel table from existing data.
- Step 2 - Confirm the selection My table has headers checked and click the button OK.
- With a table format, you can sort the data according to the criteria you want, so first organize your data as needed, gang!
- Step 3 - To make sure no data is lost, set the column width by double click on the right column or use features Wrap Text.
Notes:
Feature Wrap Text will make the text use more than 1 line.
- In the main menu options, select menu Page Layout and click the icon Print Titles.
- Click the arrow in the options Rows to repeat at top and select the first row containing header from the table. Click button OK when finished.
Notes:
This step serves to ensure header appears as the top line on each printed sheet.
How to Print Excel So It's Not Small
Be careful when following how to print Excel all Sheet because this method can make the printouts have too small a character size, gang.
The solution is, you can choose specific columns and rows following the method that ApkVenue will discuss here, gang!
- Step 1 - Click and drag columns and rows that you want to print.
- In the main menu options, select menu Page Layout. Click icon Print Area in Toolbar and click option Set Print Area.
- Step 2 - To make sure your choice is correct, click on the arrow located in the Name Box and select Print_Area to view the selected columns and rows.
- If there is an error, click the icon Print Area and click option Clear Print Area to remove all selected rows and columns.
How to Print Excel to Full Paper
In order not to waste paper, you have to make sure that the print orientation you choose matches the data to be printed, gang!
For more details, see the steps on how to print Excel full the following paper from Jaka!
- Step 1 - Click Ctrl + P to enter the screen Print. You can also access this screen through options File in the main menu and click options Print.
- Step 2 - Select paper size, orientation, and margin which is desired. You can also make margin yourself if you have specific needs.
If your data is heavier in columns, use orientation Landscape and if it's heavier on the row, use orientation Portrait.
For how to print Excel so that it is not small, make sure that the No Scaling already selected at the bottom option.
Notes:
Choice Fit Sheet On One Page, Fit All Columns On One Page, and Fit All Rows On One Page can be used to insert all rows or all columns or all table contents into one page.
- For how to print Excel with titles, click options Page Setup and enter the column Headers/Footers.
- Choose from header available or click the button Custom Headers... to create your own title.
- Step 3 - Check the results of your settings on the screen Print Preview and click the icon Print to see the results of your hard work, gang!
That's a short grid how to print excel to fit from Jaka, gang. There are still deeper customizations that you can actually do!
Apart from how to print Excel that Jaka explained, also learn important formulas in Microsoft Excel that can be useful in your life, gang!
Also read articles about Excel or other interesting articles from Harish Fikri
