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.

To start, launch Excel and open a spreadsheet, ... In the Workbook Views section of the View Ribbon, click the button for Page Layout to see how many printed pages your spreadsheet will take.

Select the "Page Layout" tab, and click the "Size" button on the ribbon. The drop-down menu shows the paper size currently selected for the worksheet, including the width and height of the paper.

The view of your Excel sheet will also change from the Normal view to the Page Layout view. Click on all these three blocks one by one until you see the text &[Picture] .

How to set print area in Excel. For the sake of this example, we use a small set of data about employees of a fictitious company. The dataset includes position, division, city, and date of hire.

Choose Dark Gray or Black to turn on Excel's dark mode. Dave Johnson You should now see that Excel has a dark interface, but the spreadsheet itself — the cells in the main part of the page ...