As a successful Microsoft product, Excel is difficult to use because it hides many complex techniques. One of them is how to print Excel so that it is neat, the lines are not lost and the paper is full.
The reason is that when we want to print a Microsoft Excel document, sometimes there are parts of the line that are missing and cut off so that only part of the written document is printed.
Actually, how to print Excel just by pressing the shortcut Ctrl + P on the keyboard. However, this method will only produce messy prints, gang!
So how to fix it? Here Jaka introduces how to print Excel so that the lines don't disappear. He can set the paper size, paper orientation and set the printing area according to his needs.
How to print excel so it doesn't get cut off
Tired of seeing your data truncated when printed? Here, Jaka will discuss basic data processing tips including how to print Excel without getting cut off, gang. Come on, look!
Make sure your device is connected to the printer.
Prepare the Excel document that you want to print.
Press Ctrl + A to select all the data present on the Sheet.
On the Start menu, click Format as Table and select the desired table type.
Make sure the My table has headers option is checked and click the OK button.
To ensure no data is lost, adjust the column width by double-clicking in the right column or by using the Wrap Text feature.
Set the margins with CTRL + P > Landscape/Portrait > Custom Margins.
Under Page Settings, check Horizontally and Vertically in the Center on Page setting.
Click OK > Print.
For information, Excel can only print up to data number 49. The rest, the data will be printed on new paper. If you want to print all rows on one sheet of paper, click No Scaling and select Scaling Fit all rows on one page.
How to print excel so it's not small
For those of you who have problems printing Microsoft Excel sheets online, the results are small, the cause could be that the scale value used is less than 100%, so the print results are smaller.
How to solve small prints in Microsoft Excel (2007, 2010, 2013, 2016)? The steps to overcome so that the Excel prints do not remain small and return to normal sizes are the following:
Open your Excel spreadsheet.
Page Layout menu > set the scale value to 100% to return the print to normal.
If the above method doesn't work 100%, you can try another way to make the print not small. You can choose specific columns and rows by following the method that ApkVenue will discuss here, gang!
Click and drag the columns and rows you want to print.
Click Page Layout menu > Print Area > Set Print Area.
To make sure your selection is correct, click the arrow in the name box.
Select Print Area to see the selected columns and rows.
If there are errors, click the Print Area icon > Clear Print Area to clear all rows and columns that have been selected.
How to print Excel to full paper
In order not to waste paper, you need to make sure that the print orientation you choose matches the data that will be printed, gang!
For more details, please refer to the steps on how to print the entire Excel document below from Jaka.
Open your Excel spreadsheet.
Click Ctrl + P to enter the Print screen.
Select the desired paper size, orientation, and margins.
If the data is heavier in the columns, use the Landscape orientation and if it is heavier in the rows, use the Portrait orientation.
Make sure the No Scale option is selected in the bottom option.
To print Excel with titles, click the Page Setup > Header/Footer option.
Choose from existing headers or click the Custom Header... button to create your own title.
Check the settings on the Print Preview screen and click the Print icon.
The Fit Sheet On One Page, Fit All Columns On One Page, and Fit All Rows On One Page options can be used to insert all rows or all columns or all table contents into one page.
How to set margins and print an Excel document
Margins define the border between the text and the edge of the paper. Like margins in Microsoft Word, margins in Microsoft Excel consist of left (left), top (top), right (right), and bottom (bottom) margins.
Well, the margins feature determines how sharp the document will print. So how to set margins before printing an Excel document? Come on, look below!
Prepare the Microsoft Excel file that you want to print.
Click the Page Layout menu > Click the arrow in the lower right corner > Page Setup.
Set the paper size. Choose Legal size only.
Select or block all the areas you want to print.
Click Page Layout again > Print Area > Set Print Area.
Click Print menu > Print Preview to preview your document before printing.
Select Show Margin > Adjust Margin by dragging the dotted line on the border.
If appropriate, click Print.
In the Printer Properties settings, select the paper settings you want to use. For example, A4 or Legal size.
Ultimate Excel Tips Collection
The latest tutorials and tips on Excel are a must have for those who like to process data. The reason is that Excel has a number of support functions to complete all these tasks, one of which is tables.
Presenting data in tabular form is mandatory so that the data looks neat and easy to understand and analyze. For those who don't know, here Jaka introduces how to create a table in Excel along with a collection of the latest Excel 2022 tips.
the last word
This is a quick guide on how to print in Excel so that your documents are neat, not cut and fit on all types of paper, be it A3, A4 or small sizes.
In addition to how to print Excel explained by Jaka, also learn important formulas in Microsoft Excel that can be useful in your life, gang!