![]() Check In-Cell Dropdown option to show the drop-down list. In the Source box, specify the range that contains the drop-down list items (in this example, the range is E1:E8). In the Allow drop-down list, select the List item. This way, if someone right clicks on any tab and chooses “unhide” it will not appear in that dialog box. To do so, open the VBA application using the the keyboard shortcut Alt + F11, select the sheet that the photos are on, then in the properties below, next to “visible”, click the drop down arrow and choose “sheetveryhidden”. ![]() ![]() ![]() Shortcuts of File, Ribbon, Drag and Drop, Active Cell, General, General Continued, Selection, Navigation, Extend. Excel keyboard shortcuts – Microsoft Excel keyboard shortcuts for PC and Mac. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |