[2007] Multi-tab printing printer tray issues

I have an issue with printing selected sheets in a workbook. If a specify a 
paper source like tray 1 at the printer settings dialog the first selected 
sheet is printed to that tray, all other sheets are printed to the default 
paper source tray

Any suggestions?

Kind regards,

peter4518 (1)
7/20/2007 8:24:13 AM
excel 39879 articles. 2 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 32

If you select multiple worksheets and open the page setup you can set the 
headers and pages numbers for all of the selected sheets.

However, when doing the above if you also select the printer setup and 
select the paper source, it is only set for the active sheet (that is the 
visible sheet). You can establish this by clicking on sheet 1 first and then 
hold the Ctrl to select the other sheets and set the paper source and then 
click on another sheet first before holding Ctrl to select the remaining 
sheets and go into the printer setup and it will not be changed.

To overcome the problem, select all the sheets for the page setup and 
complete the headers, footers and page numbers etc and then select the sheets 
individually ans set the paper source.



"Peter" wrote:

> I have an issue with printing selected sheets in a workbook. If a specify a 
> paper source like tray 1 at the printer settings dialog the first selected 
> sheet is printed to that tray, all other sheets are printed to the default 
> paper source tray
> Any suggestions?
> Kind regards,
> Peter 
OssieMac (238)
7/21/2007 4:30:01 AM

Similar Artilces:

Publisher 2007 does not recognize printer
When attempting to print any document, page & etc from Publisher 2007 the pop up window "To print or preview a publication, at least one printer must be installed on the system" appears. The printer is installed and prints with all other programs installed on the computer including a test print. I have met with negative results with anything I have tried. There have been similar problems with Publisher 2007. What model printer do you have? There is an article here that was posted by Mark Clifton sometime back, it might be the solution you are hoping for. It is the art...

Multi user #2
is it possible to use an excel spreadsheet as a multi user sheet.i.e. is ther any way to be able to access the sheet by multi user on different computers that are networked and to be able to make changes to the sheeet. -- Lins ------------------------------------------------------------------------ Lins's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24223 View this thread: http://www.excelforum.com/showthread.php?threadid=393548 See this article for how it's done and the ramifications of it, Lins: http://www.officearticles.com/excel/workbook_sharing_in_...

Excel 97 and 2007 on same computer
How can I *re-set* Windows XP SP2 to open all of my Excel files (.xls.xlt.csv) in Excel 97 when double-clicking? I also have Office 2007 installed inorder to sample the program, but not to use as my primary office application at this time. Thanks. -Dennis -- Dennis Kessler http://www.denniskessler.com/acupuncture You have to re-register the particular Excel version you want to open excel files with http://support.microsoft.com/kb/214388/en-us -- Regards, Peo Sjoblom "dk_" <nobody@spamless.com> wrote in message news:R%LSj.2715$NZ7.901@newsfe10.ams2... >...

RMS and House Acct- printing statements
I have a potential customer who will use house accts and print statements. However, there are some statements that done need to be printed (for example- COD). So - they want a way to be able to filter on what types of statements are printed. They may have 500 customers, but only 300 need to be printed. Today, they Add a code- N3 to the customer record, and then they filter on which customer statements to print that have the code N3 and have a balance greater than 0- and print these statements. Can RMS "filter" on which statements to print that are represented by a code? Andrea...

Document scrolling in Word 2007
I think you can get documents to automatically scroll through when you are using compare - but can you get it to do it for just one document? It would be very useful for proof reading (e.g., you can do it on Acrobat) -- Jon Morgan of Paraphrase If you have a mouse with a clickable wheel in the middle, click it on the Word document. The cursor changes to a pair of arrowheads with a dot in the middle. Drag the mouse downward very slightly, and the document will start to scroll. The farther down you drag, the faster the scrolling becomes -- and anything more than the least pos...

Word 2007 copied URL's disabled
In Vista copied links to WOR turned blue and were underlined. They became active when the Ctrl key was clicked. In Windows 7 the copied links are black and not underlined. They won't work. How can I get them to work? Word options > proofing > autocorrect options > autoformat - check the box 'internet and network paths with hyperlinks' and any other options you require. Click OK. Then either add the 'autoformat now' button to the QAT (Quick Access Toolbar) or click ALT+CTRL+K to autoformat the document. -- <>>< ><<> &g...

correct settings for sql in ms office 2007
I don't believe my SQL is starting when I open MS Office 2007. I cannot send or receive email within the program. Which insances of SQL require what settings please. I'm at my wits end. Thank you. ...

MS Pulisher 2003 Printing/Preview Problems
Hi everyone. Got a problem with MS Publisher 2003. Designed a certificate using the Special Paper Award Certificate template but when I preview or print it the border does not show. Does anyone know how to make it preview or print with the borders? Look in a folder similar to this C:\Program Files\Microsoft Office\OFFICE11\1033\PUBSPAPR This folder contains the .gifs that are used in the Special Paper templates. They are low resolution but you can get the idea how your certificate will print. My Microsoft newsreader is down, is anyone else experiencing this? -- _____ "Sombre" &...

Error 553 using Outlook 2007 and Vista
Hello. I'm getting the following error using Outlook 2007 and Vista: 553 sorry, that domain isn't in my list of allowed rcpthosts (#5.5.3 - chkuser) When I test the account settings, it's fine. I can recieve just fine, and the only outgoing messages without this error are for recepients with my same domain. I've turned off my antivirus and windows firewall. Still this doesn't work. Any help would be greatly appreciated. 550 errors usually mean you're not authenticating properly, or you're attempting to use an SMTP server other than the one your ISP provides. ...

Create Sheet Tabs from the List (URGENT)
I have to create worksheets of 1000 customer in a single workbook, I have listed the customers name in a seperate word file. Can I programatically create sheets from that list of customers. Any help will be highly appreciated in this regard. Murtaza Hi Murtaza, modified from code on my sheets.htm page will create form a selection that you might have pasted into Excel from MS Word. The sheets will be added to the end and cells that are not text constants will be rejected. i.e. numbers will be rejected. For Each cell In Intersect(Selection, _ Selection.SpecialCell...

Outlook 2007 to Outlook 2007
I want to convert back from Microsoft Outlook 2007 to Microsoft Outlook 2003. Can that be done? Is Outlook 2007 backward compatable? No. Afraid you will need to uninstall OL 2007 and then install OL 2003 -- Peter Please Reply to Newsgroup for the benefit of others Requests for assistance by email can not and will not be acknowledged. http://www.microsoft.com/protect "Guy" <gdelaney@suddenlinkmail.com> wrote in message news:OTykI2Q$KHA.4308@TK2MSFTNGP04.phx.gbl... >I want to convert back from Microsoft Outlook 2007 to Microsoft Outlook > 2003. Can...

SubForm Issues
This is a Carryover from the "Populate Subform based upon a Query" post that Dave Hargis and Rick Brandt were kind enough to try to help me with my problem. I did as Rick suggested, and changed my LinkMasterField for my SubForm to "lbWheels.Column(0); lbWheels.Column(2)" and my LinkChildField to "WheelName; FIteration". Now whever I activate my form it asks for the Parameter values (input box) for each of the Master and Child Link Parameters and when I enter through them, my form will not work. Sorry to keep bringing this issue up, but it is driving me cr...

product kits issue
Maybe I am missing something but is there anyway to add a product to a kit and then specify the quantity of that item? For example: Stereo System 1 has 25 feet of speaker wire, 5 speakers, 4 connectors, etc. Sean Hi Sean, I've looked and looked for a way but I haven't found one either. Rafael Gomez TurnkeyCRM hhtp://www.turnkeycrm.com ...

Money 2007 payee name management
What is the best way to handle payee names and their variations? For example, I charge all of my gasoline purchases and typically fill- up at Raceway gas stations. After downloading the transactions each Raceway gas station appears with its own payee name, such as: Raceway 0001 Woodbridge Racewy 123 Edison ..... and so on I kind of like having this informatiion in the transaction register, but each one is a separate payee. At the same time I'd also like to group all of them under a single payee named Raceway. I started to use the automatic mapping of alternate payee nam...

upgrading from Access 97 to Access 2007
I designed a database (forms, reports, et al) several years ago in Access 97 and it continues to work well. I've just received a MS Office Professional 2007 and wonder if it is time to migrate my data into the new program. I've attempted two or three times to do this in Access 2002 and I keep getting error messages along the line of "...corrupted file..cannot be opened by Access 2002 (or some such message)..." The help radio button opens up a box which suggests I do some programming in Virtual Basic to perform my transfer task. The easy way out, of course, is to sti...

Printer does not print all text
For some reason one of my Publisher file is not printing all the text; only about 75% of the text is there. I have tried to print from a different computer but have the same problem. On screen, everything looks right and great. I am using Publisher 2007. Andy help would be appreciated. You might want to check the manufacturer's web site of your printer model for an upgraded driver. If you think your present driver is correct, uninstall it and then re-install. It is always wise to completely remove a printer driver before installing/reinstalling. How to clean up printer drivers...

excel printing problem with my worksheet formula
Hi I am fairly new to excel. I added the automatic list number to worksheet that I am doing. So here is my problem I have. When I use th automatic list numbering formula I set it to count up to like 50 items. Now when I use it for like sales and count tracking sometimes will sell 15 or 50 or even 150 items or more each sale. Now when I wan to print each sale I cant get it to print only the items I want like 1 or 50 depending on the sale. It will print all 5 pages that I set m count up to, which was 500 items. So 15 items is not even one page o but I will get all 5 pages in all. "1 with...

Hide non-printing characters.
I have imported some data into Excel as a CSV file. Some of the cells contain formatting character such as CR, LF, HT. One one machine, that uses Excel 2000, these characters are displayed as squares. On another macine, that uses Excel 2007, the characters are still present but do not display. How can I hide (not delete) those characters on the Excel 2000 machine? TIA Chris Linefeeds will appear as little squares if the cell's format is not set to wrap text. If you change the format to wrap text, then the linefeeds will force new lines within the cell. Saved fr...

SharePoint 2007 Alerts
Alerts on out SharePoint 2007 server have been working for well over a year. On Monday, alerts stopped coming through on our "EmployeePortal" site. Alerts do come through from the same server from the "BusinessPortal" site. - Newly created alerts do send the "You have successfully created an alert for..." message from the "EmployeePortal" site. - Alerts do come through from the same server for a different web app/site collection. - Both "EmployeePortal" and "BusinessPortal" have the same outgoing email sett...

Ribbon in 2007
Recently installed 2007 Office Pro When I open Outlook, I do not see 'Ribbon' It seems as if I have the same format of 2003. Could anyone advise me how I can see Ribbon when I open Mail, Contacts, Calendar, etc -- Thank you in advance for your support and suggestions, HankL The main interface of Outlook 2007 does not have a Ribbon. Outlook 2007 does have a Ribbon when you create or open any item such as creating a new email or when opening a contact. Outlook 2010 will have the Ribbon in the main interface as well. -- Robert Sparnaaij [MVP-Outlook] Coaut...

vba help issue
wondering if anyone can help. my vba help system stopped working correctly. some links work, some don't. here are a few examples, and if anyone has any ideas and can see some correlation, please let me know. this is on windows 7, but i have another windows 7 installation and it's fine. search for mod mod operator doesn't work, other 3 do search for inputbox inputbox method and writepassword property don't work inputbox function and all others do search for debug debug object, debug toolbar, use immediate window and understanding conditional compilation d...

Access 97 Installed with 2007 Runtime
Hello. We are running Win7 with Access 97, Access 2007 Runtime and Office 2007 (without Access). When opening an mdb file with Access 97, the db opens fine. However, after closing the database, then opening an accdb file with access 2007 Runtime, I get the following error " There was a problem sending the command to the program." Immediately Access 2007 Runtime goes into the "Please wait while Windows configures Microsoft Office Access Runtime 2007" Following that, the 2007 DB opens with 2007 Runtime. How can I run both Programs and prevent the error ...

How to Install Accounting Express 2008 from Office 2007 Discs
Hi - how do I install Accounting Express 2008 from the Office 2007 discs? Thank you. You don't. It's not there. And, it's no longer downloadable. It's been discontinued. "tmg2010" <tmg2010@discussions.microsoft.com> wrote in message news:3E5641E0-FC17-49FA-9410-D835286AA8B0@microsoft.com... : Hi - how do I install Accounting Express 2008 from the Office 2007 discs? : Thank you. ...

Page numbering Word 2007
Hi! Here's my challenge with Word 2007: Docs I create (using a a simple template (not the Normal template)) place Page X of Y in the footer of page 1 and Page X of Y in the header of the 2nd & subsequent pages. After saving & then re-opening the doc the page numbering on page 1 displays Page 1 of 3 (even though there may be 20+ pages in the doc). I am only able to get the numbering on page 1 to correct itself to the full "Page 1 of Y", if I open the footer or place my cursor on another page or Update the doc. Interestingly the same Page X of Y numbering on ...

Printing both landscape and portrait in same print option
Hey guys I just wonder: Are there any options to choose different print-settings for different pages in one and the same print job from an Excel worksheet when using multiple printingareas? Ex: Side 1 (range A1:H35) is printed as portrait, while side 2 (range C45:AA60) is printed as landscape. I'll be very grateful for help Regards Snoopy Try Tools > Macro > Record new macro......then go through the entire procedure, once more, by hand, then Tools > Macro > Stop Recording........this should give you a macro to do the printing you desire. Vaya con Dios, Chuck, CABGx3 ...