Simple Way to Hide Excel Data

BY STANLEY ZAROWIN


Is there a way to hide the numbers in certain Excel cells without a lot of formatting fuss or the use of passwords? I need to be able to print versions of a spreadsheet without showing certain data. Likewise, I don’t want them showing in the worksheet, but I do want to be able to access them easily.

I know one way, and it surely is simple. Select the cell you want to hide and right-click on it. Choose Format Cells . Be sure you’re in the Number tab and scroll down to Custom and in the Type space, enter three semicolons (; ; ;) as shown in the screenshot below and click on OK .

While you can’t see the information in the cell, its contents are displayed in the Formula bar (see screenshot).

SPONSORED REPORT

Keeping client information safe in an age of scams and security threats

A look at the Dirty Dozen tax scams and ways to protect taxpayer information.

TAX PRACTICE CORNER

More R&D tax help

"Can I use the R&D credit?" PATH Act enhancements make the credit more attractive to a wider range of taxpayers.

QUIZ

News quiz: Tax-related data breach explained

News about a data breach that affected about 100,000 people, the IRS’s budget for the fiscal year, and the 2018 health spending account limits received attention recently. See how much you know with this short quiz.