Linda Wu MSFT. Replied on July 8, 2017. Report abuse. In reply to A. User's post on July 7, 2017. Hi Darren, It is not feasible to embed child drop down list to a parent drop down list in Excel. Or you can go to some development forum and look for some developing method. Thanks for your understanding. In Excel 2019 this group was moved to the Home Tab and renamed to Ideas. Charts. You can quickly display the Insert Chart dialog box by selecting your data and clicking on the dialog box launcher in the bottom right corner of the group. If a chart is active the Change Chart Type dialog is displayed. Application.CommandBars("Cell").Controls("Search the Menus").Delete End Sub '---The control name in the above must have the "&" sign entered (no quote marks) As I dont have the control on my excel version, it is up to you to place it properly. Matching the case of the characters on the menu should also be done. '---Nothing Left to Lose CTRL + Y. Redo something you just undid. Shift + spacebar. Select the row. ALT + I + R. Excel insert row shortcut (Add a new row above the one you selected.) CTRL + –. Excel delete row shortcut Excel keyboard shortcuts and function keys. This article describes keyboard shortcuts, function keys, and some other common shortcut keys for Microsoft Excel 2016 for Windows. This includes the shortcuts that you can use to access the ribbon. Tip To keep this reference available when you work, you may want to print this topic. Excel Options Menu is missing. The Options menu under the files tab is missing in my Excel software and I am not sure how to fix it. Attached here is a screenshot for the same. Any help is welcome. I have tried (1) repairing Office, (2) Uninstalled and reinstalled it. But that has been of no use, unfortunately. This thread is locked. .

menu menu microsoft excel