How To Print Pages In Excel 2010. Change the page orientation to portrait to orient the page vertically and landscape to orient the page horizontally. If you want more copies, or more or less data (such as all the worksheets in the workbook or just a cell selection within a particular worksheet), then you need to print from the print panel in excel 2010's new backstage view.
Go to the setting section, and select the fit sheet to one page in the no scaling drop down box. Press ctrl+p and then click the print button (or press enter). First, select the range of cells you want to print.
Choose File » Print (Which Displays The Print Pane), And Then Click The Print Button.
Under settings, click the arrow next to print active sheets and select the appropriate option. How to print all columns on one page in excel 2010. To do it, follow these steps:
Click File > The Print Option To Access The Printing Settings.
Open the file menu bar and click on print. To do this, select the cells you want to print, go to the page layout tab, and choose print area. Display the print dialog box.
Note That Another Way To Access This Dialog Box Is To Choose File > Print And Then Select Page Setup.
Click on the options button. Click on the main part of the worksheet page to move the cursor away from the footer click on the view tab. (see figure 1.) figure 1.
Please Note That Using This Option Will Ignore Any Manual Page Breaks.
Tap alt+q to return to your worksheet then alt+f8 to open the macros dialog and run the macro. Use the print panel in backstage view to change common print settings. For this very purpose, open the file and press ctrl + p.
Landscape − Landscape To Print Wide Pages.
Popular course in this category. Page orientation refers to how output is printed on the page. Using the pages per sheet control, specify how many pages you want printed on each sheet of paper.