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. conditional formatting help with rules that are incorrect of wrong

    as you can see I have error in my conditional formation but I don't know how to fix this I have some cell in the green but in the same row I have white field that I would like green

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  2. Allow users to change default number settings

    When switching from generic to number, it shows the number in full with two decimal places and no comma separations ie. 623453.00. Instead I would always like the 'number' format to show no decimal places and always use commas ie. 623,453. There should be more flexibility for the user to define the default conditions for number formatting.

    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  ·  Formatting  ·  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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  4. Data Validation List able to work with Array Constants

    Please make the Data Validation List feature work with array constants.
    Like to be able to define a named Array Constant and use that in a Validation List. After all they are both lists and the Data Validation list works with a classic Named Array.

    Requirement scenario is to share a workbook across organisations and ensure consistent data entry or option selection without VBA, as VBA is often stripped/blocked at organisational boundaries. This would be a very simple and straightforward solution improving user experience and organisational efficiency.

    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 →
  5. EXCEL for MAC version 16.35 has a conditional formatting bug

    Conditional formatting which uses named ranges in the condition, can't be copied between two workbooks. It can be copied only within one workbook.
    Identical conditional formatting that uses unnamed ranges can be copied between workbooks without a problem.
    This bug is in versions 16.35 and 16.37.

    PLEASE FIX!

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  6. Change comment background

    Bring back the ability to change fill background on comments (especially pictures)

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  7. Issue with custom date

    04 January 2010 with custom option == mm/dd/yyyy instead of dd/mm/yyyy

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  9. Visual confirmation of data entry by changing colour of the blank cell, AFTER data is entered,

    Visual Confirmation by changing the colour of the blank cells AFTER data is entered into it. Example, if my colleague is entering data in cell a2, b2, c2, forgets to enter data in d2, but enters data in e2. The intent is to show the cell d2 data was not entered.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  10. Fix Conditional Formatting

    When rows are inserted into a worksheet with conditional formatting, the cell (or range) references in the conditional formatting change. Fix the system so that the insertion of a row or column into an area covered by conditional formatting adopts the format (this part may already be the case) AND the formatting cell range reference in the Conditional Formatting dialog box does not get fragmented addresses; the range stays the same.

    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 →
  11. ip address

    Add IPv4 & IPv6 Address as a number format.
    I use Excel to quickly work with log files, firewall configurations and router ACLs that are 1000+ rows.
    Since an IP address is currently formatted as text 10.10.10.10 comes before 10.10.10.2 when you sort.
    Provide formula to quickly determine if an address is contained in a CIDR range, the CIDR range(s) for a selection of IP addresses, vlookup a host address in a table of CIDR ranges to, for example, find the VLAN that address is a part of.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  12. In Excel 16.36 on Mojave fix the way that cell borders are displayed and printed

    A few border styles display and print OK, but most diagonal styles are incorrect, too bold or invisible. One hatched style prints horizontal and verticals incorrectly too. See attached spreadsheet for details.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  13. The Acounting Double Line.

    Sometimes I feel that it would be useful to control the color of each half of this line as separate colors. (Example: top black, bottom red)

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  15. Touch-Bar on my MacBook Pro

    Is there a way to customize the Touch-Bar on my MacBook Pro to emulate the custom ribbon or customized toolbar?

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  16. touchbar

    I would like to easily highlight a cell with the touchbar but the color i most frequently use or even the "last" color used is not an option. I suggest you include whatever color is in the highlight/fill button be included in the touch bar.

    2 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 →
  17. Excel 16.33 for Mac has a bug the prevents the display of cells that have been formatted as "Currency"

    When selecting a cell and changing the format to "Currency," the cell vanishes. The value is still there, however is does not display to screen. When re-formatting back to "Number" the cell re-appears.

    2 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. 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.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  19. AutoFormating is Disabled in on Excell 2016 in MAC

    Hi Team,

    Since the upgrade of 2016 MS office in excel Autoformate feature is not available. Could you please tell me how to get it right.

    It is On MAC OS

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  20. AutoFormating is Disabled in on Excell 2016 in MAC

    Hi Team,

    Since the upgrade of 2016 MS office in excel Autoformate feature is not available. Could you please tell me how to get it right.

    It is On MAC OS

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base