Jon Wittwer
My feedback
-
2 votes1 comment · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment -
4 votes3 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment -
13 votes4 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment -
1 vote0 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →
Jon Wittwer shared this idea ·
-
22 votes7 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
-
3 votes
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 ·
-
19 votes2 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 incrementSPIN 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 ·
-
276 votes71 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Jon Wittwer commented
Jon Wittwer supported this idea ·
-
237 votes34 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
Thanks for the idea! We think formatting cells as a checkbox is an interesting suggestion, but we won’t be able to address it in the near future. We’ll continue tracking votes for it.
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 ·
-
165 votes37 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →
Jon Wittwer supported this idea ·
-
4 votes5 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.
-
2,755 votes
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 ·
-
4 votes1 comment · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
Jon Wittwer shared this idea ·
-
2 votes0 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
Jon Wittwer shared this idea ·
-
52 votes12 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 ·
-
10 votes
An error occurred while saving the comment Jon Wittwer commented
-
23 votes6 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Jon Wittwer commented
-
6 votes3 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:
-
10 votes1 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:
-
82 votes16 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 SuppliesIn Google Sheets, if you type "P" then your drop-down list automatically shortens to:
Mortgage Payment
Personal SuppliesGoogle 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 ·
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