5 Reasons/Causes for Excel Insert button greyed out on the Developer tab

Excel Insert Button Greyed Out? 5 Solutions (with Images) What is it: Insert button under Developer tab helps you insert Form Controls and ActiveX Controls like Combo Box, List Box, Spin Button etc on your User Form or Excel worksheet. But there are few situations when this Excel Insert Button greyed out…

Continue reading

How to Disable Track Changes in Excel to Enable Insert under Developer Tab

Disable Track Changes to Enable Insert button (with Images) Step by step instructions to Disable Track Changes What is it: Insert button under Developer tab is greyed out and not allowing you to click? Why is it disabled: One of the reasons for this option is grayed out or disabled because you might have enabled…

Continue reading

How to Enable Display options for this workbook:Insert Button Greyed Out

Enable Display Options in Excel to All (with Images) What is it: Insert option under Developer tab is greyed out and not allowing you click? Why is it disabled: One of the reasons for this option is grayed out or disabled is because “Display options for this workbook For objects, show:” must be set as…

Continue reading

Enable Insert Button under Excel Developer tab

Enable Insert Button under Excel Developer tab (with Images) What is it: Insert button under Excel Developer tab is greyed out and not allowing you click? Why is it disabled: One of the reasons for Insert button under Excel Developer tab is grayed out or disabled is because there must be multiple sheets selected in your…

Continue reading

Insert button grayed out in the developer tab

Insert button grayed out in the developer tab What is it: Insert option under Developer tab is grayed out and not allowing you click? Why is it disabled: One of the reasons for this option is grayed out or disabled is because your excel sheet must be Shared. How to…

Continue reading

Shortcut to Enter Current System Time in Excel

Enter Current System Time in Excel – Keyboard Short Key What is it: This Keyboard short cut is to enter Current System Time in Excel Cell. Why: The Excel formula or function available for the same is =NOW() But the above formula or function will include the current Date also…

Continue reading

Shortcut to insert worksheet with sheet name in Excel

Shortcut to Insert Worksheet with Sheet Name (with Images) What is it: It’s a shortcut to insert worksheet with the sheet name in Microsoft Excel. Why is it important: When you want to insert an additional worksheet in excel with a particular name for that sheet, With this shortcut you…

Continue reading

How to enable Developer tab in excel 2007

Enable Developer tab in excel 2007 (with Images) What is a Developer Tab:  This tab need to be accessed when we are developing or running macros using Visual Basic to use with Microsoft Office programs. Why is it important: This tab contains lots tools which are essentials when we are creating  applications to use with…

Continue reading