Feedback by UserVoice

 

Jon Peltier

← Welcome to Excel’s Suggestion Box!

My feedback

  1. Sheet-side Split function

    66 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    15 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Jon Peltier commented  · 

    This would be a great addition to the Dynamic Array family of functions.

    Jon Peltier supported this idea  · 

  2. Add new Split formula

    73 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    15 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Jon Peltier commented  · 

    This would be a great addition to the Dynamic Array family of functions.

    Jon Peltier supported this idea  · 

  3. SUBSTITUTES function supporting arrays of "find" and "replace" parameters

    64 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    5 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Jon Peltier supported this idea  · 

  4. XLOOKUP to return an array of ranges

    12 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    5 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Jon Peltier supported this idea  · 

  5. Scroll horizontally by pressing Shift+Wheel scroll, or with mice that support side scroll, like Adobe Reader, Chrome, IE...

    146 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    47 comments  ·  Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
    Jon Peltier supported this idea  · 

  6. SUMCOLS and SUMROWS functions for Dynamic Arrays

    171 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    23 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Jon Peltier supported this idea  · 

  7. Make all windows (Dialog Boxes) containing variable-sized content resizable

    102 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    25 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Jon Peltier supported this idea  · 

  8. Unhide multiple worksheets at once

    605 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    58 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Jon Peltier supported this idea  · 

  9. Conditional formatting - Apply to named ranges

    798 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    213 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Thanks to Graham for starting this conversation. If you would also like Excel to maintain named range references and structured table references in the “applies to” field for Conditional Formatting rules, please add your comments and vote this one up. We will prioritize accordingly.

    Thanks,
    Steve (MS Excel)

    Jon Peltier supported this idea  · 

  10. Translate XLOOKUP and XMATCH to PROCX and CORRESPX in Portuguese

    298 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    25 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Jon Peltier supported this idea  · 

  11. Option To Refresh Stock Data When File Opens

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
    Jon Peltier supported this idea  · 

  12. Axis title high-low option for charts.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    2 comments  ·  Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
    info needed  ·  Scott Ruble (PM MSFT) responded

    I’m not able to reproduce the problem you are describing. Can you send me more explicit steps that are needed to reproduce it and a sample file?

    Thanks,
    Scott [MSFT]

    Jon Peltier commented  · 

    The OP is talking about a horizontal bar chart, so the category labels are on the vertical axis, but it's still the X axis.

    Excel plots the first category next to the chart's origin, which is the bottom left corner where the axes intersect. The second category is next to that, and so on. Starting at the origin, categories in a column chart go left to right, which seems normal. Starting at the origin, categories in a bar chart go bottom to top, which has always seemed normal to me (knowing about that whole origin thing) but confuses most people.

    The way Excel would best address this without messing up existing charts and existing chart code that knows about the chart's origin, would be to default a bar chart to having Categories in Reverse Order checked and Crosses at Maximum selected.

  13. Excel hex color codes for formatting

    43 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    4 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    Jon Peltier supported this idea  · 

  14. Keep freeze panes setting when opening a second window.

    49 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    15 comments  ·  Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
    Jon Peltier supported this idea  · 

  15. Select Pivot Table by name

    11 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    Jon Peltier supported this idea  · 

  16. Enable better control of treemaps

    7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    4 comments  ·  Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  Scott Ruble (PM MSFT) responded

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

    Thanks,
    Scott [MSFT]

    Jon Peltier supported this idea  · 

  17. Make find and replace work in charts for easier formula editing

    10 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    2 comments  ·  Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  Scott Ruble (PM MSFT) responded

    We’ll consider this for a future release. Please continue to vote on this feature request which will increase its likelihood of getting in the product.

    Thanks,
    Scott [MSFT]

    Jon Peltier supported this idea  · 

  18. Let me choose Decimal separator and Date order in PowerQuery instead of guessing

    32 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    7 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    Jon Peltier supported this idea  · 

  19. More information for Err: "A PivotTable Report cannot overlap another PivotTable Report"

    16 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    3 comments  ·  Excel for Windows (Desktop Application) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    Jon Peltier supported this idea  · 

  20. Default the Power Query formula bar as on

    62 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    6 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    Jon Peltier supported this idea  · 
← Previous 1 3

Feedback and Knowledge Base

(thinking…)