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!)
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
