Question about Computers & Internet

Ad

- Select all cells (either press Ctrl+A or click on the small upper left square on the edge of the worksheet)
- In the menu bar, go to Format - Cells
- In the popup menu that opens, click on the Protection tab (it should be the last one on the menu)
- Deselect the small box tagged Locked
- Click on OK. Now all your cells can be overwritten, regardless the protection status of the worksheet.
- Select only the cells containing formulas that you want to hide (If you need to perform multiple selection, you can press and hold down the Ctrl key, while clicking on each cell you want to select)
- In the menu bar, go to Format - Cells
- In the popup menu that opens, click on the Protection tab
- Tick the small box tagged Hidden and the Locked box as well. If you don’t tick the Locked box, other users of your worksheet would be able to overwrite the formula cells, without even knowing that they contain formulas (as they become invisible following this operation).
- Click on OK
- In the menu bar, go to Tools - Protection - Protect Sheet
- If you want, you can input a password for unlocking the worksheet. This will prevent others from unlocking it. If you don’t want to do that, leave the password field blank and press OK.
- Now click on one of your cells containing formulas and look at the formula bar. It should be empty, although the formula is still there. The cell would remain locked, but it would be automatically updated when changing the content of its precedents relating to the contained formula.

Posted on Jun 27, 2009

Ad

Now you need to lock the formulas in excel sheet. So click the selection lock option. After clicking the selection lock option, you can see a popup dialog box. Pass the ok button. Then click the protect sheet and give a password with check the 1st two box. Click the ok. You can again see a popup message for confirming the password. After confirming the password. Now, you successfully look the excel sheet.

Source: Technologish

Posted on May 02, 2018

Ad

Hi there,

Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

When you open Office 2003 files with Office 2007, it works in compatibility mode, so that if you open the files in earlier version (i.e. Office 2003 etc) there would be no issues (reverse compatibility with earlier versions.

Regarding formulas, rest assure that compatibility mode does NOT affect the calculations at all. All formulas are reverse compatible.

So, it is recommended that you may save the file in Word/ Office2007 format. Do review your formulas for errors (if any).

CreativeTECH

Regarding formulas, rest assure that compatibility mode does NOT affect the calculations at all. All formulas are reverse compatible.

So, it is recommended that you may save the file in Word/ Office2007 format. Do review your formulas for errors (if any).

CreativeTECH

May 16, 2011 | Computers & Internet

Parts of the Excel 2007 Screen

Here are the main parts of Microsoft Excel 2007. Thank you for using Fixya !!!

Nov 15, 2010 | Microsoft Windows XP Professional

Ok - if your question is "What is Excel" - then the answer is that it is a spreadsheet program that allows you the ability to compute data (usually numbers) for example, pulling together a list of hours worked by employees and adding them up automatically. It also can be used to develop sophisticated computational models and I have used it to develop professional services proposal sizing tools using formulas and functions ... which is a good segwey into my other answer.

If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

Hope that helps!

Rgds

David

If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

Hope that helps!

Rgds

David

Oct 01, 2010 | Microsoft Office Excel 2007 Upgrade:...

Subtraction can be done in two ways in Office using the following formulas in the formula (fx) bar:

The SUM formula subtracts by changing the sign of the reference. Remember the sign rules, and thus - -x is in effect +x.

- =A1-A2
- =SUM(A1,-A2)

The SUM formula subtracts by changing the sign of the reference. Remember the sign rules, and thus - -x is in effect +x.

Jul 08, 2009 | Microsoft Office Excel 2003 for PC

The formula in both versions is the same:

=countif(range,value)

i.e. The below formula will increase its count by one if any of the 18 cells it's checking are equal to 1.

=countif(A1:B9,1)

=countif(range,value)

i.e. The below formula will increase its count by one if any of the 18 cells it's checking are equal to 1.

=countif(A1:B9,1)

Jan 21, 2009 | Microsoft Office Excel 2003 for PC

Step1. Start Microsoft Excel and open the file you want to change.
Step2. Double-click on the cell where you want the total to appear.
Step3. Press the = key on the keyboard. This tells Excel that you are entering a formula into the cell.
Step4. Enter the formula, then press Enter. Follow the steps below for an example.
Step5. Enter an opening parenthesis character: (.
Step6. Enter a cell name. For example: =(E2.
Step7. Press the + key.
Step8. Enter another cell name and a closing parenthesis character: ). For example: =(E2+E3).
Step9. Enter a minus sign and a third cell name. For example: =(E2+E3)-E4.
Step10. Press the Enter key to accept the formula. The cell will display the sum of the first two cells minus the third cell.
$('.Article .Steps .Image').each(function(i,e){
e = $(e);
e.find('img').error(function(){
$(this).unbind();
e.remove();
});
});

Tips & Warnings

Tips & Warnings

- Formulas are just equations. Instead of adding or subtracting numbers you are adding and subtracting the contents of a cell.
- Excel includes a number of predefined functions to use as well. You can combine the predefined functions into your own formula. (See "How to Use Provided Excel Formulas.")

Dec 03, 2008 | Microsoft Office Professional 2007 Full...

for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

Aug 25, 2008 | Microsoft Office Professional 2007:...

Heyo. I have had this problem before too. This procedure prevents the cells that contain the formula from being edited.

Wayne

- Select the range of cells whose formulas you want to hide. You can also select the entire sheet.
- On the
**Format**menu, click**Cells**, and then click the**Protection**tab. - Select the
**Hidden**check box. - Click
**OK**. - On the
**Tools**menu, point to**Protection**, and then click**Protect Sheet**. - Make sure the
**Protect worksheet and contents of locked cells**check box is selected.

Wayne

Dec 28, 2007 | Computers & Internet

111 people viewed this question

Usually answered in minutes!

thank you so much sir

best regards

×