How do I keep the print settings saved for a worksheet?


New Member
Aug 30, 2010
My coworkers and I share a spreadsheet that we update often and save on sharepoint. Everytime someone wants to print the the spreadsheet, they have to readjust all the print settings (set print area, adjust to landscape, fit width to one page, etc.).

Is there a way to save the print settings in this worksheet so that it prints the same way every time someone goes to print it?

Cell content is the only thing changing - so the print settings will always be the same.

Thank you,

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.


Well-known Member
Jul 14, 2010
as far as i know the page setup for each sheet is kept with the document (especially the ones you describe) - so if no changes are made - this shouldn't be an issue.
if (as it is very likely) everyone has a different printer with different settings (mostly the printer margins) it may lead to some differences in the ammount of information/rows on a page but not more than this.
unless it is something connected with the sharing.


New Member
Aug 30, 2010
Thanks for your quick reply, but selecting the print area and fitting the width to one page are not settings that would change depending on the individual printers. (the percentage it would shrink it down to might change, but it should still print the selected print area, fit to one page width, in landscape, no matter what printer you use.)

Even taking sharepoint out of the equation....

How do I save the print settings so that everytime I open my document and print it (let's say it's saved on my own hard drive), the print area is already set, along with langscape and "fit to one page width".

Is there a way to save print settings you establish, or do you have to reset them every single time you open the document?


Jun 19, 2002
Can you record a macro whilst setting the print settings manually (I think you'll need to unshare the workbook to do that) and post the recorded code here. It should then be possible to incorporate the code into the Workbook_BeforePrint event.

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...