Cells With Multiple Formulas

gymwrecker · May 3rd, 2002, 06:29 PM

How could I have multiple formulas for just one cell, without damaging any other formulas?

Also, is there a way, that after I protect a spreadsheet, to hide it's formulas? I explain, when someone moves over a cell, hide the formulas within that cell?

Thanks!

Von Pookie · May 3rd, 2002, 06:34 PM

To hide the formulas, unprotect the sheet. Select the cells you want to hide the formulas for, then right click and go to format cells. Click on the protection tab, and mark the checkbox next to "hidden."

Then, protect the sheet again, and you should be set!

gymwrecker · May 3rd, 2002, 06:52 PM

Thank You Kristy!!!

May 3rd, 2002, 06:34 PM	#2
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	To hide the formulas, unprotect the sheet. Select the cells you want to hide the formulas for, then right click and go to format cells. Click on the protection tab, and mark the checkbox next to "hidden." Then, protect the sheet again, and you should be set! __________________ Kristy How to post (Video) Show your sheet on the board (HTML Maker FAQ)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 3rd, 2002, 06:29 PM	#1
gymwrecker Board Regular Join Date: Apr 2002 Location: Fort Knox, KY Posts: 249	How could I have multiple formulas for just one cell, without damaging any other formulas? Also, is there a way, that after I protect a spreadsheet, to hide it's formulas? I explain, when someone moves over a cell, hide the formulas within that cell? Thanks!

May 3rd, 2002, 06:52 PM	#3
gymwrecker Board Regular Join Date: Apr 2002 Location: Fort Knox, KY Posts: 249	Thank You Kristy!!!