قالب وردپرس درنا توس
Home / Tips and Tricks / To set up a printable area in Excel

To set up a printable area in Excel



Excel printable area

Sometimes you may need to print a small portion of your Excel spreadsheet. You can always print the entire sheet and only select the important section, but there is an easier way. Here are some tips to help you set up a printable area in Excel.

A printable area is just what it sounds like – you only print the important area you need. It’s a great way to save some paper and make sure people are not distracted by your extra data. Ready to get started?

To set up a printable area in Excel

For our example, we will use a list of contacts. Imagine that you have to print a selected list of contacts to distribute in a meeting.

1. Select the cells you want to include in the printable area.

pressure range 1

2. Go to Page layout tab and find print group. Click now print Area to open a menu.

pressure range 2

3. Select Set the print area.

pressure range 3

4. Now save, close and open your Excel sheet.

5. Go to File and select Print. You should only see the printable area in the preview.

pressure range 4

To delete the print area, follow steps one to three again but select Clear the print area instead of Set the printable area.

pressure range 5

That’s all there is to it. Now you can print any area of ​​the spreadsheet without wasting extra paper.

How much more can I do?

The more Excel skills you learn, the more effective you will gain. If you want to speed up your journey, you may be interested in a learning experience that we found at Tech Deals. You can work with everything from basic skills to advanced functions and take your Excel skills to the next level.

This tutorial is called Complete Excel Package: Startup Toolbox and contains 14 unique courses. You can work with lots of important business functions such as the LOOKUP function, logic functions and even a little VBA. Many of the lessons are business-oriented so they should look good on your CV.

Complete starter kit for the Excel package

Complete Excel suite: Startup Toolbox has a total retail value of $ 2,800 and more than 20 hours of content, but you can dive in for $ 39 right now. Over 250 others have already registered.

Click the button below to find out more.

$ 39 0.00

Complete Excel package: Startup Toolbox

Save $ 2761 0.00

Buy it now

Complete Excel package: Startup Toolbox Buy it now

Save $ 2761 0.00 $ 39 0.00


Source link