Feedback by UserVoice

Jon Peltier

My feedback

  1. 170 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
    Jon Peltier commented  · 

    I can envision hybrid dynamic array tables. Given a Table, I would like to write a dynamic array formula in a cell that spills into an entire column. Given a dynamic array formula, I'd like to convert the spill range to a Table, or at least apply some features of Tables to the spill range. The more I think of it, the more powerful and more complicated it sounds.

    Jon Peltier supported this idea  · 
  2. 77 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

    Jon Peltier supported this idea  · 
  3. 41 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

    Jon Peltier supported this idea  · 
  4. 9 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

    Jon Peltier supported this idea  · 
  5. 9 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
    Jon Peltier commented  · 

    Yet another problem is that the LAMBDA formula is not exposed to VBA. When you query the .RefersTo property of a Name, all you get is "=".

    Jon Peltier supported this idea  · 
    An error occurred while saving the comment
    Jon Peltier commented  · 

    Another problem is that the Refers To box is stuck at one line only, while the Comments box is else to grow without limit. I've never used the Comments box, but I'm always stuck with the to small Refers To box, even if I'm not editing a Lambda function.

  6. 115 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
    Jon Peltier commented  · 

    I imagine we'll need more than 8192 characters in a formula soon, especially if we start to allow inline comments and indenting.

    Jon Peltier supported this idea  · 
  7. 23 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
    Jon Peltier commented  · 

    Also include it among VBA's WorksheetFunction offerings.

    Jon Peltier supported this idea  · 
  8. 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

    An error occurred while saving the comment
    Jon Peltier commented  · 

    I've never used the Select Objects tool to select objects in a chart or on a chart sheet, but I can see how it would be helpful. I can verify that it did in fact work in Excel 2010 and does not work in Excel for Microsoft 365.

    Jon Peltier supported this idea  · 
  9. 150 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

    23 comments  ·  Excel for the web » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Jon Peltier 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

    Jon Peltier supported this idea  · 
  11. 52 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

    Jon Peltier supported this idea  · 
  12. 289 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

    Jon Peltier supported this idea  · 
  13. 58 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

    Jon Peltier supported this idea  · 
  14. 21 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

    Jon Peltier supported this idea  · 
  15. 10 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

    Jon Peltier supported this idea  · 
  16. 9 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

    Jon Peltier supported this idea  · 
  17. 67 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

    Jon Peltier supported this idea  · 
  18. 69 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

    Jon Peltier supported this idea  · 
  19. 85 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

    Jon Peltier supported this idea  · 
  20. 176 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 suggestion Frederic – thanks for taking the time to post it. We’ll take a look at the F4 loop and including other functionality like this as soon as we can. We’ll be spending more time on the things with more votes – so folks that really want to see this should keep voting it up.

    Best,
    John [MS XL]

    Jon Peltier supported this idea  · 
← Previous 1 3 4

Feedback and Knowledge Base