Hide & Secure Excel 2007 Cells

By drh4625 ·
I'm trying to hide & secure columns reflecting cost & margin formulas. I've tried Hide & Wook Book Protect without success.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Format cells/protection/locked and hide

by jpp412 In reply to Hide & Secure Excel 2007 ...

Select the column or cells and right click - select format cells. Select the tab for protection. Click locked and hide (both checkboxes) and apply.

Now select tool/protection/protection sheet. Add a password.

The hide checkbox that you checked in step 1 will hide the formulas.

Related Discussions

Related Forums