| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing Default Print Quantity
I have a spreadsheet containing multiple worksheets. I printed multiple
copies (9 copies) of one of the worksheets. Usually, I just change the quantity to 1, re-save the spreadsheet, and the default will be 1 the next time I open it. However, this is not the case . . . the default quantity will not change from 9. Can anyone tell me how to change the default quantity? The document is saved as .xlsx -- Excel 2007. Thanks, KimL |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing Default Print Quantity
Whether this helps..
http://help.lockergnome.com/office/S...ict197124.html If this post helps click Yes --------------- Jacob Skaria "Michele" wrote: I have a spreadsheet containing multiple worksheets. I printed multiple copies (9 copies) of one of the worksheets. Usually, I just change the quantity to 1, re-save the spreadsheet, and the default will be 1 the next time I open it. However, this is not the case . . . the default quantity will not change from 9. Can anyone tell me how to change the default quantity? The document is saved as .xlsx -- Excel 2007. Thanks, KimL |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing Default Print Quantity
Erin Dix wrote:
"This drove me nuts forever! In the sheet that's giving you problems, select File and Page Setup. Click on the Options button. Select the Page Layout tab, and in the upper left adjust the default number of copies back down to one." This worked for me (was one of those 'Well, DUH!' moments for me). Hope it works for you. -- FirstVette52 "Michele" wrote: I have a spreadsheet containing multiple worksheets. I printed multiple copies (9 copies) of one of the worksheets. Usually, I just change the quantity to 1, re-save the spreadsheet, and the default will be 1 the next time I open it. However, this is not the case . . . the default quantity will not change from 9. Can anyone tell me how to change the default quantity? The document is saved as .xlsx -- Excel 2007. Thanks, KimL |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I set some cells to not print w/o changing print layout? | Excel Discussion (Misc queries) | |||
| Need a formula to increase quantity of one cell until the quantity ofanother is exceeded | Excel Discussion (Misc queries) | |||
| Changing Default Number of Copies to Print | Excel Discussion (Misc queries) | |||
| Changing footers on all worksheets without changing print set up | Excel Discussion (Misc queries) | |||
| How to set DEFAULT print options in Excel to print gridlines? | Excel Discussion (Misc queries) | |||
Linear Mode
