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.
- Hot
- Latest
-
How To:
Find a P-Value with Excel
-
How To:
Create a Basic Attendance Sheet in Excel
-
How To:
Create an Excel spreadsheet to calculate your GPA
-
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
-
How To:
Clear data & cell contents in Excel using a macro
-
How To:
Insert or delete footnotes & endnotes in MS Word 2007
-
How To:
Generate random numbers (with decimals) in Excel
-
How To:
Create a simple database in Excel with a list or table
-
How To:
Pull data from a master sheet in Microsoft Excel
-
How To:
Convert WORD DOC to PDF in Office 2007
-
How To:
Group duplicates & extract unique records in MS Excel
-
How To:
Track cash on hand with a table Microsoft Excel 2010
-
How To:
Create a pass-fail grade formula in Microsoft Excel
-
How To:
Create a relative frequency distribution in MS Excel
-
How To:
Enter formulas in Excel with a macro
-
How To:
Create a cumulative frequency distribution in MS Excel
-
How To:
Build a 15-minute schedule in Microsoft Excel
-
How To:
Measure the spread of a data set with Excel's AVEDEV
-
How To:
Create a Tangent Line with Excel
-
How To:
Calculate proportions and percentages in Excel
-
How To:
Find a P-Value with Excel
-
How To:
Create a Basic Attendance Sheet in Excel
-
How To:
Create an Excel spreadsheet to calculate your GPA
-
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
-
How To:
Clear data & cell contents in Excel using a macro
-
How To:
Insert or delete footnotes & endnotes in MS Word 2007
-
How To:
Generate random numbers (with decimals) in Excel
-
How To:
Create a simple database in Excel with a list or table
-
How To:
Pull data from a master sheet in Microsoft Excel
-
How To:
Convert WORD DOC to PDF in Office 2007
-
How To:
Group duplicates & extract unique records in MS Excel
-
How To:
Track cash on hand with a table Microsoft Excel 2010
-
How To:
Create a pass-fail grade formula in Microsoft Excel
-
How To:
Create a relative frequency distribution in MS Excel
-
How To:
Enter formulas in Excel with a macro
-
How To:
Create a cumulative frequency distribution in MS Excel
-
How To:
Build a 15-minute schedule in Microsoft Excel
-
How To:
Measure the spread of a data set with Excel's AVEDEV
-
How To:
Create a Tangent Line with Excel
-
How To:
Calculate proportions and percentages in Excel
1 Comment
Even for 156 and 157 also Formula bar will be Enabled
and for 154 and 155 it is Disabled
Share Your Thoughts