How do I print without the white border in Excel?
Navigate to the tab called General, and look at your Printing Preferences. From the Printing Shortcuts section, choose the option for photo printing - borderless to ensure that whatever document you print, the default will be for your printer not to add any additional borders.
How do I get rid of print borders in Excel?
On the Home tab, in the Font group, do one of the following:To apply a new or different border style, click the arrow next to Borders. , and then click a border style. To remove cell borders, click the arrow next to Borders , and then click No Border .
How do you make a borderless sheet in Excel?
Use the Page Layout tab:On the Page Layout tab, click Margins, and then select Custom Margins....Use the arrows to increase or decrease the margin sizes, or enter the desired size in the appropriate box. When youre done, click OK.18 Jan 2018
How do I make an Excel spreadsheet print the whole page?
Shrink a worksheet to fit on one pageClick Page Layout. Select the Page tab in the Page Setup dialog box.Select Fit to under Scaling.To fit your document to print on one page, choose 1 page(s) wide by 1 tall in the Fit to boxes. Press OK at the bottom of the Page Setup dialog box.
How do I print without scaling?
In the Printer Properties window, select Printing Options. Click on the Paper, and then select Other Size > Advanced Paper Size > Scaling Options. Select an option: No Scaling: This option does not change the size of the printed image.
How do you switch to the view that shows all the worksheet elements as they will print in Excel?
On the View tab, in the Window group, click the Split button. Switch the view that shows all the worksheet elements as they will print, including headers and footers. Click the Page Layout button at the lower right corner of the status bar, to the left of the zoom slider.
How do I change Print scaling?
In the worksheet, click File > Print. Under Settings, click Custom Scaling > Custom Scaling Options. Click Page and in the Adjust to box, choose a percentage by which you want to increase or decrease the font size. Review your changes in Print Preview and—if you want a different font size—repeat the steps.
How do you Print to full scale?
Automatically scale to fit paperChoose File > Print.From the Page Scaling pop-up menu, select one of the following options: Fit To Printable Area Scales small pages up and large pages down to fit the paper. Click OK or Print.Mar 24, 2016