Feedback by UserVoice

 

Jon Wittwer

← Welcome to Excel’s Suggestion Box!

My feedback

  1. Date PIcker in Excel for Windows

    3 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jon Wittwer commented  · 

    See this suggestion:
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/13275054-add-date-picker-to-enable-users-to-select-a-date

  2. Simple Date & Time Picker

    5 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    3 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jon Wittwer commented  · 

    See this suggestion:
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/13275054-add-date-picker-to-enable-users-to-select-a-date

  3. date picker

    15 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    4 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jon Wittwer commented  · 

    See this suggestion:
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/13275054-add-date-picker-to-enable-users-to-select-a-date

  4. Unable to Save File - Possible Culprit: Custom Number Formatting

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Jon Wittwer shared this idea  · 

  5. Support inline variables in formulas (similar to PowerPivot)

    22 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    7 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Jon Wittwer supported this idea  · 
    An error occurred while saving the comment
    Jon Wittwer commented  · 

    Hurray for the new LET function !!!

    https://support.office.com/en-us/article/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999

  6. Temporary variables in formulas

    3 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    2 comments  ·  Excel for Mac » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jon Wittwer commented  · 

    Hurray for the new LET function !!!!

    https://support.office.com/en-us/article/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999

    Jon Wittwer supported this idea  · 

  7. Slider or Scroll Bar via Data Validation

    19 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    2 comments  ·  Excel for Mobile Devices, Tablets, Phones (Android, iOS, Windows Mobile) » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jon Wittwer commented  · 

    SCROLL BAR:
    When you click on a cell that uses a scroll bar data validation option, the scroll bar could appear to the right or left of the cell, allowing you to easily change the number in the cell. Keyboard Behavior: Alt+Right or Alt+Left will increment

    SPIN BUTTON:
    When you click on a cell that has a number, the spin button would show up to the right of the cell, letting you click Up or Down to increment or decrement the value by 1 (or allow the increment to be specified in the settings). Keyboard Behavior: Pressing Alt+Up or Alt+Down will increment.

    An error occurred while saving the comment
    Jon Wittwer commented  · 

    The length of the slider should not be limited to the width of the cell. The slider would need to have a minimum length to be functional. It could extend beyond the width of the cell, like the list box kind of does.

    Jon Wittwer shared this idea  · 

  8. Improve Data Validation (make it AutoComplete based on typed characters)

    311 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    83 comments  ·  Excel for Windows (Desktop Application) » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Hi all – thanks for your support for this suggestion.

    Improving data validation drop down lists by adding autocomplete is a great idea, as well as supporting structured table references in the data validation Source range.

    Steve – Microsoft Excel

    An error occurred while saving the comment
    Jon Wittwer commented  · 

    Related Suggestion: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/32741524-searchable-drop-down-option

    Jon Wittwer supported this idea  · 

  9. Format cell as a checkbox (TRUE, FALSE)

    257 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    38 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jon Wittwer commented  · 

    I'm finding that this feature alone is why I now use Google Sheets for ALL of my to do lists, instead of Excel. Yes, even though I can press ALT+Down to open a drop-down and select a check mark (my make-shift method for checkboxes in Excel), there is just something awesome and fun about clicking on a checkbox that makes the Google Sheets implementation better than work arounds with Excel.

    Microsoft, don't forget to pay attention to the little things! You don't have a monopoly on spreadsheets any more, so let competition drive you to become even better.

    An error occurred while saving the comment
    Jon Wittwer commented  · 

    One more comment about the Google Sheets implementation ... I really like that you can change the color of the checkbox by simply changing the font color of the cell.

    An error occurred while saving the comment
    Jon Wittwer commented  · 

    Google Sheets has beat Microsoft to this one! See below:

    https://support.google.com/docs/answer/7684717

    Google Sheets has made adding a checkbox to a cell as easy as going to Insert > Checkbox. The checkbox is actually a data validation option (so Insert > Checkbox is a shortcut). I really like that you can customize what values are used for the checkbox. The default is TRUE/FALSE, but via data validation you can change that to 1/0 or whatever.

    An error occurred while saving the comment
    Jon Wittwer commented  · 

    I've been using a drop-down list with the Unicode checkmark symbols lately (✓, ✔) because Unicode characters appear within the drop-down list (as opposed to the wingdings approach). This works great for touch/mobile, but it still requires multiple touches/clicks to select the check from the drop-down. The down side is that the value isn't stored as TRUE/FALSE. You have to use an IF statement or something.

    I would like to see a checkbox data validation option done the way it is in the Numbers app, where the value is displayed as a check (or better yet, give the user a way to change what symbol is displayed for TRUE and FALSE), and the value is stored as TRUE or FALSE.

    Jon Wittwer supported this idea  · 

  10. Make all windows (Dialog Boxes) containing variable-sized content resizable

    170 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    45 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    not at this time  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    This is a great suggestion, but we’re marking it “Not at this time”, because there are many dialogs in Excel and we don’t have a plan to address all of them at one time. If there are specific dialogs you want improved, please vote for specific suggestions about those, or leave comments here. We’ll keep tracking the votes on this one.

    There is some good news. We’re working on making the Conditional Formatting dialogs resizable in Excel for Windows.

    Here’s more about that –
    https://excel.uservoice.com/forums/304921/suggestions/16092793

    Steve [Microsoft Excel]

    Jon Wittwer supported this idea  · 

  11. Calculation mode should not be tied to the spreadsheet

    4 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    5 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Jon Wittwer supported this idea  · 
    An error occurred while saving the comment
    Jon Wittwer commented  · 

    I prefer the Automatic/Manual calculation option to be specific to the workbook, regardless of what other workbooks have been opened. People using my spreadsheets often email me to say their spreadsheet has stopped working, and the majority of the time it is because Excel has switched the calculation option to Manual.

  12. There is no text orientation option in excel online. Please add this option if possible

    3,406 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    797 comments  ·  Excel for the web » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  excelonlineteam responded

    Thanks for your feedback! We’re reviewing your suggestion. Please keep voting to influence our Backlog priority.

    - Excel on web team

    An error occurred while saving the comment
    Jon Wittwer commented  · 

    Google Sheets did it already. This feature shouldn't even require votes! It should be like this ... "Google Sheets can do it? Uh oh, we better get on it, and fast". I would recommend taking a look at the backlog and then look to see whether Google Sheets has already implemented something (like a date picker) and bump those features to the very top of the list. Google Sheets didn't do a very good job with their recent "Themes" feature ... so they aren't infallible, but they are improving very rapidly. It wouldn't surprise me if Google Sheets is looking at all of these Excel suggestions and just going ahead and implementing the ones that sound good.

    An error occurred while saving the comment
    Jon Wittwer commented  · 

    This is a good suggestion. I frequently need to modify the way I design templates specifically because Excel online cannot show text oriented at 90 degrees. This is especially needed when you have a table with numerous narrow columns (such as a roles and responsibilities matrix and attendance roles and schedules with full dates in each column).

    Jon Wittwer supported this idea  · 

  13. Add "Auto" as a Font Size Option (and make 'Shrink to fit' better)

    4 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    Jon Wittwer shared this idea  · 

  14. More Options in Context Menu for Insert (e.g. Copy Formulas)

    2 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    Jon Wittwer shared this idea  · 

  15. Multiple total rows in tables

    55 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    13 comments  ·  Excel for Windows (Desktop Application) » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jon Wittwer commented  · 

    The need for multiple total rows is one of the reasons that I often avoid using Excel Tables, so I definitely like the suggestion of allowing multiple total rows in tables. Right-clicking on the total row and selecting "Table > Insert Total Row" would be a nice way to do it.

    Jon Wittwer supported this idea  · 

  16. include a date picker function for excel, similar to the the date picker on the developer tab in word

    11 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    4 comments  ·  Excel for Mac » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jon Wittwer commented  · 

    See the following suggestion:

    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/13275054-add-date-picker-to-enable-users-to-select-a-date

  17. missing date and time picker from excel 2013 and later....provide a patch to correct this issue!!!

    23 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    6 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jon Wittwer commented  · 

    See the following suggestion:

    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/13275054-add-date-picker-to-enable-users-to-select-a-date

  18. Need a date-picker

    7 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    3 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jon Wittwer commented  · 

    See the following related suggestion:

    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/13275054-add-date-picker-to-enable-users-to-select-a-date

  19. Mini calendar and date picker

    11 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jon Wittwer commented  · 

    Good idea ... see the following related suggestion:

    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/13275054-add-date-picker-to-enable-users-to-select-a-date

  20. Searchable drop down option

    86 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    16 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jon Wittwer commented  · 

    A searchable or automatically filtered drop-down list would be a great feature for Excel to add!

    One example would be a budget spreadsheet with a lot of budget categories. Autocomplete is nice, but it isn't sufficient.

    Let's say you had the following list:
    Mortgage Payment
    Groceries
    Auto Insurance
    Personal Supplies

    In Google Sheets, if you type "P" then your drop-down list automatically shortens to:
    Mortgage Payment
    Personal Supplies

    Google Sheets has not yet perfected this feature, in my opinion. Currently, Sheets only searches based on the beginning of the words, rather than a letter in the middle of a word. For example, if you type "y" you get no results even though "Mortgage Payment" contains a "y"

    Although there are fancy tricks you can use to create a searchable list using dynamic ranges and the SEARCH function, these tricks require too much Excel expertise and are not a great solution for something simple like an account register.

    Jon Wittwer supported this idea  · 
← Previous 1 3

Feedback and Knowledge Base

(thinking…)