Next, click Page Layout -> Print Area -> Set Print Area.To set multiple print areas in Excel, you can select the first print area, then press and hold Ctrl key and select other non-contiguous print areas one by one.When you send the Excel worksheet to the printer next time, only the selected areas will be printed. The selected print areas are saved when you save the Excel workbook. If you want to save the print areas and print them later, you can press Ctrl + S keyboard shortcut. If you want to print the selected area immediately, you can click File tab and click Print to print the Excel spreadsheet.Next click Page Layout tab, and click Print Area in the Page Setup Then select Set Print Area option.In the Excel file, you can select a range of cells that you want to print.In this tutorial, you will learn how to set print area in Excel, how to change print area, how to clear print area in Excel, etc. Microsoft Excel has a Print Area feature that lets you easily select print area in Excel. Sometimes you may only want to print a part of the Excel sheet. you can use MiniTool Power Data Recovery. If you want to recover deleted or lost Excel spreadsheets, Word files, or any other files from Windows computer, USB flash drive, etc. If StartPageNumber > 0 And StartPageNumber <= TotalNumberOfPages Thenįor CurrentPage = StartPageNumber To TotalNumberOfPages Step 2ĪctiveSheet.This post teaches you how to set/change print area in Excel, how to set multiple print areas in Excel, how to clear print area in Excel, etc. & "Also make sure that the correct printer is selected as the printing will start right away.") & "This number determines wether odd or even pages will be printed. & "Which page do you want to start with?" & Chr(13) & Chr(13) _ & " pages selected in total." & Chr(13) & Chr(13) _ StartPageNumber = InputBox("There are " & CStr(TotalNumberOfPages) _ TotalNumberOfPages = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)") Paste the following code and press start above: Sub PrintOddOrEvenPages()ĭim TotalNumberOfPages, StartPageNumber, CurrentPage As Double Right click on and worksheet on the left hand side and click on “Insert” –> “Module”. Open the VBA editor by clicking on “Visual Basic” on the left hand side of the “Developer” ribbon. You still want to print all odd or or even pages? The only option is a short VBA macro. You might have to search a little bit for that option. Then the printer menu options – this windows looks different for each printer. Then click on the “Printer Properties” button (number 1 on the image). As usual, you will see the print preview. Therefore, press Ctrl + p on the keyboard. Most printers offer such option so that you don’t have to worry about odd and even pages. Most printer offer a two sided print option.įirst question: Why do you want to print odd or even pages only? If the reason is that you want to print your Excel sheet on front and back side of the paper, please take a look at the print menu first. For those of you who like to do some VBA programming we’ve also added the corresponding VBA code but we won’t go more into detail here: Header/Footer elementĬode for inserting in Header/Footer window These settings you can also add in different ways by typing the code. If you want to work with the codes, please refer to this table. Therefore enter “Page ” then click on button 4, type ” of ” and click on button 5. Once you’ve selected a picture with button “11” you can modify it by clicking on button number 12.Įxample: You want to insert “ of 3”. In most cases, you need at least to define the correct size of your picture.Just click the button and select your picture. Besides the file path, you can also insert the file name.If you only want to insert the path without the file name, type “&”. By default, Excel adds the path and file name. Insert the file path of your workbook.This is the date at which you are printing the workbook – not the last save date. Also this number depends on which sheets you are going to print. If you just print the second worksheet of your workbook, the numbering will still start at 1. This number will depend on the sheets you are printing. Insert the number of the current page.You can change the font style by clicking on the “A” button (number 3). Add a custom text by just typing into one of the text boxes.Now you’ve got many options for defining headers and footers. Click on “Custom Header” or “Custom Footer”.Now go to “Page Setup” and navigate to “Headers and Footers”. Enter the print screen by pressing Ctrl + p on the keyboard.Follow these steps for inserting headers and footers (the numbers are corresponding to the image on the right hand side): The advantage is that you won’t mix up the printed pages.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |