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.
or Go to right of Status bar => click on icon to switch views
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.
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.
Page Layout is a good view to see look like printed document. See and settings Header or Footer on your pages.