My feedback

1. Select Objects - Objects on Chart Sheet

   2 votes

   Vote Vote Vote

   Sign in

   prestine

   Your name

   Your email address

   (thinking…)

   

   Password

   Sign in with: Facebook Google

   Forgot password?

   Create a password

   I agree to the terms of service

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  Excel for Windows (Desktop Application) » Editing  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   An error occurred while saving the comment
   Jon Peltier commented  ·  Oct 3, 2020  ·  Edit…  ·  Delete…

   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.

   Save Submitting...
   Jon Peltier supported this idea  ·  Oct 3, 2020

2. CELL function added to online

   115 votes

   Vote Vote Vote

   Sign in

   prestine

   Your name

   Your email address

   (thinking…)

   

   Password

   Sign in with: Facebook Google

   Forgot password?

   Create a password

   I agree to the terms of service

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   19 comments  ·  Excel for the web » Formulas and Functions  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Jon Peltier supported this idea  ·  Sep 19, 2020

3. LET function should better return #NAME? whenever undefined variable was used inside the formula

   2 votes

   Vote Vote Vote

   Sign in

   prestine

   Your name

   Your email address

   (thinking…)

   

   Password

   Sign in with: Facebook Google

   Forgot password?

   Create a password

   I agree to the terms of service

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   2 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Jon Peltier supported this idea  ·  Aug 31, 2020

4. Enable Center Across Selection to be added to the Quick Access Toolbar

   51 votes

   Vote Vote Vote

   Sign in

   prestine

   Your name

   Your email address

   (thinking…)

   

   Password

   Sign in with: Facebook Google

   Forgot password?

   Create a password

   I agree to the terms of service

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Jon Peltier supported this idea  ·  Aug 8, 2020

5. SUMCOLS and SUMROWS functions for Dynamic Arrays

   270 votes

   Vote Vote Vote

   Sign in

   prestine

   Your name

   Your email address

   (thinking…)

   

   Password

   Sign in with: Facebook Google

   Forgot password?

   Create a password

   I agree to the terms of service

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   38 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Jon Peltier supported this idea  ·  Jun 12, 2020

6. Display pivot table headers in the columns headers

   •  

   36 votes

   Vote Vote Vote

   Sign in

   prestine

   Your name

   Your email address

   (thinking…)

   

   Password

   Sign in with: Facebook Google

   Forgot password?

   Create a password

   I agree to the terms of service

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

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

   We’d like to see how many votes this gets as a way to help us prioritize the work. Thanks!

   Jon Peltier supported this idea  ·  Jun 12, 2020

7. Add Corkscrew function for dynamic arrays

   20 votes

   Vote Vote Vote

   Sign in

   prestine

   Your name

   Your email address

   (thinking…)

   

   Password

   Sign in with: Facebook Google

   Forgot password?

   Create a password

   I agree to the terms of service

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   6 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Jon Peltier supported this idea  ·  Jun 10, 2020

8. DIFF function for Dynamic Arrays

   8 votes

   Vote Vote Vote

   Sign in

   prestine

   Your name

   Your email address

   (thinking…)

   

   Password

   Sign in with: Facebook Google

   Forgot password?

   Create a password

   I agree to the terms of service

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Jon Peltier supported this idea  ·  Jun 10, 2020

9. Moving average function for dynamic arrays

   8 votes

   Vote Vote Vote

   Sign in

   prestine

   Your name

   Your email address

   (thinking…)

   

   Password

   Sign in with: Facebook Google

   Forgot password?

   Create a password

   I agree to the terms of service

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Jon Peltier supported this idea  ·  Jun 10, 2020

10. "Blank" option to the top of the excel filter options

    •  

    66 votes

    Vote Vote Vote

    Sign in

    prestine

    Your name

    Your email address

    (thinking…)

    

    Password

    Sign in with: Facebook Google

    Forgot password?

    Create a password

    I agree to the terms of service

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    3 comments  ·  Excel for Windows (Desktop Application) » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Jon Peltier supported this idea  ·  Jun 10, 2020

11. Please fix conditional formatting!!

    64 votes

    Vote Vote Vote

    Sign in

    prestine

    Your name

    Your email address

    (thinking…)

    

    Password

    Sign in with: Facebook Google

    Forgot password?

    Create a password

    I agree to the terms of service

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

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

12. Searchable drop down option

    75 votes

    Vote Vote Vote

    Sign in

    prestine

    Your name

    Your email address

    (thinking…)

    

    Password

    Sign in with: Facebook Google

    Forgot password?

    Create a password

    I agree to the terms of service

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    15 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Jon Peltier supported this idea  ·  Jun 10, 2020

13. Use F4 key to lock reference in a table

    166 votes

    Vote Vote Vote

    Sign in

    prestine

    Your name

    Your email address

    (thinking…)

    

    Password

    Sign in with: Facebook Google

    Forgot password?

    Create a password

    I agree to the terms of service

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    17 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  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]

    Jon Peltier supported this idea  ·  Jun 10, 2020

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

    •  

    •  

    158 votes

    Vote Vote Vote

    Sign in

    prestine

    Your name

    Your email address

    (thinking…)

    

    Password

    Sign in with: Facebook Google

    Forgot password?

    Create a password

    I agree to the terms of service

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    36 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    An error occurred while saving the comment
    Jon Peltier commented  ·  Jun 10, 2020  ·  Edit…  ·  Delete…

    My "favorite" is the dialog for selecting custom error bar value ranges.

    Save Submitting...
    Jon Peltier supported this idea  ·  Oct 17, 2019

15. Add 'date picker' to enable users to select a date from a mini calendar into cells

    1,747 votes

    Vote Vote Vote

    Sign in

    prestine

    Your name

    Your email address

    (thinking…)

    

    Password

    Sign in with: Facebook Google

    Forgot password?

    Create a password

    I agree to the terms of service

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

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

    Hi all,

    We have been working on this, and wanted to get your feedback on how you see this feature fitting into your workflow. We have a quick one question survey for you to give us your thoughts on the look and keyboard shortcuts we have at this time. Please see here for more: aka.ms/datePickerSurvey

    Thanks!
    Blake, Excel Product Team

    Jon Peltier supported this idea  ·  Jun 10, 2020

16. Number format thousand separator and no decimals

    602 votes

    Vote Vote Vote

    Sign in

    prestine

    Your name

    Your email address

    (thinking…)

    

    Password

    Sign in with: Facebook Google

    Forgot password?

    Create a password

    I agree to the terms of service

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    108 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    not at this time  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    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 to be used for new workbooks. Follow the steps here: https://support.microsoft.com/office/customize-how-excel-starts-6509b9af-2cc8-4fb6-9ef5-cf5f1d292c19

    2. Another option is to create a macro in your personal macro workbook which can be assigned to a shortcut key or added as a button to your QAT or ribbon. To do so, select a cell containing a number, then start recording a macro. Type a name for your macro, and type a letter to use as the shortcut key you want, such as T (the shortcut would be CTRL+SHIFT+T). Make sure you choose to store the macro in your Personal Macro Workbook, so it’s available no matter which file you have open. Then click OK to start recording. Then set the cell format as desired and stop recording.

    With that, can select a range of cells and press CTRL+SHIFT+T to apply the number format.
    The macro should have code that looks something like this:

    Sub SetThousandsWithNoDecimals()

    ’ Set Thousands With No Decimals
    ’ Keyboard Shortcut: Ctrl+Shift+t
    ’
    Selection.NumberFormat = “#,##0_);(#,##0)”

    End Sub

    Steve [Microsoft Excel]

    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… more

    Jon Peltier supported this idea  ·  Jun 10, 2020
    An error occurred while saving the comment
    Jon Peltier commented  ·  Jun 10, 2020  ·  Edit…  ·  Delete…

    I'd like to be able to put a few favorite formats up there. A number format (the comma icon doesn't even point to a numeric format, but an accounting one), a date format or two, etc.

    Save Submitting...

17. Be able to protect Power Query with password

    346 votes

    Vote Vote Vote

    Sign in

    prestine

    Your name

    Your email address

    (thinking…)

    

    Password

    Sign in with: Facebook Google

    Forgot password?

    Create a password

    I agree to the terms of service

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    25 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    not at this time  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Thank you for taking your time to suggest and vote for being able to protect Power Query with a password. This is a good idea, but we don’t think we’ll be able to support this in the near future. We’ll continue tracking votes for it.

    Guy Hunkin
    Excel Team

    Jon Peltier supported this idea  ·  Jun 10, 2020

18. Be able to protect Power Pivot data model and measures with password

    127 votes

    Vote Vote Vote

    Sign in

    prestine

    Your name

    Your email address

    (thinking…)

    

    Password

    Sign in with: Facebook Google

    Forgot password?

    Create a password

    I agree to the terms of service

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    not at this time  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Thank you for suggesting this feature, but this is not something we’re likely to implement anytime soon. The reality is that this sort of feature only helps to keep honest folks honest, and doesn’t provide true security, because anyone with permission to a workbook can modify that workbook. For scenarios where the database really needs to be securely maintained, a better answer is to deploy the data model to either an Analysis Services server or to Power BI. By doing that, the data model (an AS tabular database) will be maintained independently of the workbook, and users will be able to connect to the database and query it from their Excel PivotTables but will not be able to modify it.

    Jon Peltier supported this idea  ·  Jun 10, 2020

19. Stop Copy & Paste overwriting Data Validation

    137 votes

    Vote Vote Vote

    Sign in

    prestine

    Your name

    Your email address

    (thinking…)

    

    Password

    Sign in with: Facebook Google

    Forgot password?

    Create a password

    I agree to the terms of service

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    32 comments  ·  Excel for Windows (Desktop Application) » Editing  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Jon Peltier supported this idea  ·  Jun 10, 2020

20. Allow interaction with Excel while in Power Query

    592 votes

    Vote Vote Vote

    Sign in

    prestine

    Your name

    Your email address

    (thinking…)

    

    Password

    Sign in with: Facebook Google

    Forgot password?

    Create a password

    I agree to the terms of service

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    43 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    not at this time  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    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

    Jon Peltier supported this idea  ·  May 29, 2020