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.
While you're stuck at home, make the most of your time by learning a new language, skill, or even train for a remote-work job with our new premium online courses.
1 Comment
Even for 156 and 157 also Formula bar will be Enabled
and for 154 and 155 it is Disabled
Share Your Thoughts