Excel TV ExcelTV
Excel VBA & Macros

Excel Named Range Zoom Size: VBAExpress Challenge

Updated
Excel Named Range Zoom Size: VBAExpress Challenge

Hello Excel TV Lovers! Excel MVP Jordan is here with us with new Excel TV Challenge. This is one more from VBA Express Weekly Challenge. Before letting you know the present week’s challenge, let us first look at the previous week’s challenge.

Last Week’s Challenge

Last week Excel author Jordon Goldmeier asked “Who is the long running Excel MVP”. Have you answered it? We will let you know the correct answer and also the winner. Here it is!

Correct Answer From Last Week’s Challenge

So, the correct answer for the last week’s challenge is “Bob Ulmas”. Winner is “Ryan Wilson”. Congratulations Ryan Wilson! You won free ticket for webinar from VBAExpress.com. Jordon will get in touch with you and will let you know how you can claim your win!

What is the maximum zoom size for regions in Excel?

If you zoom out far enough in Excel, the name of a given named range will appear on top of it’s defined region. Have you observed it? So, this week’s Excel challenge is “What is the maximum zoom percent that will show a name on top of it’s region?”

Hurry Up To Answer

This is really an awesome chance to grab two rewards apart from learning new. Go ahead and comment your answer in Excel TV blog post or Facebook or comment on the video. You can even tweet to @ExcelTV or mail at Challenge@ExcelTVShow.com. 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.