Feedback by UserVoice

 

Anonymous

← Welcome to Excel’s Suggestion Box!

My feedback

  1. color function formula

    6 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 
    Anonymous commented  · 

    I think it would be great if there was a function returning the background color of a cell so the result could be used in other formulas (in a simple if or a countif)

    But for now, if you want to count the number of non empty cells in a column with ONE background color, you can achieve this by using a table with a total row count [subtotal(103, column )] filtered by color.

  2. Use F4 key to lock reference in a table

    123 votes
    Sign in
    (thinking…)
    Password icon
    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]

    Anonymous supported this idea  · 

  3. change formula of calculated column without overwriting all cells

    5 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 

  4. Table Naming [#Headers] [#Totals] translation bug

    5 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

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

  5. abilty to set/edit the default table column formula

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

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

  6. New format cell date option: YYYY-MM-DD - facilitates chronological sorting

    9 votes
    Sign in
    (thinking…)
    Password icon
    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 →
    Anonymous commented  · 

    At least some locales already have this (it's the default format for me)
    It often called ISO 8601

    but if it's really not one of the date formats you have access to, you can define a personalized/custom format

  7. From to infinity

    6 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

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

  8. Power Query Advanced Editor and Formula Bar Intellisense

    35 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

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

  9. Dates w/o year

    6 votes
    Sign in
    (thinking…)
    Password icon
    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 →
    Anonymous supported this idea  · 

  10. Time and Date picker for 64-bit Excel 2016 version

    22 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 

  11. Scroll by pixel, not by cell.

    19 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

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

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

    13 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

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

  13. Filtering Needs to Work in Co-Authoring

    230 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    22 comments  ·  Excel for Windows (Desktop Application) » Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 

  14. Make Conditional Formatting Rules Editor window sizable.

    16 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 

  15. Perform Calculations (Sum, Count, If, etc.) Based on Cell Color

    16 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

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

  16. Make the Evaluate Formula dialog box re-sizable

    38 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

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

  17. Add cell reference to Data Validation Messages (Input Message, Error Alert)

    30 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 

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

    460 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

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

  19. Fix this problem: "sometimes you might find yourself with a workbook that has links you can’t find even though Excel tells you they exist. "

    41 votes
    Sign in
    (thinking…)
    Password icon
    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 →
    Anonymous supported this idea  · 

  20. Here’s an idea – RESPOND TO OUR COMMENTS! PROVIDE AN UPDATE!

    108 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    22 comments  ·  Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 
← Previous 1

Feedback and Knowledge Base

(thinking…)