Summary of skills and problems in Excel printing

In the process of using Excel, it is indispensable to print out the Excel file, the following some of the collected Excel printing skills and problems, published to Excel bar, share with you!





1, without a printer, you can print a preview





when you press Excel's Print Preview button on a computer that does not have a printer installed, Excel prompts you not to install the printer and cannot print the preview. In fact, just click "Start" → "settings" → "printer", and then double-click the "Add Printer" item, and then install a printer driver casually. When you restart Excel, you will find that you are ready to print the preview.





2, offsite print Excel form





If a computer (a computer) does not have a printer installed, another computer with a printer (b computer) does not have Excel installed, you can do this: first on a computer to install the driver B computer printer, and then open the Excel workbook you need to print, bring up the "Print Content" dialog box, Set the printer to a printer on the B computer, select the Print to File option, set other options, press OK, and then press OK when you enter a filename (such as A.PRN) in the Print to File dialog box that pops up. Then copy the A.PRN (saved in the My Files folder) file to Computer B, in DOS (or MS-dos mode under Windows), and in the directory where the file is located, perform the copy a.prn LPT1 command to print the Excel worksheet.





PS:LPT1 represents the first port of the printer, the same LPT2 is the second port, if your computer does not pick up the printer, do not try this command to avoid the possibility of a machine, if your printer is using USB port to connect with the computer, may be no way from MS-DOS Print below.





3, print the specified page





A sheet composed of multiple pages, printed out, found that one of the pages (or a few pages) have problems, after modification, there is no need to print all over again! Simply select file → print (you cannot press the Print button on the Standard toolbar directly. Otherwise, print the entire worksheet, open the Print Content dialog box, select the page option under Print Range, and enter the page number you want to print in the next box, and then press OK button.





4, printing multiple worksheets at once





when you hold down the shift (or CTRL) key and click on the worksheet name that you want to print, you can select multiple consecutive (or discontinuous) worksheets for normal print operations to print the selected worksheet one at a time. In the Print Content dialog box, select the entire workbook option under Print content, and then make sure that you print all the worksheets in the entire workbook at once.





5, let the worksheet center print





Sometimes, you might want to print more data than that. If you print directly, these contents may be concentrated at the top of the paper, it looks very unattractive, but if the manual adjustment is very troublesome. At this point, just select "File" → "Page Setup", open the Page Setup dialog box, click the Margins option page, and if you want the data on the worksheet to be centered horizontally between the left and right margins, just tick the horizontal check box under the Centering section If you want the data in the worksheet to be vertically centered between the top and bottom margins, just tick the vertical check box and, of course, suggest that you check both options simultaneously, which makes it much more beautiful.





PS: This feature is not in Word, so need a similar situation, such as printing a logo or something, using WordArt and this feature, the L is more convenient than word.





6, the form is also compact





Sometimes it may be necessary to adjust multi-page content to a single page (which can be achieved by zooming in word) for work. You can select file → page setup, and then click the Page tab in the Open Page Setup dialog box, and under the Zoom group, there is an option to adjust to. Just type in the number of pages you need to print the contents of the worksheet (note that the two values must be the same for the page width and page height). However, this feature is not recommended for worksheets that are heavily uncoordinated with high or wide proportions of paper, or it can seriously affect the printing effect.





7, let each page print out header row





A table that consists of multiple pages, usually requiring a header row to be printed on each page: to perform the file → page setup, open the Page Setup dialog box, click the Sheet tab, and then enter in the box following the top header row: $2:$3 (This assumes the 2nd and 3rd behavior header rows, $ Symbol in the English state, with the SHIFT+4 key combination input), to determine the exit, and then print, the system will automatically add header row for each page. If you enter the column heading area in the box after the left header column, you can add the above headings to each page.





8, print the selected area





Select the area you want to print, perform file → print, open the Print Content dialog box, select the selected area option under Print content, and press the OK button. If you frequently want to print a fixed area, you can select the area first, then the file → print area → set print area. After this setting, you can print the settings either by executing the menu's print commands or by pressing the Print button on the Standard toolbar.





9, Print discontinuous cells (area)





If you just need to print out some of the content in a discrete cell (range), hold down the CTRL key while you click the cell (range) you want to print, and select more than one contiguous cell (range, such as A2. B2:c8. D10 ... , and then select file → print, open the Print Content dialog box, select the selected area option under Print content, and press the OK button. At this point, the system separates each contiguous cell (region) that is selected and prints it on a different page (that is, the A2 is printed on a sheet of paper, and the B2:C8 is printed on another piece of paper ...). ）。





10, Print discontinuous rows (or columns)





Sometimes, you need to print some of the noncontiguous rows or columns of a worksheet. You can hold down the CTRL key while you click the Row (column) label with the left mouse button, select a number of discontinuous rows (columns) that you do not need to print, right-click, and choose hide options to hide them. Then you can do the print operation again.





11, print out the formula





If you want to print a formula in a cell, execute tools → options, and in the View tab, select the Formula option to make sure you exit. At this point, the worksheet contains the cells of the formula, not the results of the calculation of the formula, but shows the specific formula, performing the print operation, you can print the formula.





12, automatically avoid error value printing





when a formula exists on a worksheet, it is sometimes inevitable that you will get some error messages, but you don't want to show the error messages when you print.　 Select file → page setup, click the Sheet tab, click the Error cell print as Drop-down list box under the Print Options group, and then change the default display value to "blank" so that the error message that appears on the screen is not printed, but only blank cells are printed.





13, Monochrome printing





If you want to print the file black, or your printer does not support color printing, you can take advantage of the monochrome print feature in Excel. Select file → page setup, click the Sheet tab, and then click Monochrome Print under the print Options group, so you can print to a black file.





14, double-sided printing





often need to print the files in order on both sides of the paper, the following use a macro to complete this function.





Sub double-sided printing ()


'*******************************************


' function: two-sided printing of a small program, after printing is finished, will be


' Some paper back into the printer, continue to print the reverse





'*******************************************


on Error Resume Next


dd = ExecuteExcel4Macro ("Get.document (50)")


for i = 1 to Int (DD/2) + 1


ActiveWindow.SelectedSheets.PrintOut from:=2 * i-1, to:=2 * i-1


Next


MsgBox "Please put the printed paper back into the paper slot", vbOKOnly, "Print the Other Side"


for j = 1 to Int (DD/2) + 1


ActiveWindow.SelectedSheets.PrintOut from:=2 * J, to:=2 * J


Next


End Sub





to this, the collection of printing skills to share the finished, there you need and do not know! If you have one, try it.