You can utilize the paper size, margins, scaling settings to make the Excel sheet bigger while printing. Method 8 –Modifying Page Setup Option of Print Settings Click on thePage Setupoption under the scaling options. You’ll see thePage Setupdialog box after clicking on thePage Setupoption. ...
To make the margins smaller in the printed copy, chooseNarrow Margins. Click on theCustom Marginsbutton, and it’ll take you to theMarginssection of the Page Setup dialog. Set all the margins (top, bottom, right, and left) to0or any value you find suitable. How to Print Selected Ranges...
Excel > page setup > Sheet > Print > Cells Error As... By tikchye_oldLearner57 in forum Excel General Replies: 2 Last Post: 05-16-2006, 11:35 AM [SOLVED] Why is the Print Titles option in Page Setup:Sheet greyed out? By timz in forum Excel General Replies: 2 Last Post: ...
Go to Page Layout Tab. In the Page Setup group, click Print Area. Select Clear Print Area. Easy as 1-2-3!That’s it – Now what? Printing your sheets can sometimes be tricky. But now that you know how to set the Print Area in Excel, you can print your sheets better With the...
How to set multiple print areas in Excel To print a few different parts of a worksheet, you can select multiple print areas in this way: Select the first range, hold down theCtrlkey and select other ranges. On thePage Layouttab, in thePage Setupgroup, clickPrint Area>Set Print Area. ...
2. On the Page Layout tab, in the Page Setup group, click Print Area. 3. Click Set Print Area. 4. Save, close and reopen the Excel file. 5. On the File tab, click Print. Result: only the print area will be printed. See the print preview below. Note: use the Name Manager to...
SelectShow Detailsin thePrintdialog box to print to a PDF file, or to set which pages to print, paper handling options, margins, and scaling. ThePage Layouttab in the ribbon includes more options for page setup and printing, including page orientation, paper size and whether to print ...
In the Page Setup dialog box, use the Fit to boxes to print the view on one page. On the Print page, set the Dates boxes to print the entire year. Notes: If you are printing the Calendar view, you can specify the range of dates to print by using the Dates boxes...
Move to theSheettab of thePage Setupdialog box. Select theGridlinescheckbox in thePrintgroup. ClickOK. You will immediately see your spreadsheet with lines in the Print Preview pane. Note:Excel does not print gridlines around empty cells in a worksheet. If you want to include blank rows and...
If you simply want to include another set of cells in the print area setup, select the cells. Then, go to the Page Layout tab and select "Add to Print Area" in the Print Area drop-down box. When you do this, those additional cells are considered their own print area because they ar...