How to format a Excel file for printing

With Excel, it is not that easy to get it as a PDF the way you want it to look. Below you will find the procedure so that you receive the documents as you imagine them:

1. Set the page orientation
2. Specify the print area
3. Specify the number of pages
4. save as PDF

Set the page orientation

First we determine whether we want to print the file in portrait or landscape format:

1. Click on “Page layout”
2. Click on “Alignment”
3. Select portrait or landscape

Specify the print area

Then we choose what should be printed:

1. Select cells with left click and hold
2. Click on “Page layout”
3. Click on “Print Area”
4. Click on “Set print area”

Define page width

Then we choose what should be printed:

1. Click on “Page layout”
2. Select the desired width in the “Width” field. Often this is “1 page” wide
3. Set “Height”: If you want everything to be on one side, select “1 Page”. If you want to let Excel determine itself, choose “automatically”