Feedback by UserVoice

 

Jon Wittwer

← Welcome to Excel’s Suggestion Box!

My feedback

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

    20 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    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

  2. Temporary variables in formulas

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  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  · 

  3. Slider or Scroll Bar via Data Validation

    17 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    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  · 

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

    248 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    63 comments  ·  Excel for Windows (Desktop Application) » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    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  · 

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

    151 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

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

  6. Calculation mode should not be tied to the spreadsheet

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    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.

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

    1,414 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    376 comments  ·  Excel for the web » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    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  · 

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

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

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

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

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    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  · 

  10. Multiple total rows in tables

    48 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    12 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  · 

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

    10 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    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

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

    22 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    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 →
    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

  13. Need a date-picker

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    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

  14. Mini calendar and date picker

    9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    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

  15. Searchable drop down option

    69 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    14 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  · 

  16. Add 'date picker' to enable users to select a date from a mini calendar into cells

    1,596 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1126 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    started  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Hi all,

    We have been working on this, and wanted to get your feedback on how you see this feature fitting into your workflow. We have a quick one question survey for you to give us your thoughts on the look and keyboard shortcuts we have at this time. Please see here for more: aka.ms/datePickerSurvey

    Thanks!
    Blake, Excel Product Team

    An error occurred while saving the comment
    Jon Wittwer commented  · 

    Over 40,000 users have found and installed the various date-picker add-ins for Excel, so if you were to count all of those users as having voted for this feature, that should more than justify adding this type of control (especially since most users are not aware of the add-ins).

    Almost all of the most commonly used spreadsheet templates include entering or using dates in some way. Scheduling is one of the most common uses for spreadsheets, and that process almost always requires referencing a calendar in some way.

    I don't know how many times I have had to modify the date format of a cell just to see what day of the week it is. When you double-click on a cell formatted as a date, the mini calendar / date picker should show up ... and just like that, you can see exactly what day of the week it is.

    Not to belabor the point, but as a reminder, the date picker control has been a working feature in Google Sheets for quite a while.

    An error occurred while saving the comment
    Jon Wittwer commented  · 

    FYI ... you can click on the Vote button if you like this suggestion. No need to add a comment that just says "yes"

    Jon Wittwer supported this idea  · 
    An error occurred while saving the comment
    Jon Wittwer commented  · 

    A Date Picker in Excel is one of those features I think many of us have wanted for many years. I'd like to see something like in Google Sheets, where if a cell contains a date value and is formatted as a date (and does NOT contain a formula) and you double-click on the cell, a mini date-picker will pop up underneath or above.

    I'm voting for this even though I created a mini date picker add-in in the Office Store. It would be MUCH better to have this be a built-in Excel feature.

  17. Have a BEFORE() function that refers to the cell above, below, left or right of current cell

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    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  · 

    This is a good suggestion. A running balance that doesn't break when you delete rows is a very common use case. The method I use when I want to avoid using the volatile OFFSET function is to create a "relative named range" such as cell_above or cell_left or prev_balance.

    1. Select cell C5
    2. Go to Formulas > Define Name
    3. In the Name field, enter "cell_above"
    4. Set the Scope to the current Worksheet
    5. Set the Refers field to =C4 (no dollar signs)
    6. Use cell_above in a formula such as =cell_above+1

  18. Add Center Across Selection to the Merge & Center Drop-down

    702 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    93 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    Jon Wittwer supported this idea  · 

  19. Pull Current Stock Prices and Historical Data Into Excel

    1,091 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    384 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    started  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Hi everyone,
    Stock data types are now available to all Windows Office 365 subscribers with an English editing language installed (our data is only available in English at this time). You can find some instructions on how to use the feature here: https://support.office.com/en-us/article/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54. The feature will also be appearing in Excel for Mac and Excel Online in early 2019 – as usual, Office Insiders will see the feature before the general population. See http://aka.ms/officeinsider for more info.

    One pro tip to locate instruments on a different exchange is to include an ISO country code alongside the symbol, for instance MX MSFT will tell Excel to grab Microsoft from the Mexican stock exchange instead of Nasdaq. We’ll be publishing more thorough documentation in the near future.

    We also acknowledge that this is only half of the requested feature in this suggestion – the current stock prices piece. The ability to…

    Jon Wittwer supported this idea  · 

  20. Sheet-side Split function

    69 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

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

    I would love to see the SPLIT function added to Excel ... and it should be exactly compatible with the Google Sheets version.

    To following formula returns the middle name:
    =INDEX(SPLIT("J. Allen Smith"," "),2)

    Jon Wittwer supported this idea  · 
← Previous 1 3

Feedback and Knowledge Base

(thinking…)