Printing an Excel spreadsheet perfectly can sometimes be more difficult than creating it. Data could get cut off or move to a ...

Click on the Page Layout tab on top of the Excel editor window. Under the Page Setup section, click on the down arrow icon below the Orientation option (the second option in the section).

Select the "Page Layout" tab on the command ribbon. (See References 4) Click or tap to remove the tick from the "View" check box under the Gridlines heading in the Sheet Options group.

The standard page layout for an Excel spreadsheet is portrait. If you need more space for your linear scale, switch the orientation to landscape mode from the Page Layout tab of the Ribbon.

To do so, click the Page Layout button in the bottom-right corner to switch to Page Layout view. In Excel 2003, choose Header and Footer from the View menu. Page Layout is new to 2007.

If Excel is not printing gridlines properly or printing only some gridlines, follow these suggestions to resolve the issue: Enable the print gridline option in Excel. Go to the Page Layout tab.

Select the tab for Page Layout, and click the icon for Orientation (Figure A). ... SEE: 3 Ways to Suppress 0 in Excel. How to set a page break before printing Excel spreadsheets.

To tell Excel 2007 to repeat one or more rows or columns, first chose the Page Layout tab in the Ruler, then Print Titles (in Excel 2003, choose File | Page Setup, then Sheet).

Highlight the print area you want, then select "Set Print Area" from the "Print Area" menu in the "Page Layout" tab. Laura McCamy/Business Insider How to check the print area in Excel 1.