Feedback by UserVoice

Excel for Mac

Welcome to the Excel for Mac forum! This is the place for users to send us suggestions and ideas on how to improve. To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Dangerous sort function! Fix default to sort entire sheet!

    An empty column during SORT just ruined my entire dataset!!! It sorted the data only to the left of the empty column! Fix this please! Who would want to sort only part of their dataset if they had pressed SORT without selecting a subset of columns!!!??? Illogical functionality is DANGEROUS!

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  2. Filter funktion for all rows (instead of the first 10 000)

    Today in the Mac version (16.44) the filtering funktion only reads the first 10 000 rows and there is nothing that give you a hint that this is the fact. (Sort funktion seems to work for at least 70K+ though). Please make this work or att least make the system tell you that the answer is wrong otherwise this can create gigantic problems......

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  3. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  4. Can the find bar retain the last search?

    So I just upgraded from an older version of office that I was very familiar with.

    Now every time I try command + F, I have re-type what I was searching for.

    Is it possible for the last search item to show up in the find bar? Would be great if it's already highlighted, in-case need to search for new item then can type straight away and no need to hit delete.

    Thank you

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  5. Database

    Any table in Excel can be used as a database to select, extract and copy data to another location, for further use. Unfortunately the basics of it are not clear in Excel help, where discussions on PivotTables blurr everything.

    First, define an Input Table containing all data, with column labels in top row.
    Second, use Advanced Filter to define Criteria and Output range.
    Criteria range must have two lines : one for column labels, one for sort values.
    Ouput range needs one line only, with all chosen column labels in it. Selected data will display below it.

    Enjoy !

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  6. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  7. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  8. Enable merging and splitting cells

    I used to use this feature a lot on windows, now I have a MacBook I can no longer use it.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  9. Templates: budgeting, YTD or custom date field review (not just monthly)

    Data is great - now to set up a budget for 2021 and then have actual to budget by category.

    In reviewing expenses: have customers date range and YTD -- also, on the snapshot, have the option look at more items.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  10. Create an option to group together sheets in an excel by category

    For example, a single excel for all teachers in a school could include sheets with schedules for each day of the week, responsibilities/guidelines/priorities, student directories by grade, etc. If I could group the sheets for schedules together, or student directories of all grades, that would help organize the space.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  11. Create an option to group together sheets in an excel by category

    For example, a single excel for all teachers in a school could include sheets with schedules for each day of the week, responsibilities/guidelines/priorities, student directories by grade, etc. If I could group the sheets for schedules together, or student directories of all grades, that would help organize the space.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  12. In the excel filter menu show a light colored bar to show how many of that value there are in the column.

    An underlay behind the fliter menu to show the count of each value in the filter menu for that column.
    This will give users a good indication of the impact of that value. In a second phase, hovering over the value could give a tool tip with the count or make the count show up on the right hand side of the filter menu.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  13. Create a user tutorial for pivot tables.

    Create step by step user tutorial for pivot tables.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  14. Autofilter shortcut button for filtering by selected cell — already exists in Windows version

    The Autofilter shortcut is an available button in the Windows version that you can bring into the Quick Access Toolbar or ribbon. Select a cell and click the Autofilter button -> the selection is then automatically filtered by the selected cell. Currently, we have to navigate a long-winded context menu path. This would be a real time saver for all those working with reams of data in tables.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  15. Add possibility to copy/paste information from filtered cells

    Wfhen applying a filter, it is currently not possible to copy and paste information without getting an error message

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  16. Ability to Drag and Drop Rows/columns to re-order

    I would like the ability to drag-and-drop rows and columns to re-order them. Google Sheets has this ability and I use it all the time. In excel if I want to move a row or column to re-order it, I need to use copy/paste and insert. It's a pain. If I'm viewing a list of items which I want to put into priority order, it is very difficult to do this in Excel. Whereas in Google Sheets, I can just drag and drop the rows to re-order them very easily.

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  17. Put ‘FORMS” back into the ribbon

    When setting a table The “Forms” option is no longer available. Strangely enough that was one of the reasons I purchased 360.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  18. Permit opening and closing groups in protected worksheets

    It is annoying to have to unprotect a worksheet each time you need to open or close a group.

    When protecting a worksheet, have a tick option to permit this or not.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  19. Comma Separation Option for Text String Values in Single Cell

    I have an .xlsx containing the titles of a bunch of books I'm using for a project with columns for things like the Title, Author, Year Published, etc. One of those columns is a "Keyword" column for classifying the book: e.g. novel, science fiction, anti-hero, etc. Each book has an entry containing multiple keywords, separated by commas.

    What I would like to be able to do is set up a filter for the entire sheet so that I can quickly pull up books tagged with a particular keyword. Unfortunately, Excel treats the text in the cell as a single value,…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  20. Easy Tables & Charts

    Allow Mac users to create tables, graphs, and charts as easy as on Windows.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4
  • Don't see your idea?

Feedback and Knowledge Base