To Hide a formula:

- Select the cell(s) with formulas to hide
- Right-Click one of those cells
- Select "Format Cells..."
- Choose the Protection Tab
- Check the "Hidden" and "Locked" boxes
- OK (Note that the formulas will not actually be hidden until the
worksheet is Protected. See below.)

Now to allow other cells to have data entered:

- Select the cell(s) for data entry
- Right-Click one of the cells
- Select "Format Cells..."
- Choose the Protection Tab
- Uncheck the "Hidden" and "Protection" boxes
- OK

Now, Protect your worksheet. On the Review Tab, click the "Protect Sheet"
button.

That should do it.

HTH
Elkar

"Carrie" wrote:

I'm creating a spreadsheet for other users to enter data in and one of the
cells has a formula that I don't want them to see. I've got it to where I
can hide it on the first row but when I tab down to the next row it won't let
me enter any data. Is there a way to hide the formula in that column without
messing up the rest?