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

Gearing up for the new FASB lease accounting standard

Management accountants in the United States face significant challenges as companies prepare for the far-reaching change. This report looks at the standard, common challenges companies are likely to face and first steps to consider.

CHECKLIST

Being responsive to clients

CPAs and their firms have daily pressures and hectic schedules, but being responsive is crucial to client satisfaction. Leaders in the profession offer advice for CPA firms that want to be responsive to clients.

QUIZ

Learn to choose between ‘who’ and ‘whom’

Writers can stumble over who and whom (or whoever and whomever). If you write for business, this quiz can help make your copy above reproach.