Feedback by UserVoice

Ryan MacGregor

My feedback

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

    We’ll send you updates on this idea

    Ryan MacGregor commented  · 

    Although this would be nice, you'll need to use Winforms or WPF, rather than VBA, for this.

  2. 657 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Great suggestion – thanks again for taking the time to put it on this site and for the thoughtful followup comments. This is pretty related to some other work we’ve got going and already has a fair number of votes, so we’ll work on getting plans in place now and hope to get started on this soon.

    Thanks,
    John [MS XL]

    Ryan MacGregor commented  · 

    It has been over one year since MSFT's response that this feature is "planned."

    Ryan MacGregor supported this idea  · 
  3. 66 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ryan MacGregor commented  · 

    I received the same MSFT email message as Joseph Byrne yesterday and, if I understand Joseph's concerns correctly, I had similar concerns when I read the email. Not exactly clear from this email what MSFT's intentions are with respect to NULL(). Regardless, MSFT, please do not implement any charting changes related to null values until you have consulted with Jon Peltier (charting guru and Excel MVP), who is among the most vocal supporters of NULL().

  4. 25 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Interesting idea. Thanks for the feedback. We’ll consider this in our future planning. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

    Ryan MacGregor commented  · 

    A few add-ins (Peltier chart utility [http://peltiertech.com], Macabacus [https://www.macabacus.com], and apparently Formuladesk) offer this capability. However, since you can already paste charts as pictures into other Office docs using native functionality quite easily, most users won't ever need to save charts as pictures. This would be a niche feature.

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

    We’ll send you updates on this idea

    Ryan MacGregor commented  · 

    Until this is addressed in Excel, you'll need a third party solution to reset the Used Range. There are several tools that do this. Some are free (see https://support.microsoft.com/en-us/kb/244435) and some are part of larger, premium solutions (see https://macabacus.com/docs/excel/file-operations#clean-used-ranges). Since this has been an issue since at least Excel 2003, I wouldn't hold my breath for a solution from MSFT.

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

    We’ll send you updates on this idea

    Ryan MacGregor commented  · 

    Completely agree. We actually build a tool that removes the extraneous sheet name: https://macabacus.com/docs/excel/formulas-data#clean-cells.

  7. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ryan MacGregor commented  · 

    This tool is a much better way to trace precedents/dependents, and will handled structured tables references to other worksheets: https://macabacus.com/docs/excel/trace-precedents-dependents

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

    We’ll send you updates on this idea

    Ryan MacGregor commented  · 

    This has always been a curious omission for me.

  9. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ryan MacGregor commented  · 

    Ctrl+R is the shortcut for Fill Right, one of the most important operations you can perform in Excel. Doubt Microsoft will change that.

  10. 516 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ryan MacGregor commented  · 

    You can add the Center Across button to the QAT as an alternative. Unfortunately, there is no icon for this button.

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

    We’ll send you updates on this idea

    Ryan MacGregor commented  · 

    Macabacus has this. It's called Explorer Pane. See https://www.macabacus.com/features for more.

  12. 19 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Interesting suggestion Jon, thanks for posting it. There’s some other suggestions around blank/null, so we’ll be taking a look at the space in general, and making particularly sure that we consider related functions that get a lot of votes. As always, the more votes something gets the more chance that a specific request gets in the execution pipe sooner. So I just want to encourage folks to keep voting for the ideas they like best!

    Cheers,
    John [MS XL]

    Ryan MacGregor commented  · 

    I'd like to down-vote this. Referencing blank cells in formulas is generally poor practice. Too easy to accidentally delete a blank cell's row or column, which would produce a #REF! error in the formula referencing that cell. Use zeros for inputs rather than leave input cells blank.

  13. 19 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ryan MacGregor supported this idea  · 
  14. 30 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Interesting idea. We’ll consider this in the next round of feature planning. In the meantime, please continue to vote on this idea.

    Thanks,
    Scott [MSFT]

    Ryan MacGregor commented  · 

    Or this tool, which can also trace dependent charts and names, specifically: https://www.macabacus.com/docs/excel/trace-precedents-dependents.

  15. 34 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ryan MacGregor supported this idea  · 
  16. 249 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the suggestion Nick. We’ve got some related work we’re looking at soon, and we’ll be sure to carefully consider if we can get a fix in for this then. As always, more votes helps – so keep voting for the things you care about most.

    Thanks,
    John [MS XL]

    Ryan MacGregor supported this idea  · 

Feedback and Knowledge Base