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

Taking stock of artificial intelligence

Artificial intelligence is either the greatest thing to ever happen to human work or the dread of our existence. This independently written report explores how AI will reshape the workplace and how analytically minded individuals can stand out.

PODCAST

How tax reform will impact individual taxpayers

Amy Wang, a CPA who is a senior technical manager for tax advocacy at the AICPA, answers to some of the most common questions on how the new tax reform law will impact individual taxpayers.