Feedback by UserVoice

Jon Wittwer

My feedback

  1. 20 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jon Wittwer supported this idea  · 
    An error occurred while saving the comment
    Jon Wittwer commented  · 
  2. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    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  · 
    Jon Wittwer supported this idea  · 
  3. 17 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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. 248 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Jon Wittwer supported this idea  · 
  5. 151 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jon Wittwer supported this idea  · 
  6. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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. 1,414 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    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. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jon Wittwer shared this idea  · 
  9. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jon Wittwer shared this idea  · 
  10. 48 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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. 10 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    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
  12. 22 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
  13. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
  14. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Jon Wittwer commented  · 
  15. 69 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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. 1,596 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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. 702 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jon Wittwer supported this idea  · 
  19. 1,091 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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. 69 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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