How to change page setup in excel 2007

Isn't it possible that changing printing preferences for the new printer or fora printer with a new driver would return to the desired output? The answer is to use a macro, probably best to store it in a separate workbook, such as the Personal. Then start the 'Record Macro' option and select the required storage location.

Click 'OK' or 'Cancel' Stop the macro. Although you have not actually done anything in this macro, all of the current print options are recorded. Below is an example from my computer. Sub Macro1 Application. InchesToPoints 0. The macro above was recorded within Excel , although it should be similar with earlier versions. I do recall that when running Excel the code included some lines naming my specific printer.

You may need to remove these lines, especially if sharing the code with other people. Obviously if you have several alternative printing setups you can repeat the process for each setup. Got a version of Excel that uses the ribbon interface Excel or later? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface. View the most recent newsletter.

Toggle navigation. Search titles only. Search Advanced search…. New posts. Search forums. Log in. Sign up. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding. Thread starter moose69 Start date Nov 19, Status This thread has been Locked and is not open to further replies.

The original thread starter may use the Report button to request it be reopened but anyone else with a similar issue should start a New Thread. For a Microsoft Excel 97 and earlier versions of Excel version of this article, see When you run a Microsoft Visual Basic for Applications macro that attempts to set or get the page setup properties for any sheet in a workbook in Microsoft Excel, you may receive either of the following error messages:.

Run-time error '': Unable to set the x property of the PageSetup class. Run-time error '': Unable to get the x property of the PageSetup class. This problem occurs when there are no printer drivers installed on your computer.

Excel cannot set or get page setup properties if no printer drivers are installed. To prevent this problem from occurring, install a printer driver on your computer. Use the Printers option in Control Panel to add and remove printer drivers. In Excel, page setup properties are only available when you print or preview one or more sheets in a workbook.

To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets. To specify where in the header or footer you want the page number to appear, click inside the Left section , Center section , or Right section box. To insert numbers, click the Insert Page Number button. To number all of the worksheet pages in a workbook sequentially, first add page numbers to all worksheets in a workbook, and then use the following procedure to begin the page number for each worksheet with the appropriate number.

For example, if your workbook contains two worksheets that with both be printed as two pages, you would use this procedure to begin the page numbering for the second worksheet with the number 3. On the Page tab, in the First page number box, type the number that you want to use for the first page.

To use the default numbering system, type Auto in the First page number box. By default, Excel numbers and prints pages from the top down and then left to right on the worksheet, but you can change the direction to number and print pages from left to right and then from the top down.

On the Sheet tab, under Page order , click Down, then over or Over, then down. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu. Note: You may have to scroll to the top of the list to click none.

Header page numbers appear at the top of the printed page, and footer page numbers appear at the bottom. When you're done, you can either stay in Page Layout view, or you can switch to Normal view by clicking Normal on the View tab. You can make the first printed sheet start with a page number other than 1. This is helpful if there are other printed pages that will come before the sheet. For example, you might print a 2-page Word document that will account for pages 1 and 2, and your Excel sheet would then start on page 3.

On the Page tab, in the First page number box, type the number you want for the first page number. For example, if you wanted the first page number to be 3 , you'd type the number 3. If you are using a page number format that counts the total pages, for example: Page 3 of 7 , you'll need to make an adjustment to the second number.

This adjustment ensures you don't end up with something like this: Page 10 of 7. For example, if 3 is your first page number, you need to include 2 pages in the total page count.