Hi All
How to Hide the Formula in a cell.
That is we have to get the answer in that particular cell only, but nobody should know that the formula that we have typed.
Pls... Help me as soon as possible.
Regards
Ashwini K
From India, Bangalore
35How to Hide the Formula in a cell.
That is we have to get the answer in that particular cell only, but nobody should know that the formula that we have typed.
Pls... Help me as soon as possible.
Regards
Ashwini K
From India, Bangalore
Dear Aswhini
Greetings!
Every cell has two key properties: locked and hidden. A locked cell can't be changed, and the contents of a hidden cell don't appear in the formula bar when the cell is selected. By default, every cell is locked and not hidden. But it's important to remember that these attributes have no effect unless the worksheet itself is protected.
First, to change the attributes, select the appropriate cell or range and then choose Format, Cells. In the Format Cells dialog box, click the Protection tab and select Locked or Hidden (or both). Unlock cells that accept user input, and lock formula and other cells that should stay unchanged (such as titles). To prevent others from seeing your formulas, lock and hide the formula cells: The results of the formulas will be visible, but the formulas will not.
Now, to protect the worksheet, choose Tools, Protection, Protect Sheet to bring up the Protect Sheet dialog box. Make sure the Contents box is checked. You can enter a password to prevent others from unprotecting the sheet. Locked cells in a protected sheet cannot be edited, and other worksheet changes are disabled. For example, no one can insert rows or columns, change column width, or create embedded charts.
NOTE: Keep in mind that it is very easy to break the password for a protected sheet. If you are looking for real security, this is not the solution.
Mean whil u can visit http://www.lacher.com/toc.htm
Rgds,
John N
From India, Madras
Greetings!
Every cell has two key properties: locked and hidden. A locked cell can't be changed, and the contents of a hidden cell don't appear in the formula bar when the cell is selected. By default, every cell is locked and not hidden. But it's important to remember that these attributes have no effect unless the worksheet itself is protected.
First, to change the attributes, select the appropriate cell or range and then choose Format, Cells. In the Format Cells dialog box, click the Protection tab and select Locked or Hidden (or both). Unlock cells that accept user input, and lock formula and other cells that should stay unchanged (such as titles). To prevent others from seeing your formulas, lock and hide the formula cells: The results of the formulas will be visible, but the formulas will not.
Now, to protect the worksheet, choose Tools, Protection, Protect Sheet to bring up the Protect Sheet dialog box. Make sure the Contents box is checked. You can enter a password to prevent others from unprotecting the sheet. Locked cells in a protected sheet cannot be edited, and other worksheet changes are disabled. For example, no one can insert rows or columns, change column width, or create embedded charts.
NOTE: Keep in mind that it is very easy to break the password for a protected sheet. If you are looking for real security, this is not the solution.
Mean whil u can visit http://www.lacher.com/toc.htm
Rgds,
John N
From India, Madras
Hi Ashwini,
I am Radhiga , every day i am working in excel. i thing my suggestion is helpful to u
if u want to send that excel sheet as mail , it is easy
1. u add one worksheet
2. copy all the item in the old sheet
3. paste that in the new worksheet with the help paste special ( in that select values )
4. u identified that all the values are copied with the hide of formula
From India, Madras
I am Radhiga , every day i am working in excel. i thing my suggestion is helpful to u
if u want to send that excel sheet as mail , it is easy
1. u add one worksheet
2. copy all the item in the old sheet
3. paste that in the new worksheet with the help paste special ( in that select values )
4. u identified that all the values are copied with the hide of formula
From India, Madras
Hi,
I think this procedure might help you.
1.Select the required range of cells formulas you want to hide or the entire sheet.
2.Go to Format menu, click on Cells.
3 Click the Protection tab.
4.Select Hidden check box. (you can use the additional information is already mentioned in the same template).
5.Click OK.
6.Go to Tools menu, select tab Protection.
7. Click on Protect Sheet.
Regards,
Ramesh.
I think this procedure might help you.
1.Select the required range of cells formulas you want to hide or the entire sheet.
2.Go to Format menu, click on Cells.
3 Click the Protection tab.
4.Select Hidden check box. (you can use the additional information is already mentioned in the same template).
5.Click OK.
6.Go to Tools menu, select tab Protection.
7. Click on Protect Sheet.
Regards,
Ramesh.
Hello Friends,
Please check the attached file.
It will ask for a "password" to open. However you can open it as a "read only file" without a password.
Open as a read-only file - go through the contents. Hope this will clear the doubt about hiding the formula in a cell.
Regards,
RAJA
From India, Madras
Please check the attached file.
It will ask for a "password" to open. However you can open it as a "read only file" without a password.
Open as a read-only file - go through the contents. Hope this will clear the doubt about hiding the formula in a cell.
Regards,
RAJA
From India, Madras
1. Select the cell containing the formula
2. Click Edit/Copy
3. (if you want to keep the result of the formula in the same cell) Click Edit/Paste Special
4. In the selection window that appears, tick the box 'value' and click okay
5. Press Esc
Now you will find that the formula has vanished but you have lost the formula for ever!
If you do not want to lose the formula, You can copy the entire worksheet and do the paste special into another worksheet. You can then delete the worksheet with the formulae after making a copy for your safe custody only.
R Ramamurthy
Consultant in TQM
From India, Bangalore
2. Click Edit/Copy
3. (if you want to keep the result of the formula in the same cell) Click Edit/Paste Special
4. In the selection window that appears, tick the box 'value' and click okay
5. Press Esc
Now you will find that the formula has vanished but you have lost the formula for ever!
If you do not want to lose the formula, You can copy the entire worksheet and do the paste special into another worksheet. You can then delete the worksheet with the formulae after making a copy for your safe custody only.
R Ramamurthy
Consultant in TQM
From India, Bangalore
Hi John,
Can you let me know how to break the password in an excel sheet, I cant seem to remember the password & would need it urgently as I have to collate huge data for my teams & currently I am copying & pasting the data which takes a lot of time in read only mode.
Can you help me in this regard pl.
Regards,
PGee
Can you let me know how to break the password in an excel sheet, I cant seem to remember the password & would need it urgently as I have to collate huge data for my teams & currently I am copying & pasting the data which takes a lot of time in read only mode.
Can you help me in this regard pl.
Regards,
PGee
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Advanced Excel 2003.pdf
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip
Competancy--exc el---mts___smts _289.xls