Microsoft Excel is an office application that makes calculation work simpler, especially for accountants. During use, you should grasp and master the shortcut in excel for better use. Excel supports you a lot in printing a payroll, calculating jobs with many trigonometric functions and math to reduce operations and calculation time. Printing Excel is a way for us to create a math problem, payroll more quickly and logically
How to print in Excel 2019, 2016, 2013, 2010, 2007, 2003
INSTRUCTIONS FOR PRINTING IN EXCEL
1. How to print in Excel 2010 and 2007
Because the Excel interface of both versions is quite similar, especially the same print feature, the instructions below will be used on Excel 2010 but those who use the 2007 version can follow.
Step 1: To get to the print section in Excel we need to click File on the menu bar.
Step 2: File menu interface appears, to print in Excel 2010 we just need to click Print section, here are full of items you can choose from, like:
– Printer: Select the printer.
– Printer properties: Select advanced options for the printer.
– Print Active Sheets: Select sheets to print individually or on purpose.
– Print One Sided: Select printing mode, single or side.
– Collated: Print in the preset order.
– Portrai Orientation: Horizontal or vertical printing, the default is vertical printing.
– A4: Select a paper size to print.
– Normal Margins: Align the text before printing.
– No Scaling: Choose to zoom in and out when printing in Excel.
Also in Printer properties We can set many more parameters. However, this is a printer specification, and each printer type will have different settings. Therefore to set up in this you also need to understand a little about the printer.
Or not, we have another choice Page Setup Located at the bottom, here you will adjust some functions that right outside already.
From paper sizes to detailed indents, of course the outside printing has provided you with all these tools.
2. Print Excel in Ofice 2003
Step 1: On the Menu bar, select File => Frint to open excel print window
Step 2: Click on Properties to set the text before printing
Step 3: In the card Layout, you have the following settings:
– Portrait: Rotate the portrait paper size when printing
– Landscape: Rotate the paper width horizontally when printing
– Page size: Paper size when printing
– Custom Page Size: Manually adjust the paper size to your liking
Step 4: You click Ok, got it to confirm setup
Step 5: Finally click OK, got it to start printing
3. Print Excel in Office 2007
The printing steps in Excel 2003 and 2007 are the same and the only difference in step 1 is the opening of the Print file, you can refer to the steps performed in Excel 2003 above.
– Open the file printer, select Microsoft icon => Print => Print to open the PRINT file
4. Print Excel Office 2016
To be able to set up and print in Excel, of course you need an office suite Office 2016 or other versions of Office are always available on Taimienphi and your computer is connected to the printer is still working fine
Step 1: On the application window Microsoft Excel, Selection File to pop out worksheet options
Step 2: Choose Print to set up printing in Excel
Step 3: There are computer settings, print pages, … But choose first Page Setup to set up how to print Excel text
Step 4: On the tab Page of the Page Setup window you have the settings:
Orientation : Set orientation of printed pages with Portrait in Portrait and Landscape in Horizontal
Scaling : Set the print page size with Adjust to print in percent and Fit to print in width and width
Paper Size : Select the paper size according to the drop-down list
Print Quality : Quality and sharpness of the print (higher quality dpi)
First page number : Page numbering
Step 5: tab Margins There are custom page alignment Print in Excel Compared with the positions Top, Bottom, Right, Left (Top, Bottom, Left, Right) and Header, Footer is the header margin, footer margin
Instructions to print excel directly on your computer
Step 6: You can select the content displayed in the header and footer at Header / Footer tab
At the drop down menu Header, you can select what appears at the top of the page
At the drop down menu Footer, you can choose what shows up in the footer
To customize the content as you want at the footer or header, choose Custom Header or Custom Footer …
Print Excel text on a PC
Left section: Enter data to appear in the left margin of the header or footer
Center section: Enter data to appear in the middle of the header or footer
Right section: Enter data to appear in the right margin of the header or footer
In addition, you also have options such as:
Format font: Change the font, text, and style of the highlighted paragraph.
Page number: Insert page numbers on each page.
Number of pages: Use page numbering to create a series of pages from pages 1 to 15.
Date: Include the current date.
Time: Include the current time.
File path: Add the path name (file location).
File name: Add names to the workbook file.
Tab name: Add names to the worksheet tab.
Insert picture: Insert photos.
Format picture: Format image inserted.
Print Excel file on laptop
Step 7: At the Sheet tab, you can set up the worksheet as print area, page order, etc.
Print area: Enter the worksheet you want to print
Rows to repeat at top: Click on the icon to the right of the box and drag the line you want to repeat at the top of the page. This way, that line will appear on every sheet
Columns to repeat at left: Click the icon to the right of the box and drag the column you want to repeat to the left of the page. This way, when printed, the left column appears on every sheet
Elements that will print: Check the boxes in the Print section if desired. For example, Gridlines (including grid prints), Black and White (black and white prints), Draft Quality (trial print quality), Row and Column Headings (print headings and columns)
Page order: In the Page order section, select Down, then over or Over, then down. You will see this effect when the data in the worksheet is insufficient for one printed page
Step 8: After you have set up printing in Excel, return to the Print section to go to print with the following sections
Printer : Select a printer to print
Print Active Sheets : Print the current workbook by default setting or you can print the whole workbook
Pages : Select page to print, leave blank if you want to print all, enter first page number and last page number if you want to print a certain number of pages
Collated : Specify the number of copies to print in Excel
And the settings below are already set in Page Setup so do not pay attention. You can then click Print to begin printing according to the settings
So Taimienphi has instructed you to set up the settings, print Excel to help you quickly get acquainted with this leading office productivity calculator. For proficient use of Microsoft Excel could not help but grasp how typing off in Excelor Excel has supported you to calculate very quickly but with 7 Excel tips will help you calculate even faster.