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. Please Add Quick Analysis for Formatting

    Quick Analysis is available on Windows Excel 2016, but not Mac 2016 - please add.

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

    We’ll send you updates on this idea

    37 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  2. Match Destination Format

    In Preferences, allow for Match Destination Formatting as a default. Currently you can only do this by manually going to the Home>Paste area.

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

    We’ll send you updates on this idea

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  3. Resize columns in multiple sheets at the same time in the same workbook

    In Office 2016 Excel on Windows, when I select multiple sheets, then resize a column in one sheet, that change is applied to all of the other sheets in the workbook. This does not seem to work on Excel 2016 for Mac.

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

    We’ll send you updates on this idea

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  4. Check/Uncheck Filter Items Shortcut

    There is no shortcut to check/uncheck filter items in the dropdown for Mac.

    Space bar or return do not work.

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

    We’ll send you updates on this idea

    12 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  5. Fix Comments in Excel

    The comment box in Excel is broken, it often results in Excel crashing.

    1) It's laggy
    2) It opens with the words "Microsoft Office". THIS IS SO BIZZARE WHEN YOU THINK ABOUT IT! Why not just leave the comment empty? There's no point in advertizing Microsoft Office IN the comment, when the comment feature is not as beautiful yet as the rest of the suit, and causes an otherwise wonderful program to CRASH rather often.

    A new comment should be empty, or PERHAPS have a greyed out phrase "enter comment here...", which dissapears the moment you click on the new…

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

    We’ll send you updates on this idea

    8 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  6. Number of Decimal Points

    The default way Excel displays numbers after the decimal point needs an update. Right now, here are the results of Excel default formatting settings. (the values in brackets are in different cells)

    A1 = [1.234]
    A2 = [1.234]
    A3 = [A1*A2] displays [1.522756]
    2X increase in values displayed post decimal!
    4 sig figs become 7 sig figs

    A1 = [2]
    A2 = [Log(A1)] displays 0.30103
    5X increase in values displayed post decimal!
    1 sig figs become 7 sig figs

    Excel is clearly just displaying all the digits it calculates. This is not the proper way to account for significant figures,…

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

    We’ll send you updates on this idea

    3 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  7. AutoFit Row Height for Merged Cells

    Long time ask by many...create a button or functionality to AutoFit the row height for merged cells for those that use Excel to create forms, summary reports (based on drop-downs and IF statement). There are all sorts of ways to do this with Macros, some hard, and some easy, but it's so basic and needs to finally exist as an option.

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

    We’ll send you updates on this idea

    2 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  8. Some commands do not work in Quick Access Toolbar

    I need to have certain commands available on the QAT. I use Paste Values a lot but although I can place it in the QAT, it does not work from that location. Please look into this.

    Actually the QAT needs a complete rethink in my opinion. It is given so little prominence, especially when compared to the enormous amount of real estate occupied by the ribbons and their huge content of commands, most of which are not required on a regular or even irregular basis.

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

    We’ll send you updates on this idea

    2 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  9. 10 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  10. Merge Down option - just like Merge Across, but Down. Quick Add.

    There exists a "Merge Across" option. A "Merge Down" option should also exist. So you can highlight multiple rows in multiple columns, and you can merge down, so the rows in each column merge, keeping the columns separate. Same principle as Merge Across, just Merge DOWN. Quick add.

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

    We’ll send you updates on this idea

    3 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  11. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  12. what if we added a choice to transfer sheets from bottom to left side instead of column A?

    what if we can add a choice for users to transfer sheets from bottom to left side instead of column A?
    as excel user, I start using first sheet, then second one then third one then I find myself using high NO of sheets which makes finding specific sheet boring and frustrating. and if we have high NO of sheets, it will be harder even if I name the sheets

    but what if we had the ability to transfer all sheets from bottom to left side from top as they fill all column A and column A starts the next…

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

    We’ll send you updates on this idea

    2 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  13. Copy paste conditional formatting only

    Being able to copy conditional formatting and paste it without pasting the all format of the cell, only the conditional formatting.

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

    We’ll send you updates on this idea

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  14. Conditional formatting - Apply to named ranges

    Currently if you apply conditional formatting to a named range (i.e. a range named via the Name Manager or a table style named-range), the value in the "Applies to" column of the Conditional Formatting Rules Manager will immediately revert the named range to its absolute cell reference.

    eg. "Applies to: =Table1[Column3]" becomes "Applies to: =$C$2:$C$7".

    Apart from being more difficult to read, it creates other complexities. For example, if I insert a new column into this range, it creates a mess in the rules manager, creating a new rule for each cell pasted.

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

    We’ll send you updates on this idea

    2 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  15. Excel - Format a comment in every way, not just text. Essential.

    Formatting a comment, not just the text, is essential. Comments are mini Notes & need to highlighted in many ways. I don't have a sheet without Comments & I use Excel more that Word. In versions before the subscription version you could format a comment completely. Tried using call outs but need to preserve roll-over function as wells permeant view of comments.

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

    We’ll send you updates on this idea

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  16. bullet items for words in a cell

    allow items in a cell to be buletted

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

    We’ll send you updates on this idea

    5 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  17. Font format or cell width changed in 2016

    I have many spreadsheets in which I had tailored cell widths to just fit the text I had in column headers, and upon upgrading to 2016, either the font format has changed or the cell widths have become smaller to the extent that many of my column headers have words that are split on two lines now. What did Microsoft do to make a global change in formats that has affected many of my spreadsheets? Is anyone else seeing this?

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

    We’ll send you updates on this idea

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  18. Translator Function... add it.

    Need the Translator function add to Microsoft Excel for Mac... all versions...

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

    We’ll send you updates on this idea

    4 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  19. include a date picker function for excel, similar to the the date picker on the developer tab in word

    include a date picker function for excel, similar to the the date picker on the developer tab in word

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

    We’ll send you updates on this idea

    3 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  20. touch

    Please, add a function of customising Touch Bar! There are only default functions on it with no opportunity of customising! It is horrible!

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

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5
  • Don't see your idea?

Feedback and Knowledge Base