How To: Change Excel options directly in the Registry

Change Excel options directly in the Registry

How to Change Excel options directly in the Registry

This video shows us the method to block the formula bar, scroll bars and the status bars in Excel. Click on 'Start' and type 'regedit'. Click on 'regedit' and go to 'HKEY_CURRENT_USER'. Open it and go to 'Software' and 'Microsoft'. Expand it and go to 'Office' and open the version of Office on your computer. Expand it and go to Excel. Choose the options folder. Go to the 'Options' item and right click on it. Go to 'Modify' and type 150 in the text box. Click on 'OK'. Now restart the Excel and you can see that the formula bar, scroll bars and the status bars have been blocked. You can unblock it by typing 57 in the text box opened previously. This finishes the task.

1 Comment

Even for 156 and 157 also Formula bar will be Enabled
and for 154 and 155 it is Disabled

Share Your Thoughts

  • Hot
  • Latest