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. Column and row numbers invisible when I use Mac Mojave "Dark" mode

    Column and row numbers invisible when I use Mac Mojave "Dark" mode.

    Excel v16.20
    macOs Mojave Version 10.14.2 (18C54)
    MacBook Pro (Retina, 13-inch, Mid 2014)

    Screenshot here: https://twitter.com/scottcale/status/1077891096439476226?s=19

    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  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
  2. Excel QueryTable does not work on Excel for Mac in Version 16.9.

    Excel QueryTable does not work on Excel for Mac in Version 16.9.
    See example from Microsoft here: https://msdn.microsoft.com/en-us/library/office/aa203721(v=office.11).aspx
    Section "Using a Static Web Query" describes a way to get data from a webserver.
    If you Change the used link from http://quote.money.cnn.com/quote/quote?symbols=msft
    to https://go.microsoft.com/fwlink/?linkid=859725
    the example loads a web table and displays it in a Excel worksheet.
    This example does not work on Mac with Excel Version 16.9. With Version 15.X on Excel the query executes successfully like on Windows.
    Here is the Code snippet for reproducing the bug:

    Sub RunWebQuery()
    With ActiveSheet.QueryTables.Add(Connection:= _

      &quot;URL;<a rel="nofollow noreferrer" href="https://go.microsoft.com/fwlink/?linkid=859725&quot;">https://go.microsoft.com/fwlink/?linkid=859725&quot;</a>, _
    
    Destination:=Range(&quot;a1&quot;))

    .BackgroundQuery…

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

    We’ll send you updates on this idea

    already supported  ·  13 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
  3. grid lines white

    The last update destroyed the grid lines. Automatic color for grid lines in active sheet is alway white. I have to change it to grey in every document!

    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  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →

    Hi Heinz,

    We didn’t make any changes to gridlines, so probably what happened is that they got inadvertently set to white on your machine. To change them to the default (for all new workbooks):

    1. Start Excel
    2. Go to Excel > Preferences > View > Show in workbook
    3. Make sure that “Gridlines” is checked, and that the drop down there is set to “Automatic”

    Hope that helps. In the future, a better pace for this type of question is the answers.microsoft.com site (you can post in the Mac Excel area)

    Cheers,
    Dan [MS]

  • Don't see your idea?

Feedback and Knowledge Base