1.HOW TO HYPERLINK THE FORMULAS IN PRESENT SHEET1 OF A WORKBOOK TO SHEET2 IN THE SAME WORKBOOK ?
2. HOW TO LOCK CELLS AND PERMIT USER TO EDIT SOME CELLS ONLY.
First, pass the Ctrl + A for select the full worksheet, then the right click of your mouse. Now select the format cells on the menu.
After clicking the format cells, you see a popup dialog box. Now click the protection option. After clicking the protection option, now you need to unchecked the locked option. Then pass the ok. Now your worksheet is fully unlocked.
For More: read here
1. You can do it by-inserting a hyperlink and from the "insert hyperlink" window, select "place in this document" from the "Link to" pane. Then you can select desired destination sheet
2. First from unlock all cells from the format-protection menu.
then lock only those cells which you want to restrict access to the users.
then if you are using Office 2007, from the "review" tab select "protect sheet" then uncheck "Select locked cells" check box.
click ok then you are done.
Keyboard shortcut You can also press CTRL+C.
Keyboard shortcut You can also press CTRL+V.
Notes
180 views
Usually answered in minutes!
×