Feedback by UserVoice

Excel for Mac

Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more

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. Add the ability to set defaults for conditional formatting options

    Saving conditional formatting options for when you are working with multiple spreadsheets that need to stay separate but have the same conditions applied

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  2. Add a DateTime Cell Format

    Excel has been around for what seems to be forever, and this problem has been around for what seems to be forever!

    When working with data, such as a database extract, all DateTime fields and considered to be a Time format. So 24/02/2014 15:30
    appears as 30:32.0.

    The function I use more than anything, but a long way is to reformat this cell to dd/mm/yyyy hh:mm. Every time, for a million times over the years!

    It would save the world hours of (confusion and) productivity time if Excel had a DateTime format, which combined our Windows preferred date format with…

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  3. It would be nice to be able to add a space after the text or ??? in a cell on AutoFit (kinda like indent) so the columns won't be so bunched

    Add and option to include spaces on the right when you AutoFit in VBA like you do to the left (indent) to keep the columns from getting so tight. I think it would make it a lot easier to read. Not so bunched up.

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  4. Add Right (indent) to formatting options

    Excel for PC has had Left and Right (indent) in formatting since 2007. Excel for Mac only has Left (indent).

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  5. Stop removing leading zeros

    Our inventory system is ruined because we've just discovered that Excel removes leading zeros from barcodes (in fact leading zeros from all numbers) when you import or paste-in.

    This is truly mind-numbing because...
    1) You're running data - why would you ever do this?
    2) You always discover this nonsense after the fact with is so frickin' painful.

    For the love of God, why do this and why change stuff automatically with no user input or notification? Get it sorted.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  6. Grouping

    When grouping rows or columns, it would be nice if the +/- sign (to un-/hide them) would be at the beginning and not at the end of the selected rows (columns)

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  7. Conditional Formatting by row

    I often come across instances where I need to heat map a lot of lines of data using heat map option in conditional formatting. However to do this by row I have to select a row at a time. I tried to do a via script but my scripting skills aren't great. Could we get a option where we can do the heat map by all data (currently available) as well as heat map by row of data? heat map by column may be useful for some also.

    Happy to be contacted too explain further/upload examples.

    thank you!

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  8. stop autocorrecting numbers into dates

    Please provide the option to stop turning numbers into dates. It's so frustrating. There should be a global option to stop that mess. When a person is working with data that includes these kinds of numbers frequently, like I do, working on managing assessment for grades K-12, and specifically the grade ranges 3-5 and 6-8 (NOT March and July) it's so frustrating to have those numbers auto-corrected when I export database information and I have to go through the hassle of fixing it constantly. Seriously, that's not helping.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  9. Autofit row height of merged cells

    It would be great if we could autofit row height of merged cells (either by double-clicking or after entering data) like it happens with un-merged cells.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  10. Support for Engineering Number Format

    Same as Scientific format, but exponent is limited to multiples of 3 to correspond with metric system Kilo, Mega, Giga

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  11. Duplicate a conditional formatting rule WITHIN the "Manage Rules" pane

    I frequently have conditional formatting rules that are nearly identical except for one minor detail. For example, if I wanted to highlight a cell red when it says "Apple" or "Cherry"," I have to create two completely different rules in the "Manage Rules" window from scratch. I would like to be able to duplicate a rule within the window, then change the one difference between them.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  12. Please add Print preview back to Excel and Word for Mac

    Please add Print preview back to Excel and Word for Mac

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  13. Request of revival of gradient color feature on cells

    I'd like to use Excel as sketch of the knitting diagram of Hawaiian codes.
    Then, I could express silver colors at Excel ver. before 2016, but now I cannot.
    I cannot make difference between silver color and gray color.

    To express such shiny color; silver, gold, I hope that the feature will be availeble again.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  14. opentype

    Enable the "features" of an OpenType font. Especially the "Number Spacing" feature is really important to line up in tabular form

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  15. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  16. Add Rows to Repeat at Bottom, please.

    Rows to Repeat at Bottom to work as Rows to Repeat at Top, except at the bottom of each page.
    I'm sure there are those who would also appreciate "columns to Repeat on Right", & if the option existed, i'm sure I'd find a way to apply that as well.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  17. Fill color and text color on Touch Bar

    Both the fill color and text color on the Touch Bar are missing "Standard Colors" (red, yellow, etc.) Please add the Standard Colors to these buttons.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  18. Make toolbars in Mac same as in Windows , with colored Icons

    Make possible to see toolbars with colored Icons ,(same as in 2013 version) and same as in office for Windows 2016, and also put the option to place the toolbar bellow the ribbon.

    Added to above comment, There are many missing functions, that are not available in Excel for Mac

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  19. Comment box

    I really miss the ability to add a photo to a comment box. The updates that have been made to the comment boxes have ruined Excel for me. This one feature is THE most important reason for my use of Excel. I tried to just format a photo to fit in a cell and that doesn't work either. Come on guys, can't we do better than this?

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  20. conditional coloring for pivot cell excel for mac

    I compared the "Manage Rules" feature on Windows and Mac, I found that the difference is Windows has the "Apply Rule To", however, Mac doesn't have it.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base