![]() |
Hidding formulars used in a worksheet
I don't want the formular I used in the worksheet to display on the formular
bar. How do I do this? |
Hidding formulars used in a worksheet
One way,
Select all the cells in your worksheet by clicking in the small grey box to the left of column A. The click Format - Cells - Protection and remove the locked checkmark. Now select your cells with formula in and click Format - Cells - Protection and check the hidden box. Protect the worksheet and your formula are now hidden. Mike "Worksheet Formulars" wrote: I don't want the formular I used in the worksheet to display on the formular bar. How do I do this? |
All times are GMT +1. The time now is 06:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com