Please help!
I'm running Excel 2002 on Windows XP at work and I'm making a spreadsheet that needs to be utilized by other coworkers (who happen to be less-than savy with Excel). I have numerous columns of formulas that I can "hide" so they are out of sight and don't confuse anyone. But when entering data, myself or anyone else can select a group of cells for deletion that includes cells on both sides of the hidden columns. In that case, it deletes all the formulas from the cells in between that you can't even see.
Does anyone know of a way to protect the content of the cells which are hidden, so they don't become unknowingly included in a selection set for deletion?
Thank You!
I'm running Excel 2002 on Windows XP at work and I'm making a spreadsheet that needs to be utilized by other coworkers (who happen to be less-than savy with Excel). I have numerous columns of formulas that I can "hide" so they are out of sight and don't confuse anyone. But when entering data, myself or anyone else can select a group of cells for deletion that includes cells on both sides of the hidden columns. In that case, it deletes all the formulas from the cells in between that you can't even see.
Does anyone know of a way to protect the content of the cells which are hidden, so they don't become unknowingly included in a selection set for deletion?
Thank You!
