Question Locked

Hide & Secure Excel 2007 Cells

0 helpful

2 replies

by drh4625 Apr 9, 2008 last reply Apr 12, 2008

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

2 replies

Clarifications

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.

This discussion is closed to new replies.