Feedback by UserVoice

 

Zack Barresse

← Welcome to Excel’s Suggestion Box!

My feedback

  1. Range.Text should be able to return an array of results like Range.Value

    33 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) » Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
    Zack Barresse supported this idea  · 

  2. Get Tables working on protected sheets (add rows, sort, filter, etc.)

    901 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

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

    Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!

    Thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

    Zack Barresse supported this idea  · 
    Zack Barresse commented  · 

    Another related item: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/11561115-allow-inserting-and-deleting-structured-table-rows

    Zack Barresse commented  · 

    This was previously posted in a similar thread here: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/11561115-allow-inserting-and-deleting-structured-table-rows

    Zack Barresse commented  · 

    The problem goes much deeper than just sorting. Even inserting rows is impossible on a Table with sheet protection turned on. Good idea!

    Zack Barresse shared this idea  · 

  3. Use F4 key to lock reference in a table

    135 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) » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    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]

    Zack Barresse supported this idea  · 
    Zack Barresse commented  · 

    Ditto to what Jan states. It's highly confusing with the different behaviors.

  4. Is it possible to have red arrow goes up and green arrow goes down for conditional formatting ?

    20 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) » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    Zack Barresse commented  · 

    If we could customize the icons, as Ken mentioned, it would pretty much solve this problem too. :)

  5. Give us a proper ITERATION or INSTANCE function for duplicates

    24 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) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Zack Barresse commented  · 

    Charles Williams has something similar in FastExcel, titled AVLOOKUPNTH. This is similar to what I'm describing, but more like LOOKUPNTH.

    Zack Barresse shared this idea  · 

  6. Select protected/unprotected cells

    9 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) » Formatting  ·  Flag idea as inappropriate…  ·  Admin →

  7. Change Excel Table Name in the Create Table Window

    51 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

    8 comments  ·  Excel for Windows (Desktop Application) » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
    Zack Barresse supported this idea  · 

  8. Go to first/last tabs

    90 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

    63 comments  ·  Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
    Zack Barresse commented  · 

    The arrows will only navigate the sheets, not actually make an activation. The elipses will actually make an activation on the next visible sheet on the far left/right.

    You can also right-click the left/right arrows and get the activate sheet dialog box.

    And I agree, I miss those buttons. :)

  9. Have cursor default to Search cell in Filters.

    4 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) » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
    Zack Barresse commented  · 

    Once the filter drop-down is activated, hit the E key to put your cursor in the search bar. :)

    Check out Jon Acampora's blog post on it: http://www.excelcampus.com/keyboard-shortcuts/filter-dropdown-menu-shortcuts/

  10. Creation of PPT slides directly from excel Sheet

    89 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

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

    This is an interesting idea. We will definitely consider it while planning our next round of features. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

    Zack Barresse commented  · 

    This is something done quite often. We have to write code to do this currently, which is quite popular. Having this functionality natively would be used quite a bit I imagine. Good idea Rajender!

  11. Add Center Across Selection to the Merge & Center Drop-down

    498 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

    77 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    Zack Barresse commented  · 

    I'd like to see it added to the Merge & Center split button. :)

  12. Case Sensitive Date Format Rules

    8 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) » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    Zack Barresse commented  · 

    You can do this currently by defining a new Custom List. But yes, it would be nice. :)

  13. More/Custom QAT icons

    15 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) » Graphics  ·  Flag idea as inappropriate…  ·  Admin →
    Zack Barresse commented  · 

    You can do this programmatically now: http://www.rondebruin.nl/win/s2/win008.htm

  14. Workbook level calculation

    186 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

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

    Thanks for the post Charles, and for the in person conversation at the latest MVP conference. We definitely understand the ask and will keep our eye on it – it looks like it’s moving up the vote charts pretty quickly. As always, keep upvoting the things you are about most.

    Best,
    John [MS XL]

    Zack Barresse supported this idea  · 

  15. Fix sort

    21 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 the web  ·  Flag idea as inappropriate…  ·  Admin →
    Zack Barresse commented  · 

    Should be using a Table. This problem never surfaces.

  16. Add ability to collapse field areas in PivotTable Field and Area Side by Side view

    424 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

    9 comments  ·  Excel for Windows (Desktop Application) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  Ashvini Sharma (Lead Program Manager, Microsoft) responded

    Hi Ken,

    Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!

    thanks
    ash [MS XL]

    Zack Barresse supported this idea  · 

  17. Auto resizing of formula bar

    136 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

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

    Thanks for the suggestion. I think I’ve seen some related requests, I’ll look at merging them to make sure the votes properly reflect the ask. We’ll prioritize this into the execution pipe appropriately based on the number of votes.

    Cheers,
    John [MS XL]

    Zack Barresse supported this idea  · 

  18. Intellisense for User Defined Functions

    242 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

    11 comments  ·  Excel for Windows (Desktop Application) » Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    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]

    Zack Barresse commented  · 

    This will be tough in the current process. It's possible with things like Excel DNA already though.

  19. Excel Treeview - VBA Control

    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

    Accepting Votes  ·  5 comments  ·  Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
    Zack Barresse commented  · 

    I'm all for having the object model be current with the current resources in the application.

  20. Give us a proper NULL() worksheet function.

    645 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

    64 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    planned  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    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]

    Zack Barresse supported this idea  · 

Feedback and Knowledge Base

(thinking…)