Feedback by UserVoice

S. Stockton

My feedback

  1. 221 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,751 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

    Wow.

    Thank you to all those participated in our survey. What an amazing number of responses, many of them with very deep content. We’re processing the over ten thousand responses(!), and already appreciate the time so many of you took to answer with passion and experience.

    Please know this survey is used to help influence various topics – both on Python as well as other related topics that the comments started to bleed into. Given the passion, I want to be clear this remains an area of exploration for us, without any specific timeline.

    We’ll provide updates as we progress on this feature request.

    Thanks!

    Ashvini Sharma
    Lead Program Manager
    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. 179 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

    42 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,130 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,141 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. 627 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. 876 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,213 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. 108 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. 435 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. 165 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,570 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

    I’m happy to let you know that we are in the planning stages to make Excel for Windows scroll without jumping to the edge of the cell so you’ll be able to scroll smoothly. We don’t yet have a target date, but wanted to tell you about our plans.

    We appreciate all the votes and comments supporting this suggestion.

    Thanks – Steve K [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. 638 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. 616 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. 772 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

    We are excited to share an update on the feature availability. This is available on Excel Insiders min build: 16.0.13525.10000, and on Mac Insiders min build:16.44.1125.0. We will post updates here as this rolls out to Current Channel. (A description of Office channels can be found here: https://docs.microsoft.com/en-us/deployoffice/overview-update-channels )

    If you are excited by this change or have comments for us, please share at File→Feedback.

    Thanks, Urmi

    S. Stockton supported this idea  · 
  19. 833 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  · 
  20. 999 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 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 since named ranges can be dynamic, meaning that the range is calculated when the workbook is calculated.

    We’ll continue tracking votes for this suggestion.

    S. Stockton supported this idea  · 
← Previous 1 3

Feedback and Knowledge Base