Feedback by UserVoice

Jon Wittwer

My feedback

  1. 22 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. 18 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. 265 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. 205 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'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  · 
  6. 156 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  · 
  7. 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.

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

    We’ll send you updates on this idea

    463 comments  ·  Excel for the web » Formatting  ·  Flag idea as inappropriate…  ·  Admin →

    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  · 
  9. 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  · 
  10. 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  · 
  11. 51 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  · 
  12. 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
  13. 23 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. 6 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
  15. 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  · 
  16. 74 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  · 
  17. 1,706 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.

  18. 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

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

    We’ll send you updates on this idea

    Huge progress update toward historical data! We have released our preview of the StockHistory function! https://support.microsoft.com/en-us/office/stockhistory-function-1ac8b5b3-5f62-4d94-8ab8-7504ec7239a8

    However, this is only available to our Beta Channel at the moment, so when it is rolled out to General Availability, I will be sure to update the status to completed.

    If you are able to use the feature in preview and have feedback, please send-a-frown for us to review.

    —Kaycee Reineke
    Excel PM

    Jon Wittwer supported this idea  · 
← Previous 1 3

Feedback and Knowledge Base