Formatting All Sheets In A Workbook To Print The Same

I am having trouble getting all sheets in the workbook to print the same. I
have tried selecting all sheets and setting up my header and footer, margins,
etc. But, when I then go to print preview, only the first sheet in the
workbook has held the settings.

Free Excel Help Forum

- Ask any question about Excel and have it answered in no time.

Similar Excel Tutorials

Print All Worksheets at Once in Excel
How to print all worksheets at once from Excel. This saves you the time of having to go to each sheet individually ...
List all Conditional Formatting Formulas in Excel
List all conditional formatting formulas in a worksheet in Excel. This allows you to quickly view and manage all of ...
Print Only Specific Parts of a Worksheet in Excel
In Excel you can select parts of a worksheet to print while ignoring all of the other data on the worksheet. This a ...
Print Gridlines in Excel
I'll teach you how to show gridlines for Excel when you print your files. This is a neat little feature that will ...

Helpful Excel Macros

Print Preview Screen Display for The Entire Workbook in Excel
- This free Excel macro allows you to quickly and easily display the print preview window or mode for the entire Excel wor
Print Preview Screen Display for The Current or Selected Worksheets in Excel
- This free Excel macro allows you to display the print preview screen or window for the current or selected worksheets in
Print Preview Display for Specific Worksheets in Excel
- This free Excel macro allows you to display the print preview mode or window in Excel for a specified Excel worksheet.
Delete All Chart Sheets in Excel - Only Chart Sheets are Deleted - Not Embedded Charts
- Delete all chart sheets and tabs in Excel using this macro. This will only delete the charts and graphs that are in the
Name Worksheets Based on Cell Contents
- This macro allows you to have your worksheets named by whatever is in a particular cell within a worksheet. This means

Similar Topics

I have created a workbook with 19 identically formatted worksheets in it. Each worksheet appears on-screen printing neatly on 3 sheets of paper as desired. This formatting appears consistently in all views while I am working on it and in the print preview. However, when I go to print the entire workbook, only the first worksheet keeps that formatting. Worksheets 2-19 get much larger and no longer print neatly onto 3 sheets of paper each. If I print each one individually, the formatting remains correct and everything is fine. I have checked my page breaks, my scaling percentage, my margins, that everything is centered appropriately, and have reset each one of these things on every worksheet and saved the settings. Likewise, the problem also occurs when printing a single worksheet with multiple pages. If only one copy is printed, the whole thing maintains its formatting. If more than one copy is printed, all of the formatting changes forcing it onto many more pages than appearing on-screen. Others in my office with Excel2010 are experiencing the same problem; nobody has been able to figure out a solution. Those using Excel 2007 can print the same documents with no problems at all. Is there a setting I am missing somewhere that needs to be changed?

I would like to use a userfrom to choose which of 4 sheets I would like to print from my workbook. There are many examples out there of populating a dialog box with all the sheets in a workbook and checking the ones you want to print, but my workbook has many sheets and I only want to use 4 of them. Are there any resources out there that teach you how to create a userform with a specific list of sheets to print from . I would also like a text box next to them that someone can enter the number of copies they need.


hi everybody

does anybody know how to create a code that:
selects all data (select range that contains data) on the spreadsheet then does print preview and reduces all border margins to minimum desirable range (.04 header & footer, 0.7 top & bottom and 0.5 left and right)?

i tried to record a macro directly from excel (without actually writing a code) but when it's run it gets stuck at print preview screen and doesn't close the screen. also margins seem to be being left at higher range than above.

any help would be greately appreciated



I have searched everywhere for the answer to this, and I have yet to really find any solution, please help!

I am trying to add a picture to the left header for about 10 sheets in a workbook to make them all look consistent in size. (I previously have embedded the picture into the sheet, but if I change the print area, the logo size gets bigger or smaller and does not look consistent across all of the sheets.)

So I got to View->Header/Footer->Custom Header and I click the icon to insert the picture. After I browse for it and insert it (have tried several different formats) it shows up as &[Picture] as expected.

However, once I hit OK or Print Preview it does not show up (occasionally it does, but then disappears shortly thereafter. I have adjusted the margins and tried everything else I can think of.

I have researched this and seen that other people have the same problem, but it does not seem like anyone has come to a solution.

Thanks very much in advance for any insight you can provide...


I am using Excel 2007 and Windows Xp Pro.
I am going crazy trying to figure out why my page numbers don't print on my color Epson R800. They do print on my black and white printer though.
The numbers show up in Preview mode but will not print. I even tryed an empty page - still won't print
I am competely lost in this and need the page numbers on the project that I am doing.
I tried to have the page numbers on the header and that seems to work, but no way can I get them to print on the footer.
Any help would be greatly appreciated
Thank you


I'm trying to view all the tabs of a workbook by selecting:

File | Print | Print What: Entire Workbook | Preview

but when i choose "Entire Workbook", the Preview button is dimmed and I
cannot select it.
I've used this method before, and it's worked, but now it doesn't.

When "Acive Sheet(s)" or "Selection" is selected the preview is

Why is this happening?

I am having a problem with the formatting once a workbook is saved as a pdf file. when i view the individual sheets within the workbook in print preview, they look fine (fit to one page), but as soon as I print or save to pdf, the individual sheets lose all formatting (everything seems to expand - spaces are larger, fewer words on the sheet, logo is twice the size). I have even tried using the save as xps file. I have both typed code and also recorded a macro to see if it made any difference.

Any suggestions?


Okay, I honestly don't know what I did!

1) Clicked "Print Preview"
2) Clicked "Margins"
3) Margins appeared
4) I moved both the HORZ and VERT margins around to suit me

And that's when it all happened. And now I get an error window that reads:


Question: Is there any way to just "re-set" it all to what I started with?

I'm trying to print two sheets within the same workbook at the same time as a single print job. This way sheet1 is the front and sheet2 the back.

It I do select both sheets and then print active sheets Excel creates two print jobs, forcing the printer to start the second sheet on a new page.

This page break between the prints means that I have two single sheets printed out of the printer rather than one piece of paper in duplex.

Any ideas on a work around for this?

The two two sheets are only a sinlge page in size, but have different column widths so wont easily go onto a single worksheet.

Hey everyone. I have a problem. I've searched the forum, and couldn't find an answer to my question, so I figured I'd go ahead and post it.

I need to print multiple sheets from a single workbook (that have appropriate print areas already set up). I want to assign this macro to a button, so that I can just click one button and get a copy of every sheet.

Each of the sheet names is unique, and stored in column A on a sheet titled LIST, since there are four sheets of stuff that don't need to print. Each of the uniquely-named sheets are hidden as well. What I need:

* Print all sheets, using the names on LIST in column A (A1 to the last one with data; the names are alphabetized from ADAM on down to WILLOW).
* Ask for confirmation 'Are you sure you want to print all saved sheets?'
** If yes, print all the sheets.
** If cancel, do nothing.

Any help would be appreciated. I can see how Id do everything but using the A column to define what names to print, I think.

I have a workbook that has 17 work sheets. I am wondering if there is a way to set all 17 work sheets to print in Landscape and fit to page without having to go into each sheet and make the settings individually.
What I would like is that all 17 work sheets print in landscape mode - and the contents of each sheet to fit to the page.

Is this possible?

Any help would be appreciated.


I am using Excel 2000 with Windows XP Home SP2 and am doing a workbook with
8 sheets. All is well with 6 of the sheets, but when I use print preview on
the other 2 I get a message:

Run-time error 50290 Method 'FullName' of object '_Workbook' failed

Debugger shows:

Microsoft Excel Objects

This Workbook

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.CenterFooter = "&10" &
End Sub

Actually when I get the error message and hit end instead of debug, it does
the print preview. Then if I hit print, I get the same error message. But
similarly, if I hit end, it prints.

It's an annoyance since it only adds a couple of steps to getting a print.
However, it would be nice to know how to fix it.


Using Excel 2003 I am printing multiple sheets. I have a footer on every sheet that is in the format of: page # of total pages.

When I do a print preview page number and total number of pages looks correct on every page.

However when I actually print the file the total number of pages varies and some of the sheets have wildly incorrect total number of pages (i.e. 26 total pages instead of 16 and other variations).

In doing some searches in the message boards and yes my default print driver is the same as the the one I am actually using.

I have checked various page setup options all looks "safe".

The only thing I can think of is I am using PDF Creator as my print driver. Due to various reasons I have not had a chance to test with other print drivers except for doing Print Preview but not actually doing Print.

I would have thought that as PDF Creator from PDFforge should work fine on this file as I do this all the time on other Excel files with the product. All it is doing is just capturing the print format output.

Any thoughts or ideas of something to check.

I will be doing more testing and report what I find, but would love to keep useing PDF Creator.



I have a workbook consisting of a numer of sheets.

In these sheets a lot of calculations are made and the result are displayed in different schemes on the sheets.
On each sheet the user have defined a print area.

My task is now to make a macro that make a new workbook with same number of sheets with the same names with only the data and formats from the defined print areas from the original work sheets.

The purpose of all this is off cause to make a work book without callculations and formulas which can be distributed.

Any help is appreciated

How do I get the the default setting for my excel workbooks to always print
the file path, date and time? I know I can do it for an individual workbook
by changing the footer options, but is there a way to set it for all of my
excel files? A new workbook would automatically have the settings.

I have a workbook which I always want to print the following way:
Pagesize = A3
Orientation = Landscape
Margins 0.75 on all sides
Page fitting = Fit to one page tall by one page wide.
But when I take this workbook with the given settings to another computer, these settings appear as changed. I have to do everything once again. Is there a way to do this in vba so that the pages print the same everywhere?

I am setting up monthly transaction worksheets for a client and then emailing
them for her to print out. When she opens the email attachment and checks
the print preview the top and bottom margins are not the same as what I set
them at. Is there a way to correct this?

I am running Excel 2007 on Vista. I set custom margins on my worksheet so that the print preview and actual print on my printer generates a nice single page, centered, etc. I provide a copy of the file to a friend who uses a different computer and printer. She is also using Excel 2007 and Vista. On her computer the exact same file, with the same custom margins settings produces a messed up print preview and actual print. On her setup the farthest column to the right drops off the page and generates a page two. Why would this happen when we are working with the exact same Excel file with the exact same settings in every way?

The printer I'm using has a setting that prints a cover page for each document.

For an Excel workbook I inherited from another user, it prints a cover page for EVERY worksheet that I print, even if I select multiple worksheets w/ the SHIFT or CTRL buttons. The output is:

Cover Page
Sheet 1
Cover Page (different "job #" listed)
Sheet 2
Cover Page
Sheet 3

I initially thought it a problem with the printer settings. However, with a brand new Excel workbook, I can select multiple worksheets and print with the following output:

Cover Page
Sheet 1
Sheet 2
Sheet 3

The fact that only one cover page can be done on other workbooks leads me to believe that there may be a setting in the bad workbook that causes multiple sheets to be printed with individual cover pages.

I've tested with macro's and individual "click and print" methods and this specific workbook prints out cover pages while my other tests only print out 1 cover page.

Does anyone know how/why this could be happening? Is there some sort of system setting to send print jobs individually or as a group to the printer?



I have a problem when printing in excel, I hope someone can help me.

I have created a document that contains a normal table with 6 columns and some rows, I have included a title and a footer which are supposed to repeat in all pages. I have also included some rows, on the top of the document, to be repeated in all pages. I have arranged all the margins, manually, in the Print Preview window, so that everything appears correctly. Everything looks just the way I want it on the Print Preview, but when I print that same page, there is a space between the things I have written in the title and the table with the normal content. The space is about 1.5 cm. Of course, everything moves down and the footer is cut off the page and does not appear on the printed page.

I have gone over again and again on the margin configuration, and everything looks fine in the print preview, but always the result is the same. With the wierd space that appears, moving everything down.

Can anyone please tell me what is happening? What is the problem?


I can't get the 2 sheets in the workbook to print out on both sides of a
printed sheet. I select "entire workbook" from print menu and "preferences"
to 2 sided paper, but it prints each sheet separately.
Using excel 2003 in Microsoft Office

I am prepareing to create a new spreadsheet and one of my thoughts that I want to be able to do is, I want to put into a command button printing only specific worksheets in a workbook only if on that sheet cell A1 has a value.

for example if evrything works out right, i may only want to print out sheets 1,2,3,4 & 5 only because cell A1 will have a value, it will be text if it does. I do not want to print out sheets 6, 7, 8, 9 & 10 because cell A1 has no value at all.

So there is a range of 10 Worksheets, but only a few could have information on them and those would the sheets I want to print out

the referenceing cell will be exactly the same on all worksheets.

Can this be done????


I'm having trouble printing a document. It will only print one cell per page. I was able to print it fine to a letter document, but after realizing it was too small to read, I switched to legal. Now neither legal nor letter will print correctly. It prints one cell per page.

I have cleared the print area; did not work. I then defined the range I wanted; did not work. When clearing the print area the "print preview" looks fine until after I print, then it goes back to showing only 1 cell. I have set my margins to regular and small and scaled various, all to no avail.

The printer is currently held up for the next few hours, so I can't trial and error (and I'd rather not waste more toner and paper), but the only thing I can think of is that I didn't hit "save" after clearing the print area?

Thank you.

Any suggestions as to why I can't clear the print area of my worksheets? I
get into the sheet, select "Clear Print Area", and then I do a print preview
and it shows a bunch of stuff to be printed. I'm not printing the Workbook,
just the sheet. None of the sheets in the book will clear. (If I select one
cell, and make that the print area, it shows just the one blank cell in print
preview, but then if I choose "Clear Print Area", I'm back to printing a
bunch of stuff.) Thanks

hi .. its some wat related to my old question .. can one tell how i can close the print preview mode through code .. i meant when workbook is in print preview mode i want to come back in normal mode by running my code .. not by click on Close Button . there is Window property to get in normal mode but that works when u r in PageBreak preview mode .. not in print preview mode.. i want to get to normal view from Print previewview mode in my program.