H Himanshu New Member Jul 29, 2010 #1 Hi Everyone, Hope every is doing great. One quick question How do i hide formulas in a sheet and keep that sheet editable by others. Thanks in adance.
Hi Everyone, Hope every is doing great. One quick question How do i hide formulas in a sheet and keep that sheet editable by others. Thanks in adance.
Hui Excel Ninja Staff member Jul 29, 2010 #2 On the cells with the formula Select Cells and goto Format Cells "Ctrl 1" Select the Protection Tab and Tick the Hidden Box Goto the Review Tab and select Protect Sheet, Put a pasword on if required
On the cells with the formula Select Cells and goto Format Cells "Ctrl 1" Select the Protection Tab and Tick the Hidden Box Goto the Review Tab and select Protect Sheet, Put a pasword on if required
