Feedback by UserVoice

S. Stockton

My feedback

  1. 276 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    S. Stockton commented  · 

    At least Win10 has fullscreen filter mode. It defaults to "somewhat yellow", but can be made quite orange. Night Mode.

    S. Stockton supported this idea  · 
  2. 6,813 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thank you for the continued interest in this space. While we don’t have specific plans to announce at this time, we have been researching the topic, conducting customer interviews, and are working with the Python team at Microsoft so we can build a plan that we think can address the scenarios you told us about and ensure it can run wherever Excel runs.

    Keyur [Microsoft Excel]

    An error occurred while saving the comment
    S. Stockton commented  · 

    @Roy - See also: OpenPyXL, xlwings.

    An error occurred while saving the comment
    S. Stockton commented  · 

    VBA, and even almost every VBA tutorial I've seen + almost every bit of VBA sample code I've seen, _and_ all VBA code produced by the macro recorder promote Very Bad Things. Unsafe things. Slow things, like .select() and .selection(). Things that "just barely work, given the right circumstances", and sometimes things that only seem to work. Esoteric things, that have bizarre and sometimes undocumented side-effects.

    VBA emits mostly-useless error messages. Like: "object-defined or user-defined error" when actually no error was defined, and the error arose outside of VBA code anyway.

    VBA encourages use of MsgBox(), which is Horrible, in part because whenever this is called, the entire Excel interface (in every open workbook in the same instance of Excel) becomes unresponsive. But can still bring other workbooks to the front, just not interact with them, and Excel gives no indication why. The message box produced by this call doesn't show up in Alt-Tab or on the taskbar, either. A partial solution is Application.Assistant.DoAlert(), because then at least the message box will appear in front of any workbook that you try to interact with.

    If you want to know how "easy" VBA is, read posts by Rubberduck on StackOverflow and on RubberduckVBA.

    I don't know Python well, but for the many people who have learned it for some other purpose, it's easier than dealing with the many quirks and hidden traps of VBA. Projects which bolt Python to Excel like a sidecar include: PyXLL, OpenPyXL, Python for Excel (PFE), xlWings.

    I, for one, welcome our new Python overlords, and would be in favour of building them a new house and IDE inside Excel.

    S. Stockton supported this idea  · 
  3. 187 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    45 comments  ·  Excel for Mac » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Good news! We are planning to improve the Name Manager in Excel for Mac. Thanks for your support of this request.

    We’ll be sure to provide an update as we make progress toward releasing this feature.

    Steve [Microsoft Excel]

    S. Stockton supported this idea  · 
  4. 1,156 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks to everyone for the votes and discussion about having undo independently in each workbook. Even though this request has been here for a long time, we are listening and we realize that it can be frustrating if you press Undo while you’re in one workbook and it undoes something in another workbook. We’ve been considering the technical challenges to make Undo work “per workbook”, and want to share some details about it with you.

    The undo process relies on the state of all open workbooks being exactly the same after an “undo” as they were before the undone action was taken. One example of how undo “per workbook” is problematic is with linked workbooks. Let’s say you have WorkbookA, with a formula that refers to WorkbookB, such as =SUMIFS. This formula will give the sum of values in WorkbookB in range A1:A10 that have “Yes” in the…

    An error occurred while saving the comment
    S. Stockton commented  · 

    @{this is a shame} Similarly, why on earth must Excel continually clear the clipboard? For instance, why does "Esc" key mean not only "remove the dashed boarder around what I copied" but also "clear clipboard? An application shouldn't touch the clipboard unless instructed it to put something else on it. Dainbramage! Say I goto another program and copy something; frequently Excel decides it knows better, and thinks that in fact I didn't really want anything on the clipboard. As an unreliable workaround, I've taken to using a "clipboard manager" tool keep the last several clipboard items; every once in a while, it can't paste quite the same content as if the clipboard hadn't been cleared, but at least there's /some/ way to smack Excel around and say "No, I really did need the contents of the clipboard.". Windows 10 has a built-in clipboard manager, but I can't rely on it always being available (usually due to Group Policy).

    The lack of separate Undo stacks for each Excel document also is …unfortunate… because running ALMOST any VBA will destroy the entire Undo history for the whole application.

    I'd like an optional Undo Actions palette, like PhotoShop — preferably with mini preview of the affected area — where I can click any point in the list to jump backward or forward in history without having to step through each intermediate stage.

    S. Stockton supported this idea  · 
  5. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    S. Stockton supported this idea  · 
  6. 1,198 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    S. Stockton supported this idea  · 
  7. 654 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thank you for taking your time to suggest and vote for allowing interaction with Excel while in Power Query Editor window. We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future. We’ll continue tracking votes for it.

    Guy Hunkin
    Excel Team

    S. Stockton supported this idea  · 
  8. 932 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    This is a great suggestion, and we want to keep the interest going. Thanks to everyone who has already voted and commented on the suggestion to have an option for the default paste behavior in Excel.

    Sorry that we’ve been slow to comment and update the status on this one.

    Steve K [Excel]

    S. Stockton supported this idea  · 
  9. 1,230 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thank you for taking the time to share your request for linking min/max values of a chart axis to the cell value! We think this suggestion has merit; however, we don’t expect to devote time to it in the near future. We will continue tracking votes and comments here, and will keep this suggestion under consideration for future development.

    Thank you again, and please keep sharing your thoughts!
    Auston [MSFT]

    S. Stockton supported this idea  · 
  10. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    S. Stockton supported this idea  · 
  11. 109 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    S. Stockton supported this idea  · 
  12. 446 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for all the votes and support of this suggestion.

    We like this idea, but we don’t have customized keyboard shortcuts in our plans for Excel on Windows in the short term. We’ll keep monitoring the votes here so it can still be considered in the future.

    Steve – Microsoft Excel

    An error occurred while saving the comment
    S. Stockton commented  · 

    From my perspective, it would be Really, Really Nice if, whenever Excel displays a window with a formula/cell-reference box, it displayed some visual indicator that (despite these looking like normal text boxes), most of the normal text-editing keystrokes DON'T WORK and will in fact ruin what's in the textbox by inserting various types of cell reference. A different issue, I know.

    But related, because, to defeat this dainbramage, you have to already know to press F2 to put a normal-looking text box into a mode that allows normal text-editing — and worse, no matter how many times you press F2, there's NO WAY to know which mode is current without either keeping track in your head of whether you've pressed F2 an even or odd number of times (and assuming you didn't accident'ly double-press at any point), or trying to do something basic like pressing an arrow key to see if the insertion point moves like it's supposed to (in any normal text box) or if the contents get increasingly clobbered by cell references with every press of the key.

    Ahem, sorry for the rant. I'm obviously bitter. Wonder if there's an UserVoice page about this… Looking now.

    (EDIT: Well, that was a brief search. The search box returns everything related to Excel, if I search for "Excel F2", and returns nothing if I search for "F2". I'll have to think of another way.)

    S. Stockton supported this idea  · 
  13. 46 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    S. Stockton commented  · 

    (ノ ゜Д ゜)ノ ︵ ┻━┻ ︵ ןǝɔxǝ ʇɟosoɹɔıɯ
    (╯°□°)╯︵ ┻━┻ ︵ ╯(°□° ╯)

    Ahem. I mean… keyboard-inaccessibility for the lose.
    Several Excel side-panels have the same issue.
    And relatedly, when the resizing the Excel window causes the Ribbon to shrink, the key-sequences needed to trigger various commands change, as well.

    Quattro Pro is still for sale; wonder how well it works these days?
    Or SoftMaker Office.
    Or even LibreOffice/OpenOffice. (^_^)

    S. Stockton supported this idea  · 
  14. 168 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    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]

    An error occurred while saving the comment
    S. Stockton commented  · 

    Kenneth Barber is a steely-eyed Human Interface Guidelines man.

    S. Stockton supported this idea  · 
  15. 3,667 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Good news! We’ve started working on this suggestion, and we’re currently testing the improved scrolling experience in our lab. It will allow you to stop partway through the row or column. The sheet will no longer need to snap to the top and left edge of the cells. Since scrolling is such a fundamental and highly used action in Excel, it may take a while to get it right. We hope to have it ready within a few months, but can’t provide an exact target date just yet. Thanks again for all your support and patience for this long awaited improvement.

    We’ll post an update here when we start rolling it out for you to try. It will be made available to Office Insiders first. Here’s how you can join – https://insider.office.com/en-us/join/windows.

    Thanks – Steve [Microsoft Excel]

    An error occurred while saving the comment
    S. Stockton commented  · 

    @Ed Hayes
    You imply that when not doing either of those things in Excel, row heights and column widths will never be large enough to make scrolling…unfortunate. For row heights at least, I'd counter that Excel should at least be able to scroll per line of text (and show an 'incompletion' indicator on the edge of the cell row that's not entirely in view).

    I agree that having COVID-19 data in Excel does not imply that row heights will be taller than normal, nor does it imply a massive productivity sink.

    An error occurred while saving the comment
    S. Stockton commented  · 

    Most other spreadsheets seem to copy Excel's scrolling behaviour: no matter how tall a row is or how wide a column is, just scroll-jump one whole row or column at a time.

    I agree this is nefarious when one ore more rows or columns are very tall or very wide.

    Excel can't even scroll the document while you drag the scrollbar's "thumb" (the bit which shows how far you are into the document, and on most systems also shows how much of the document fits in the current view). Excel only completes the scroll action when you let go.

    LibreOffice and SoftMaker PlanMaker gets the second bit right, make the document scroll while you drag the thumb. The still jump-scrolls large rows/columns, though.

    I guess this means if we REALLY want to be able to scroll partly through a cell, then we need to design mockup images of our own solutions, post them, and/or get down and dirty in the open-source code of a spreadsheet like LibreOffice or OpenOffice.

    S. Stockton supported this idea  · 
  16. 651 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    S. Stockton supported this idea  · 
  17. 624 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for all the support and comments about this request. We don’t have plans to add this format in the near future, but we’ll keep monitoring the votes as we prioritize this suggestion among other requests.

    There are a few ways that you can enable this already, as mentioned in some of the comments.

    1. Set the style used when you click the comma button.
    – This can be done by modifying the cell style called “Comma”, which is used when you click the comma button. See the screen shot in the comments for details, or look at this article to modify the style – https://support.microsoft.com/office/apply-create-or-remove-a-cell-style-472213bf-66bd-40c8-815c-594f0f90cd22.
    – For existing workbooks, you’d need to set the style in each workbook.
    – To make it the default in new workbooks, you can create a new workbook, make the change to the “Comma” style, and then save the workbook as a template…

    S. Stockton supported this idea  · 
  18. 840 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for your support for this suggestion. As some of the comments have concluded, there are a few complex technical issues and considerations that have delayed this from being implemented.

    We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future.

    One of the primary reasons for this request was to have a better way to handle formula cells in line charts, and this can be accomplished using the option to show #N/A as an empty cell. You can use the NA() function in your formulas as appropriate, and choose the option to “Show cells with #N/A as an empty cell”. To find the option for your chart, go to the Select Data dialog for the chart, and click the Hidden and Empty Cells button.

    We know there are other scenarios where a proper NULL()…

    S. Stockton supported this idea  · 
  19. 1,029 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for supporting this feature. We won’t be able to offer this in the near future, but we understand that it would be a nice improvement. Even though it seems like a straightforward idea, it is quite complex. Old versions of Excel will not support the new behavior, so there would need to be some hybrid approach that will be suitable for old and new versions. Also, named ranges can be dynamic, meaning that the range might change and conditional formatting rules would have to be adjusted when the workbook is calculated. There are lots of cases to consider and deal with properly.

    We’ll continue tracking votes for this suggestion.

    S. Stockton supported this idea  · 
  20. 2,515 votes

    We're glad you're here

    Please sign in to leave feedback

    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

    S. Stockton supported this idea  · 
← Previous 1 3

Feedback and Knowledge Base