Print preview is a feature in Excel that allows you to view your worksheet on a page before you print it. This can be helpful if you want to make sure that your worksheet will fit on one page, or if you want to see how your worksheet will look when printed. To use print preview, click the File tab, and then click Print. The Print dialog box appears.
In the Settings section, click the drop-down arrow next to Printer, and then select Microsoft XPS Document Writer from the list of available printers. This will allow you to view your worksheet as it will look when printed.
Click the Print button to open the Print Preview dialog box. In this dialog box, you can use the navigation buttons at the bottom to view different pages of your worksheet. You can also zoom in or out of your worksheet by clicking the Zoom In or Zoom Out buttons.
When you are finished viewing your worksheet in print preview, click the Close button. You will be prompted to save your changes before closing.