Good day,

This week, let's talk about obfuscating or hiding data (temporarily) in Excel so that we don't accidentally print or export sensitive data, like salary, contact information, etc.

(Let me know what you think in the comments on youtube!)

Hide Data for Printing

Can’t see the thumbnail? Click here to watch on YouTube

Last Week's Tutorial: Numbered Text in Excel!

[Tiny Tip] Make Excel Print Exactly What You Want

Ever wanted to print just one small section of an Excel worksheet without printing everything else?

You don't need to hide rows, delete columns, or change your worksheet's print area.

The trick is to use Print Selection instead of Print Active Sheets.

Step 1: Select What You Want to Print

Open a worksheet that contains data you want to print.

Select only the cells you want to include in your printout.

For example, if you have a large worksheet but only want to print a small report in cells A1:F15, select that range.

Everything outside your selection will be excluded from the printout.

Step 2: Open the Print Settings

Press Ctrl + P to open Excel's Print screen.

Under Settings, find the dropdown menu that normally says Print Active Sheets.

Click that dropdown to see the available printing options and select Print Selection.

Step 3: Print

Check the Print Preview to make sure the correct data appears and everything fits on the page as expected.

When you're satisfied, click Print.

That's it! Excel prints just your selected range without including the rest of the worksheet.

Note

Unlike using Page Layout > Print Area > Set Print Area, the Print Selection option doesn't permanently define a print area in your worksheet.

You can select a completely different range the next time you print without changing any saved print-area settings.

Use Print Selection for quick, one-time printouts and Set Print Area when you regularly need to print the same section of a worksheet.

Excel AI

Fix or add features to your macros with the click of a button using our new tool.

Courses

Cheers and see you next week!

Don