Microsoft Excel help… How do I print different pages?
Question: I have a Microsoft Excel sheet that has about 1500 lines of info on it. On the first page it has a list of 30 machines I work on (I work in a repair facility). So if I want to print out say machine number 5 , 10, and 22 I will go to File, Print and print that corresponding page. (For example 5). Then it would print out page 5. Then I will do the same for machine 10 and 22. (So it will print out page 10 and 22) Now my question is how can I print out those 3 pages in one shot without having to do the steps 3 times. Thanks I tried using commas, it doesn't work. It would say "Integer is not valid". I'm trying to print multiple pages, not worksheets. thanks
Best Answers: Microsoft Excel help… How do I print different pages?
Open up your Excel workbook. Click FILE and select PAGE SETUP and the PAGE SETUP dialog box appears. Click the SHEET tab. On the PRINT AREA, click the little box, at end of the bar. This will cause another dialog box to appear, PAGE SETUP -PRINT AREA. With PAGE SETUP-PRINT AREA hovering over the worksheet, go to page 5 . Scroll over the cells. Let go. The cell's location will automatically show up in the print area formula bar, like this (sample): A5098:J5104 Then when the cells show up in the bar, add in a comma and then go to the next page, page 10, and select the cells you want from page, and then add a comma to the formula and then do the same with page 221. Sample, A5098:J5104,A5116:G5118, When you are done, click Enter. The PAGE SETUP dialog box appears again. Now click Print Preview. Format. Print.
I'd rather recommend you to print first the odd pages of your document, then flip the papers and print the even pages. Depending on your printer you might also need to reverse print order. That's how it works: 1) To print only odd pages: Press Ctrl+P, choose Print: odd pages (lower left) and hit OK. To print even pages, just choose the other option. 2) Reverse print order If you need to reverse print order, press Ctrl+P, Options (lower left), click at Printing options: reverse print order and hit OK.
In the Print dialog, you can choose a Print Range and a Print What. Print Range allows you to choose the first and last page numbers to print. Print What allows you to choose between printing the entire workbook, just the current selection, or the active worksheets. I'm not sure from your question whether you really mean "pages" or "worksheets", though. EDIT: Now that you've clarified "pages" vs. "worksheets," I think the only method is to select the cells you want to print and use the "print selection" option on the print dialog.
save it then exit Word, then open word back up and try printing it again. check to see if you are able to print properly from other microsoft office applications such as excel, access and powerpoint. If it doesn't, restart the computer then try again. If it still isn't printing properly, go to control panel and Add/Remove (Programs and Features) and click on Microsoft office, and instead of uninstalling, do a installation repair.
When selecting a page, you could use ranges by seperating the start value and end value with a - ( ex: print page 5 to 12: 5-12) You could also select specific pages using commas to seperate them ( ex: print 5, 10 and 22: 5,10,22 )
Most likely cause is a driver setting NOT a printer setting, especially if it's 1 used on a networked printer. You list the paper size in tray as lettre (so I assume you are in USA) make sure the printer driver is set to match this size, and that the document size in word is set to this also. I can't recall if it's letter or A4 is slightly longer, but if either way 1 is slightly longer and narrower than the other. So if printer and driver are not set to match it could be throwing line feeds in odd places. Try a print from a different application, for example, does a windows test page throw a spare page afterwards ? If you print 2 pages worth of raw text from Notepad does it throw extra pages. If yes, then remove printer driver and reload it CHECKING all the settings, if they previously looked OK, if you found a setting in driver looked wrong, try that first. If it still does it, try installing driver on a different PC (laptop?) and test from there, if it still does it contact local HP support team, if it doesn't then look into software setup on the "problem" machine. having spent 5 yrs fixing printers I can assure you most problems of this nature are simply a driver setting, or a printer option setting, or can even be the paper tray guides not set right, so middetecting paper sizes.
If you have your own answer to the question Microsoft Excel help… How do I print different pages?, then you can write your own version, using the form below for an extended answer.