Feedback by UserVoice

 

Detlef Lewin

← Welcome to Excel’s Suggestion Box!

My feedback

  1. Function and formulas recommended

    74 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

    20 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Detlef Lewin commented  · 

    You mean like "Totals" in "Quick Analysis"?

  2. Make it easier to find external links

    270 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

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

  3. Link the min and max values of a chart axis to cell value

    950 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

    96 comments  ·  Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
    Detlef Lewin supported this idea  · 

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

    637 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]

    Detlef Lewin supported this idea  · 

  5. Add an IFCOND() function

    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

    13 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Detlef Lewin commented  · 

    This should be set to 'Completed' to free the 43 votes.

  6. Allow Tables to be referenced by name from another workbook

    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) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Detlef Lewin supported this idea  · 

  7. Improve Data Validation (make it AutoComplete based on typed characters)

    189 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

    35 comments  ·  Excel for Windows (Desktop Application) » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    Detlef Lewin supported this idea  · 

  8. Apply Subtotals to a Table

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

    I agree with Kenneth Barber. Tables are for raw data and the occasional filtering/sorting. Pivot tables are for analysing and summarizing raw data.

  9. Allow pasting of criteria in auto filter

    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

    1 comment  ·  Excel for Windows (Desktop Application) » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
    Detlef Lewin commented  · 

    'Filter by selection' is already available.
    https://support.office.com/en-us/article/Filter-data-in-a-range-or-table-d80e0c9c-a930-4ec4-ab95-54271910faed?ui=en-US&rs=en-US&ad=US#bmfilter_by_selection

  10. Dynamic headings or additional header rows in tables

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

    A workaround could be to place the additional information above the header row without being part of the table.
    The underlying problem is that a table needs individual headers (no duplicates). If formulas would be allowed there is no way to guarantee individual headers.

  11. Sort results of formulas

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

    I guess your having sheet references in the formula referring to the same sheet the formula is on. Remove these sheet references and sorting will work properly.

  12. Fix filter annoyances

    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

    3 comments  ·  Excel for Windows (Desktop Application) » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
    Detlef Lewin commented  · 

    #2
    Maybe it would be better to automatically resize the item list depending on the width/length of the entries and the amount space to the right/bottom of the screen.

  13. Show count of items represented by each checkbox in the Filter dropdown menu

    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

    2 comments  ·  Excel for Windows (Desktop Application) » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
    Detlef Lewin commented  · 

    You could easily set up a pivot table with the count of item.
    And I suppose it would take some time to calculate the count each time you open the filter dropdown. Longer lists will take more time.

  14. Enable user filter views

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

    'Custom views' already exist.
    https://support.office.com/en-us/article/Create-apply-or-delete-a-custom-view-ce722bf9-0b4a-49a5-94ba-438fde18fc2b?CorrelationId=1e8297ae-2405-49af-aea1-af5d571c2b8d&ui=en-US&rs=en-US&ad=US

Feedback and Knowledge Base

(thinking…)