Apply page setup to entire workbook excel 2007

Sorry this didn't help. Thanks for your feedback. I want to add one header to all of the sheets. Can I do this in one addition? This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. Print multiple workbooks in Excel. Print ranges in Excel. Quickly print current page in Excel. Print long column on one page in Excel. Note: The other languages of the website are Google-translated.

Back to English. Log in. Remember Me Forgot your password? Password Reset. Please enter the email address for your account. Most desktop printing devices lack the ability to lay down ink or toner all the. How to create a header in excel to span across the top of the page. By adding a header to a spreadsheet, you can follow a format that lets you insert a company name, author and other. Change both of width and height to 1 page.

Cause the problem is that when a postscript printer is selected as the default printer for excel, the application does not scale the sheet size. This increases the number or date. In excel i can select a chart then go to the print preview page then select setup which brings up the page setup window.

Open your spreadsheet in excel Which was the scenario i had at the time. I have a simple table , say 10 rows by 10 column and i set the print range accordingly, so that only the table, and nothing else is covered in any print. This method is valid in microsoft excel later version. In that window under the chart tab there are several options to choose from for sizing the chart to the printed page. I have just switched from excel to excel You can use the zoom feature to make the spreadsheet smaller and fit more onto the screen, but that doesn't always give you the result you want.

Click the page layout tab at the top of the window. We will then save the spreadsheet as a pdf so that you can easily share it with others, or print it again in that format. Basically, i want the selected area to completely fill the whole printed page.

Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose.

This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.

You can programmatically change the page setup attributes in the active workbook and in any other open workbook. These macros use the Orientation property of the PageSetup object. You can modify other page setup attributes, by using other PageSetup properties, such as LeftMargin, RightMargin, and so on.