Excel: Print a specific area

You can also print a specific area in Excel. In this practical tip, we will show you exactly how this works.

Print a specific area in Excel - how it works

1. Select the cells in Excel that you want to print by holding down the [CTRL] key.
2. Switch to the "Page layout" tab at the top.
3. Click here on "Print area" and then "Set print area".
4. Now you can print your selected area as usual using the "Print" button.

You can also freeze the rows in Excel. Find out what you need to do in the next practical tip. This practical tip is based on Microsoft Office 2010 under Windows 7.