To print the active sheet on a single page, do the following: 1  Choose Page Setup from the File menu. 2  On the Page tab, click Fit To in the Scaling section. 3  Make sure both Wide and Tall settings are 1. 4  Click OK. 5  Click the Page Layout tab. 6  Click the Scale To Fit group's launcher. 7  On the Page tab, click Fit To in the Scaling section. 8  Make sure both ...
http://www.techrepublic.com/blog/five-apps/five-tips-for-printing-excel-data-more-efficiently/
What to Print. Instead of printing the entire worksheet, you can also only print the current selection. 1. First, select the range of cells you want to print. 2. Next, under Settings, select Print Selection. 3. To print the selection, click the big Print button. Note: you can also print the active sheets (first select the sheets by holding down CTRL and clicking the sheet tabs) or print the entire workbook. Use the boxes next to Pages (see first screenshot) to only print a few pages of your document.
http://www.excel-easy.com/basics/print.html
Sometimes, rather than moving an existing page break, you might want to insert a manual break, as follows: 1  Select the row or column where you want to insert the break. 2  Choose Page Break from the Insert menu. 3  In Excel 2007 and 2010, click the Page Layout tab.
http://www.techrepublic.com/blog/five-apps/five-tips-for-printing-excel-data-more-efficiently/
Next. I have just created a file in Excel and I have set it so that there are 10 different workbooks (the tab thingies at the bottom) and I'd like each workbook to print the gridlines.
https://uk.answers.yahoo.com/question/index?qid=20070530075252AAcVLHU
Best Answer: Yes it is possible but using a macro (both for copying the page setup properties to the other workbooks and for printing).
https://uk.answers.yahoo.com/question/index?qid=20070530075252AAcVLHU
you can set up a template, check in HELP, this should allow you use those settings as a default. I pasted the below notes from Excel help-templates. Hope this helps. Settings you can save in a template Show All Hide All Formatting Cell and sheet formats. Set by using the commands on the Format menu. Page formats and print area (print area: One or more ranges of cells that you designate to print when you don't want to print the entire worksheet.
https://uk.answers.yahoo.com/question/index?qid=20070530075252AAcVLHU
Step 3: Click the Print option in the column at the left side of the window. Step 4: Click the Print Active Sheets drop-down menu at the center of the window, then choose the Print Entire Workbook option. Step 5: Click the Print button at the top of the window to print your workbook.
http://www.solveyourtech.com/how-print-entire-excel-2010-workbook/
To print a worksheet in Excel 2010, execute the following steps. 1. On the File tab, click Print. 2. To preview the other pages that will be printed, click 'Next Page' or 'Previous Page' at the bottom of the window. 3. To print the worksheet, click the big Print button.
http://www.excel-easy.com/basics/print.html
Additionally, you can reference data in other worksheets as parts of formulas. Now that you will know how to print all of the worksheets in an Excel workbook at once, you will have one more reason to embrace the multiple worksheet format. Step 1: Begin by opening your Excel workbook.
http://www.solveyourtech.com/how-print-entire-excel-2010-workbook/
1 Select the range you want to print. 2  Click the Office button or the File tab. 3  Choose Print in the left pane. 4  Choose Print Selection from the first Settings drop-down (Print Active Sheet is the default).
http://www.techrepublic.com/blog/five-apps/five-tips-for-printing-excel-data-more-efficiently/
how to apply print settings to an entire excel workbook
To apply print settings to an entire excel workbook: 1. On the File tab, click Print. 2. To preview the other pages that will be printed, click 'Next Page' or 'Previous Page' at the bottom of the window. 3. To print the worksheet, click the big Print button.