In Excel you can switch workbooks view of your document to Normal view, Page Break Preview and Page Layout.

How to switch workbook views

Go to View tab => on the Workbook view group select view that you want. As show below.

Excel Normal view, Page Break Preview and Page Layout

or Go to right of Status bar => click on icon to switch views

Excel Normal view, Page Break Preview and Page Layout

Normal view

Basic view of workbook when you create new a workbook. In Normal view show column letters, row numbers, white background and gridlines in the background of your data.

Excel Normal view, Page Break Preview and Page Layout

Page Break Preview

Page Break Preview show print area of your document will be printed in the white area. As show below. Page number show on background of your document.

The range of cell inside the blue solid lines will be printed. You can drag the blue lines with you mouse to customize you print area.

Excel Normal view, Page Break Preview and Page Layout

Page Layout

Page Layout is a good view to see look like printed document. See and settings Header or Footer on your pages.

Excel Normal view, Page Break Preview and Page Layout