0
How can you protect a formula in excel just the formulas not the spreadsheet?
Wiki User
∙ 14y ago
Format the entrie spreadsheet with all cells unprotected, except for the cells containing formulas you want to protect. When you turn on worksheet protection, only those cells that are formatted to be protected, will be protected.
There are two steps to protecting a worksheet:
- Format the cells you want to protect. Default is protection on for all cells, so if you do not want a cell to be protected, you need to slect cell format and uncheck the option to protect that cell.
- Activate protection for the worksheet. Default is protection off for the worksheet.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What must you type to start off a formula in Excel?
Excel formulas begin with an equal sign, for example:=SUM(A1:A7)will give you the total of the numbers in cells A1, A2, A3, A4, A5, A6 and A7.Array formulas start with = but are enclosed in brace bracket{}.You can also use the plus or minus sign to start a formula, but as soon as you press Enter, a plus will be converted into an equals sign and a minus sign will have an equals sign inserted before it, so the formula will still show as starting with an equals sign.+5+7 will become =5+7-10*2 will become =-10*2Lotus 123 was the big spreadsheet application before Excel. It used the @ sign to start its functions. In order to help people moving from using Lotus 123 to Excel, the ability to start functions with the @ sign was included in Excel, and you can still do that. This applies only to functions at the start of a formula, not any formula.
What does ctrl accent mark do in excel?
It displays the formulas in your spreadsheet.
What fundamental feature of spreadsheet software provides the real power behind its calculation capabilities?
The real power behind a spreadsheet's ability to calculate is derived from formulas. Spreadsheet programs like Microsoft Excel are capable of handling hundreds of formula.
How do i protect an Excel spreadsheet?
Go to review menu and select 'Protect sheet' option.
How do you deactivate circular reference in Microsoft Excel?
A formula cannot directly or indirectly refer to the cell the formula is in. If it does, you get a circular reference. You need to check through your formulas and find out what is causing it. Then you need to fix your formulas. If you don't, your spreadsheet will not work.
Can procedures be used in Excel formulas?
Procedures are associated with programming. You would have them in Visual BASIC for Applications, commonly known as VBA, and these can manipulate a spreadsheet. However you cannot have procedures direct in a formula in the sheet itself. So procedures can be used in Excel but not in formulas.
'How do you do formulas on Excel and continue to work with answer as a numerical value and not a formula '?
'How do you do formulas on excel and continue to work with answer as a numerical value and not a formula '
What is underlying formula in Excel?
An underlying formula in Excel is used in a spreadsheet to do something different than the formula does. An underlying formula can be used to remove values or display numbers.
What is the formula for sound on spreadsheet?
There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.
Why are Excel formulas useful?
It is important because without the formula's , we will be able to do nothing in Ms Excel , such as, Subtract, add , divide , etc .. i know sometimes it feels really ridiculous learning all those formulas but it is essential to do so ~!!!!
What is Excel and Entourage?
Excel is a Microsoft software designed to calculate formulas and is in a spreadsheet layout. Entourage is the Mac version of Microsoft Outlook.
Where is the formula keyed in spreadsheets for Excel?
In the cell and on the formula bar at the top of the screen, just below the menu bar or ribbon.
