How to print Excel, print Excel spreadsheets fast, standard

In the article below, TipsMake.com will guide you how to print spreadsheets in Microsoft Excel. To print Excel, of course we will need a printer working normally, connect to the computer and follow the steps below.

1. These are the most basic functions in Excel that you need to understand

Page settings in Excel:

This includes changing the page size, page format, and print page quality. As follows:

1. Change page setup options:

1. From the File> Print> Page Setup menu as shown below:

1. The Page Setup dialog box appears, we can see there are many options corresponding to each tab. Select Page:

1. Set the print page orientation: in the Orientation section, click the Portrait or Landscape select buttons.
2. Set the print page size: in the Scaling section, select Adjust to: enter a percentage (you can click the up or down button to increase or decrease the size).
3. Choose Fit to : set the width and height for the page.

Set other options for print pages:

Paper size In the Paper size section: select the paper size from the Print quality drop-down list In the Print quality section: select the print quality from the drop-down list (the higher the dpi - the better the quality) Page numbering To start page numbering , select the First page number item: enter the number of pages you want

2. Align the printed page:

Alignment of printed pages in Microsoft Excel includes alignment of the top, bottom, left and right margins of the page. You can also align the data to the center of the page.

To change page margins:

1. In the Page Setup , select the Margins tab

1. Click Top , Bottom , Left , and Right, and change the settings.
2. Click Header to change the header and Footer margins to change the footer margin.
3. Click OK .

Note that at the Center on page section , you can choose Horizontally (horizontal) or Vertically (vertically) to get the best data placement.

3. Set Header / Footer:

Setting headers (Footers) and Footers is very important, which affects the overall view of a printed page.

Change page and footer titles:

1. Select the Header / Footer tab from the Page Setup dialog box

1. Click on the Header drop-down arrow : the header types are available in the list, just select the appropriate header type:

1. Click the Custom Header or Custom Footer button to display the Header (or Footer ) dialog box:

1. In the Left section: Enter data section to appear on the left side of the header or footer.
2. In the Center section: Enter data to appear in the middle of the header or footer.
3. In the Right section: Enter data section to appear at the right margin of the header or footer.

1. You can also choose the following options:

Format font Click the format font button (icon A) after marking the paragraph to change the font, size and font Page number Insert number on each page Number of pages Use page numbering to create a sequence of pages from the page 1 to 15 Date Enter the current date Time Enter the current time File path Add the path name (file location) File name Add the name to the file workbook Tab name Add a name to the tab worksheet Insert picture Select the location to insert the Format image picture Format insert images

1. Click OK after finishing.
2. The new page title (footer) will be displayed in the Page Setup dialog box .
3. ClickOKto close the Page Setup dialog box.

4. Excel Printing - Spreadsheet setup:

In Excel printing, setting sheets is very important. It will control which pages are printed and where to print. So make sure you take the following steps carefully.

Change sheet options:

1. From the File menu, select Page Setup .
2. The Page Setup dialog box is displayed, select theSheettab

1. Change the following features:

Print area Enter the worksheet you want to print, or click the icon to the right of the box and drag the worksheet down to print Rows to repeat at top Click 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 on the icon to the right of the box and drag the column you want to repeat to the left of the page. In this way, when printing, the left column appears on every worksheet Elements that will print Click on the boxes in the Print section if you want. Example Gridlines, Black and White (black and white), Draft Quality (Test print), Row and Column Headings 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 not enough in a printed page

1. Some features in Print (when checking these options):

Gridlines Print the grid of Excel Black and white spreadsheet Print data in black and white Draft quality Print with quality test, not normal print quality Row and column headings Printed worksheets include row titles and column

1. To the right of the dialog box, there are 3 buttons:

Options Review printer settings Print Preview Review sheet before printing Print Print sheet.

Change print settings in Excel:

1. From the File menu, choose Print or press the shortcut Ctrl + P.
2. The Print dialog box displays, making the following necessary changes:

1. In the Printer section, type Name: select the printer you want to use.
2. In the Page range section, select All if you want to print all pages in an area, or enter the print start page in From and end to To.
3. In the Print what section, select the part you want to print. For example, Selected part, sheet part, or the entire workbook.
4. In Number of copies section, specify the number of copies to be printed.
5. Click the Properties button to display the Properties dialog box .
6. Change options. This option will change the results on the printer.
7. Click OK to close the dialog box.
8. ClickOKto start printing the worksheet.

Note : Before clicking the OK button, make sure you have placed the paper in the printer tray. Good luck!