Restore missing button and drop down controls in Excel

By | April 7, 2016 | 0 Comment
Category: MS Excel Tags:

Have you ever faced a situation where suddenly all the buttons, drop downs and various controls are missing from your Excel spreadsheet? Well, it’s not gone but it is hidden. Here is the setting to make the controls visible.

Go to File > Options > Advanced > Display options for this workbook > For objects, show: > Select All

excel-options-show-button-dropdown

About Vishal Monpara

Vishal Monpara is a full stack Solution Developer/Architect with 13 years of experience primarily using Microsoft stack. He is currently working in Retail industry and moving 1's and 0's from geographically dispersed hard disks to geographically dispersed user leveraging geographically dispersed team members.

Leave a Reply

Your email address will not be published. Required fields are marked *