Excel TV ExcelTV

Enable Grayed-Out Form Controls in Excel

Updated
Enable Grayed-Out Form Controls in Excel

Hey Guys! How are you doing? Welcome to Excel TV. Are you waiting for this week’s Excel Challenge? Yo! Excel Author Jordan Goldmeier is also ready with some good and interesting challenge. But, stay there! Before going forward, let us have a look at the previous episode’s challenge.

Last Week’s Challenge

Last week Jordan shared a snapshot of his quick access toolbar which has icons and you were asked to name each of them. Remember that? I think, it’s yes from you. So, did you get them right? Let us look at correct answer for that.

Correct Answer From Last Week’s Challenge

As it is not possible to explain each icon here (I mean in text: D), Jordan explained named each of the icon in the video. Please check out the video below, to know name of each icon.

The winner of last week’s challenge is Bryan from Cincinnati, Ohio. Congratulations!

You received 12 months paid membership Mynda Treacy Dashboard Course. Keep going buddy!

How To Enable Grayed Out Form Controls in Excel

What do you do when you want to insert form controls? You will just follow the path as Developer tab > Controls group > Insert and you now you could see Form Controls dropdown. Here, you could see three controls are grayed out. Jordan highlighted them in the video below.

Now, the question is how can we enable them?

Hurry Up To Answer

This is really an interesting challenge. Go ahead and comment your answer in Excel TV blog post or Facebook. You can even leave your answer in the comments section below. Come On!

Written by

Sridhar Belide
Sridhar BelideB.Tech. Computer Science, JNTUH10+ years in software engineering

Software Engineer, Wells Fargo

  • React
  • UI Frameworks
  • Front-end Development
Sridhar Belide is a skilled software engineer with over a decade of experience in the industry. Currently working at Wells Fargo since December 2018, he focuses on developing UI frameworks for front-end applications using React. Before joining Wells Fargo, Sridhar spent five years and four months at Tata Consultancy Services, where he held the position of IT Analyst. He also has experience as a Community Manager for Impact SoftTech Pvt. Ltd. EALP and as a Software Research and Development Engineer at NSN - Nokia Solutions and Networks. Sridhar holds a Bachelor of Technology (B.Tech.) in Computer Science from JNTUH, demonstrating his strong foundation in the field.

Read more articles by Sridhar Belide

Editorial standards

Fact Checking & Editorial Guidelines

Every article on Excel TV is held to a published editorial standard. The goal: accurate, current, and useful — without filler.

  1. Expert review. Drafts on technical Excel topics are reviewed by a contributor with hands-on, working knowledge of the feature being covered.
  2. Source validation. Claims about Excel behavior are tested in current Microsoft 365 builds. Third-party product claims are sourced from the vendor's own documentation.
  3. Disclosure. Affiliate links, sponsorships, and any commercial relationships that influenced a piece are disclosed in-line and at the foot of the article.
  4. Updates. Articles are revisited when Microsoft ships changes that affect the content. The most recent revision date is shown on every post.

Spot a problem? Email editor@excel.tv and we will look at it.

Subject-matter review

Reviewed by Subject Matter Experts

Technical Excel articles are reviewed by contributors with verifiable, hands-on experience in the topic — not generalist editors.

  • Qualified reviewers. Reviewers include Microsoft Excel MVPs, working business-intelligence practitioners, and Excel TV editorial staff. See each author's page for credentials.
  • Current to a known Excel build. Procedural articles state which Excel version they were validated against. Where Microsoft has since changed behavior, the article carries an inline update note.
  • Clarity check. Reviewers verify steps are reproducible by a reader at the assumed skill level — not just technically correct in a vacuum.

Want to contribute or review for Excel TV? See the about page.