Dec 1, 2008 - Printing doesn't have to be a one to one ratio. Word lets you print multiple pages on one sheet of paper. How to make an histogram in excel 2011 for mac. To create a histogram in Excel 2011 for Mac, you'll need to download a third-party add-in. See: I can't find the Analysis Toolpak in Excel 2011 for Mac for more details. Tell me that Microsoft didn't make that incomplete of a program for the money that they charge. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. The add-in is not available in Excel 2011 for Mac. Go to the Tools menu and click Excel Add-ins. Choose Analysis ToolPak in the Add-ins Available box and click OK. Before creating your histogram, import or input the data you want to display as a histogram in a new Excel workbook table with separate columns or rows for value and frequency data. ![]() I have created a few templates in 5.5 x 8.5 size, which I like because I tend to try to maximize the use of the space available. But When I try to print two pages on one letter sized page, rather than hand feed half size paper to the printer, I cannot get the same maximized size, in Word and Excel, but rather it automatically shrinks everything with a rather large margin on all sides. Could someone tell me how to make Word and Excel print in the same maximized size, when printing two pages to a single letter size paper? I cannot find any controls to do it. Columns the way I'm talking about them is different from the columns you get when you insert a table in Word. I'm talking about columns like you find in a newspaper or in a tri-fold brochure. You can insert a table into a column (and you can also set a specific column width in your tables so they're not moving on you). I believe the column settings are under the Format menu, whereas table column settings are found in 'table properties' under the Table menu. Things can still get a little funky with a column layout if your row heights change--strategic use of the 'column break' (instead of hitting enter at the bottom of the page until the stuff moves to the next page) can help alleviate that wandering tendency. In short: • Open a blank document. • Change the page setup to landscape and set your margins. • Format/Columns and set the layout to 2 columns with a gutter width that's double what you used for your outer margins. You can have it insert a line in the middle so you know where to cut if you want. • Finally, insert your stuff in the leftmost column. Your stuff will automatically wrap to the right-hand column when it reaches the bottom of the page, and thence to the left column of the next landscaped page. You can insert a column break (similar to a page break) to divide stuff up where you want it. You can also insert tables within your columns and format them the way you want them. Hopefully that helps. I use Word for Classic size templates, too. On the Page Setup Margins tab I check the box for 2 pages per sheet, and keep the margins at.5 or.3 inches. On the Paper Size tab, I choose Letter, and Landscape Orientation. I'm using Word 2000 so your version may differ, but I've found this setup very useful. I can print this setup out onto letter size sheets of paper, or on another printer I feed half-size sheets through and print out a page at a time. Word sees each half-size page as a separate page, and the sheet of paper, be it two pages to a sheet or one page to a sheet, is a separate concept. This was confusing to me when I started trying to make it work, but eventually it made sense. I haven't tried to do this sort of thing with Excel so can't help you there. But maybe the same concept works out. I suspect that using the Page Break Preview would be useful. And when I have a multi-page document, and reduce the zoom to 75%, I see two pages side-by-side, as they would print out on a letter-size page. Thanks for the comments.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |