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

In focus: Payroll

Providing payroll services that comply with ever-changing regulations and meet evolving employee and employer demands is no easy task. Paychex's Tom Hammond discusses common payroll considerations for CPA firms.

PODCAST

A closer look at threats to CPA licensure

Legislation in states around the country could put CPA licensure in danger. This episode examines what practitioners need to know to help ensure the profession is protected.