File Menu->Page Setup...
on "Sheet" tab in the middle "Print" section
there is a drop down box labeled "Comments"
Choices are "(none)", "at end of sheet", or "as displayed on sheet"
Discussion on:
View:
Show:
Ok, this is a great tip. However I do have a question: How does one print multiple worksheets in excel as a single duplex document?
Perhaps I state the obvious, but when you select "File/Print" from the menu, the 'Print' window has a selection radio button at the bottom to print the entire workbook. Complete workbook prints out in the order of pages within each spreadsheet from left tab to right tab. Page numbering in footer will reflect the total pages in the workbook.
ONe can also print some of the pages in the workbook by selecting the pages you wish to print. This also prints out in the order of pages left to right, and page numbering in header/footer again repflects the number of pages printed.
Go to File, Page Set-up. On the Sheet tab, look in the middle Print section; should be an option for Comments. Select "None," "At End of Sheet," or "As Displayed on Sheet."
I tried to do this but my Comments in the Print section is grayed out and I cannot make a selection of "None", "At End of Sheet" or "As Displayed on Sheet". What am I doing incorrectly?
I am running Office 2000 Premium and that menu is active. File | Page Setup | Sheet, right in the middle of that box are the four checkboxes for "Gridlines", "Black & White", "Draft Quality", Row & Column Headings", and there is the little drop-down box that allows you to specify if you want comments printed and where you'd like them to print.
Perhaps you have installed a limited or "light" version of Excel?
Perhaps you have installed a limited or "light" version of Excel?
Actually I'm using Office 2007 Premium. I discovered what I was doing incorrectly. I opened my spreadsheet and did a print preview and then went into page setup. I cannot access the Comments section via that method. I also cannot access the Comments section if I go throught File | Print | Preview | Page Setup. I CAN ACCESS the Comments section if I go through Page Layout | Page Setup | Sheet method. Go figure! Thanks for your help.
This is a "Feature" of Excel that has been around for years. *Some*of the choices in page setup are available in print preview, but not all. Always going through pagelayout/page setup is the best way to make those kinds of changes.
To be able to select the options mentioned previously, you must use the Menu - File, Page Setup. If you bring up Print Preview Window and try to use the Setup options, you will find many of them not available, including the Comment options.
On the Page Layout ribbon, click on the tiny arrow to the right of Page Setup. The Comments section won't be grayed out.
At least in Office 2007, you have to have the comments displayed in the worksheet before they will print (either as displayed or at end of sheet). To display all comments at once for printing, Review Tab, Comand Group, Show All comments command. Then you can follow the other directions given for printing the comments.
I have an Excel sheet that prints as two pages. How do I get rid of the blank spaces on the right side of the page and print only the data?
Is it just blank spaces on the right hand side of the sheet?
If this "extra" is on the right hand side, I'm assuming you've already selected "landscape" from the Page Setup menu?
If so, and you already have chosen "landscape" print (from page setup), then it's just a matter of setting your margins.
After you go to Page Setup, and set everything you want, and then go to Print Preview and take a look at how it's going to look, you'll see light dotted lines that indicate the "print area"... that'll let you know if something is way out of range or not.
Hope that helps
If this "extra" is on the right hand side, I'm assuming you've already selected "landscape" from the Page Setup menu?
If so, and you already have chosen "landscape" print (from page setup), then it's just a matter of setting your margins.
After you go to Page Setup, and set everything you want, and then go to Print Preview and take a look at how it's going to look, you'll see light dotted lines that indicate the "print area"... that'll let you know if something is way out of range or not.
Hope that helps
- Keyboard Shortcuts:
- Prev
- Next
- Toggle
