![how to change print area in excel after making one page how to change print area in excel after making one page](https://i.ytimg.com/vi/jyRxQqfPmwg/maxresdefault.jpg)
- How to change print area in excel after making one page code#
- How to change print area in excel after making one page windows#
How to change print area in excel after making one page windows#
In the bottom left corner of your Windows screen, click Start » select Printers and Faxes. If you want to use the same printer for all your documents, you can set a default printer. For information on adding Quick Print and other buttons to the Quick Access toolbar, refer to Customizing Toolbars: Customizing the Quick Access Toolbar. NOTE: Quick Print may not be visible on your Quick Access toolbar. WARNING: If you click Quick Print on the Quick Access toolbar, your document prints without letting you customize settings in the Print dialog box. For more information, refer to About the Page Setup Dialog Box. The Page Setup dialog box lets you modify various document properties, such as footers and headers, page alignment, and more. For more information, refer to Customizing Page Layout: Changing the Orientation. To verify how the printout will look, use Print Preview.įor wide worksheets, you may want to print the information in landscape orientation (11" x 8.5") rather than portrait orientation (8.5" x 11"). This document introduces some helpful printing options and techniques. When printing in Excel 2007, you can print all or part of the current workbook or worksheet. This article is based on legacy software. If StartPageNumber > 0 And StartPageNumber <= TotalNumberOfPages Thenįor CurrentPage = StartPageNumber To TotalNumberOfPages Step 2ĪctiveSheet.(Archives) Microsoft Excel 2007: Printing Basics & "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)")
How to change print area in excel after making one page code#
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”.
![how to change print area in excel after making one page how to change print area in excel after making one page](https://i.ytimg.com/vi/lAv3JEwmVPI/maxresdefault.jpg)
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.