Need to create a project schedule? Try our Gantt Chart Template!

Excel Suggestions You Can Vote On!

Excel Suggestions You Can Vote On

Microsoft has a place you can go to make feature suggestions and vote on other people's suggestions: excel.uservoice.com It takes quite a few votes to get a suggestion to be seen and considered, but it IS possible to make a difference!

Here are the top features I'd like to see. If you also like these suggestions, then please add your vote to each one!

1. Insert > Checkbox (like in Google Sheets)

✔ Vote

In-Cell Checkboxes in Google Sheets

What can I say about this? Google beat Microsoft to the punch on this one, and this feature alone is one of the reasons I use Action Item Lists in Google Sheets instead of Microsoft.

2. A Built-in Date Picker (like in Google Sheets)

✔ Vote

Date Picker in Google Sheets

I made this one a personal mission. For a long time, I was promoting this suggestion on every download page on my site. It has over 1200 votes now and Microsoft has started working on it, but the actual time to release is unknown.

3. Link the Min and Max Values of a Chart to Cells

✔ Vote

Link the Axis Min and Max to Cells

How to adjust the axis range of a chart is by far the most common question I get related to charts within my templates. And OH HOW EASY THIS WOULD BE if I could just link the min and max to cells that a user could easily modify.

This suggestion has over 1000 votes, yet Microsoft STILL hasn't said they have scheduled it for implementation! Eventually, if enough people vote on it, they'll HAVE to do it, right?

4. Text Orientation Option for Excel Online

✔ Vote

Vertically Oriented Text in Google Sheets

I design templates for compatibility. The lack of text orientation as an option in Excel Online is limiting my creative juices. Google Sheets can do it, though. The image above is the Attendance Record template.

5. Searchable Drop-Down Boxes

✔ Vote

Searchable Dropdown Boxes in Google Sheets

In case you are wondering, this has to do finding the item you want in a long list of choices in drop-down boxes (such as 20+ budget categories).

There are work arounds in Excel, but there shouldn't need to be. Google Sheets does this VERY well. The example above comes from the Google Sheets version of the Money Management Template.

I hate to constantly be saying "Google Does This Already," but the fact is that a lot of what Google is doing is extremely useful. One of the reasons why I notice issues with Excel is because I've been using Google Sheets more and more and I like a lot of what they have that Excel doesn't have.

7. Avoid Fractured Conditional Formatting Rules - Make "Paste and Merge Conditional Formatting" the Default Behavior

✔ Vote

If you have been using a gantt chart or other file that relies heavily on conditional formatting, go to Conditional Formatting > Manage Rules and choose "This Worksheet" from the dropdown. Check how many separate rules your worksheet has. If there are hundreds or even thousands, then you'll understand the need for this suggestion.

This is another thing Google Sheets does a little better. They don't have as many problems with fractured CF rules, and it's probably because they merge rules by default.

8. Scroll Bar and Spin Button via Data Validation

Vote

I would like to see a slider or scroll bar become an in-cell data validation option, like in the example below.

Scroll Bar and Spin Button in Excel

This feature could be integrated into the "Whole number" validation criteria with a simple checkbox like "Show scroll bar" or "Show spin button".

9. Improved Conditional Formatting Manager

✔ Vote

This suggestion is a little too vague, but in general, there are many things I'd like to see improved. For example, the addition of a "Duplicate Rule" button.

10. Stop Print_Area formula being converted to range when editing Page Setup options

Vote

Using dynamic range formulas for Print_Area is extremely handy in many situations. However, when you edit any Page Setup options, the formula used for the Print_Area is converted to a normal range and the formula is lost.

I want to be able to edit the Page Setup options without having the Print_Area formula changed.

Imperfect Work-Around: To avoid losing a complicated dynamic range formula, I define a new named range called print_range (with worksheet scope) and I set the Print_Area name to =print_range (which is automatically changed to =WorksheetName!print_range).

I still need to remember to update Print_Area whenever I make a change to the page layout settings, but at least the dynamic range formula is not lost this way.

Have Your Own Suggestions?

If you have suggestions for Microsoft, go to excel.uservoice.com and first search to see if somebody else has already made a similar suggestion. Then you can add a comment and vote on that suggestion.

If you can't find an existing suggestion, go ahead and add your own. Then, come back here and paste a link to your suggestion in the comments. The more people see and vote on your suggestion, the better!

As a final word, I'd like to thank Bill Jelen (MrExcel.com) for his insights into how to get suggestions to be heard by Microsoft.

Comments

2 comments… add one
  • I would like a fast way to hide zeros throught the ribbon instead of clicking several time to the Options and then unchecking this functionality.

    Reply
  • Wow . I love these tips. There are a few number of ideas shared here that I didn’t know was possible with Excel. Truly, Excel can do all things, EXCELlently!

    Reply

Leave a Comment

Your Name will be displayed along with your comment. Your Email and IP address are stored with the comment and used to identify/prevent spam (via a service provided by Automattic.com), but are not shared publicly. See our privacy policy to learn more.