|
CONVERTING Excel 2003 Commands to 2007
Please can you let me know how I may convert these commands into Excel 2007
Unprotect the sheet/ Unlock all cells/ Edit Goto Special Formula Format Cells... Protection Locked..Protect the sheet Thank you. |
CONVERTING Excel 2003 Commands to 2007
The interactive guide at
http://office.microsoft.com/en-us/ex...491511033.aspx will reveal all best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Ra" wrote in message ... Please can you let me know how I may convert these commands into Excel 2007 Unprotect the sheet/ Unlock all cells/ Edit Goto Special Formula Format Cells... Protection Locked..Protect the sheet Thank you. |
CONVERTING Excel 2003 Commands to 2007
Bernard
Thank you for your reply. The series of commands, although worked in 2003, they do not give me the same result in 2007. Any ideas? What I want to do is to hide the conditional formating and formulas, yet still be able to input data into all the cells in the worksheet. Thank you. "Bernard Liengme" wrote: The interactive guide at http://office.microsoft.com/en-us/ex...491511033.aspx will reveal all best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Ra" wrote in message ... Please can you let me know how I may convert these commands into Excel 2007 Unprotect the sheet/ Unlock all cells/ Edit Goto Special Formula Format Cells... Protection Locked..Protect the sheet Thank you. |
CONVERTING Excel 2003 Commands to 2007
Hopefully you meant "still be able to input data into all the cells in the
worksheet THAT DO NOT CONTAIN FORMULAS". Otherwise how can you protect the worksheet? If YES I will give you the steps best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Ra" wrote in message ... Bernard Thank you for your reply. The series of commands, although worked in 2003, they do not give me the same result in 2007. Any ideas? What I want to do is to hide the conditional formating and formulas, yet still be able to input data into all the cells in the worksheet. Thank you. "Bernard Liengme" wrote: The interactive guide at http://office.microsoft.com/en-us/ex...491511033.aspx will reveal all best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Ra" wrote in message ... Please can you let me know how I may convert these commands into Excel 2007 Unprotect the sheet/ Unlock all cells/ Edit Goto Special Formula Format Cells... Protection Locked..Protect the sheet Thank you. |
CONVERTING Excel 2003 Commands to 2007
Bernard
The answer is Yes. Thank you. "Bernard Liengme" wrote: Hopefully you meant "still be able to input data into all the cells in the worksheet THAT DO NOT CONTAIN FORMULAS". Otherwise how can you protect the worksheet? If YES I will give you the steps best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Ra" wrote in message ... Bernard Thank you for your reply. The series of commands, although worked in 2003, they do not give me the same result in 2007. Any ideas? What I want to do is to hide the conditional formating and formulas, yet still be able to input data into all the cells in the worksheet. Thank you. "Bernard Liengme" wrote: The interactive guide at http://office.microsoft.com/en-us/ex...491511033.aspx will reveal all best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Ra" wrote in message ... Please can you let me know how I may convert these commands into Excel 2007 Unprotect the sheet/ Unlock all cells/ Edit Goto Special Formula Format Cells... Protection Locked..Protect the sheet Thank you. |
CONVERTING Excel 2003 Commands to 2007
1 Select all the cells in the worksheet (or at least the area you are using)
2 On the Home tab, click the launcher arrow on the Font group label and open the Format Cells dialog; open the Protection tab and uncheck the "Locked" box to unprotect all cells 3 On the Home tab, locate the Find & Select group at far right and click it; click on Go to. In the Go To dialog check the "Formula" box. Now again use the Home tab, click the launcher arrow on the Font group label and open the Format Cells dialog; open the Protection tab and uncheck the "Locked" box to protect all cells having formulas 4 In the Review tab in the Changes group, click Protect Worksheet. In the resulting dialog there is a list under "Allow all users of the worksheet to:" -- make sure only "Select Unlocked Cells" is checked best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Ra" wrote in message ... Bernard The answer is Yes. Thank you. "Bernard Liengme" wrote: Hopefully you meant "still be able to input data into all the cells in the worksheet THAT DO NOT CONTAIN FORMULAS". Otherwise how can you protect the worksheet? If YES I will give you the steps best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Ra" wrote in message ... Bernard Thank you for your reply. The series of commands, although worked in 2003, they do not give me the same result in 2007. Any ideas? What I want to do is to hide the conditional formating and formulas, yet still be able to input data into all the cells in the worksheet. Thank you. "Bernard Liengme" wrote: The interactive guide at http://office.microsoft.com/en-us/ex...491511033.aspx will reveal all best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Ra" wrote in message ... Please can you let me know how I may convert these commands into Excel 2007 Unprotect the sheet/ Unlock all cells/ Edit Goto Special Formula Format Cells... Protection Locked..Protect the sheet Thank you. |
| All times are GMT +1. The time now is 08:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com