0

So I have certain rows and columns hidden in my workbook. When I input a formula, all those hidden rows and columns unhide. Is there a way to keep those rows and columns hidden during the input of a formula?

Improve this question
2
  • 2
    This is a question regarding use of Excel, not about programming or creating a complex formula. As such, it's off-topic here. It's better suited for Super User instead. This site is for programming (code) and programmer's tools related questions. The help center has more information. Good luck.
    – Ken White
    Feb 7, 2014 at 21:10
  • 1
    I find it odd to put a formula in a hidden cell. All the same, I just tried it and the hidden column doesn't unhide on my Excel-2007.
    – Jerry
    Feb 8, 2014 at 8:03

1 Answer 1

Reset to default
-1

You can use separate worksheets for your formulas and protect them by passwords. Then formulas in this worksheet don't get visible, but you can access the values calculated inside the protected worksheet. When protecting the worksheet, any kind of access to this worksheet has to be forbidden for "all users".

Improve this answer

You must log in to answer this question.