{"id":3388,"date":"2019-12-19T13:09:41","date_gmt":"2019-12-19T19:09:41","guid":{"rendered":"https:\/\/www.vertex42.com\/blog\/?p=3388"},"modified":"2023-12-11T21:46:34","modified_gmt":"2023-12-12T03:46:34","slug":"excel-feature-suggestions","status":"publish","type":"post","link":"https:\/\/www.vertex42.com\/blog\/news\/excel-feature-suggestions.html","title":{"rendered":"Excel Suggestions You Can Vote On!"},"content":{"rendered":"
\n\"Excel<\/div>\n

Update Jan 2022: Microsoft appears to have discontinued the user of excel.uservoice.com, but there is a new system built into Excel for providing feedback. See \"How do I give feedback on Microsoft Office<\/a>.\" The new feedback site for voting on suggestions is located at feedbackportal.microsoft.com<\/em><\/p>\n

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

1. Insert > Checkbox (like in Google Sheets)<\/h2>\n

✔ Vote<\/a><\/p>\n

\"In-Cell<\/p>\n

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<\/a> in Google Sheets instead of Microsoft.<\/p>\n

Update 10\/19\/2023<\/em> : Checkboxes are Coming to Excel!!!! Currently available to Office Insiders!<\/p>\n

2. A Built-in Date Picker (like in Google Sheets)<\/h2>\n

✔ Vote<\/a><\/p>\n

\"Date<\/p>\n

I made this one a personal mission. For a long time back when excel.uservoice.com was the method for suggesting features, I was promoting this suggestion on every download page on my site. Now on the new feedback site, it is once again one of the top voted suggestions.<\/p>\n

Update 12\/9\/2023<\/em> : I've heard a rumor that this may finally be coming!<\/p>\n

3. Link the Min and Max Values of a Chart to Cells<\/h2>\n

✔ Vote<\/a><\/p>\n

\"Link<\/p>\n

How to adjust the axis range of a chart is by far<\/strong> 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.<\/p>\n

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?<\/p>\n

4. Text Orientation Option for Excel Online<\/h2>\n

✔ Vote<\/a><\/p>\n

\"Vertically<\/p>\n

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<\/a> template.<\/p>\n

5. Searchable Drop-Down Boxes<\/h2>\n

✔ Vote<\/a><\/p>\n

\"Searchable<\/p>\n

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). <\/p>\n

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<\/a>.<\/p>\n

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.<\/p>\n

6. Scroll Bar and Spin Button via Data Validation<\/h2>\n

Vote<\/a><\/p>\n

I would like to see a slider or scroll bar become an in-cell data validation option, like in the example below.<\/p>\n

\"Scroll<\/p>\n

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

<\/p>\n

7. Improved Conditional Formatting Manager<\/h2>\n

✔ Vote<\/a><\/p>\n

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.<\/p>\n

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 improved conditional formatting behavior.<\/p>\n

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.<\/p>\n

8. Stop Print_Area formula being converted to range when editing Page Setup options<\/h2>\n

Vote<\/a><\/p>\n

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.<\/p>\n

I want to be able to edit the Page Setup options without having the Print_Area formula changed.<\/p>\n

Imperfect Work-Around<\/em>: 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).<\/p>\n

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.<\/p>\n

Have Your Own Suggestions?<\/h2>\n

If you have suggestions for Microsoft, go to excel.uservoice.com<\/strong><\/a> 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.<\/p>\n

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!<\/p>\n

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

<\/p>\n","protected":false},"excerpt":{"rendered":"

Learn how to make and vote on feature suggestions for Excel, using the official Microsoft website. In this article, I have listed some of the features that I would like most, so please vote on them!<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[4],"tags":[],"class_list":{"0":"post-3388","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-news"},"_links":{"self":[{"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/posts\/3388","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/comments?post=3388"}],"version-history":[{"count":0,"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/posts\/3388\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/media?parent=3388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/categories?post=3388"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/tags?post=3388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}