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. Make Formulas EASIER TO READ with Visual Links!

    When I double click a cell, and get a formula, ex) =M1+M2, If my CURSOR HOVERS over any one of the boxes referenced for a split second or longer, the reference in question should appear visually as a COLOURED LINE CONNECTING THE BOX BEING EDITED TO THE BOX BEING REFERENCED.

    So if I'm like, Hmmm which box is M2? And I don't want to go through the labourious process of finding M2 in a forest of cells, the cell I'm editing will magically have a line in the same colour as the M2 reference within the cell appear, which connects…

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

    We’ll send you updates on this idea

    1 comment  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    This is already supported. When you have a cell that contains a formula, you can click on the cell, then on the Formulas Ribbon, click “Trace Precedents” or “Trace Dependents.”

    Excel will draw arrows for you to the cells that contribute to the cell value, or that it affects, depending on which button you click

    Hope that helps,
    Dan [MS]

  2. Command, Shift, Arrow Keys to Select Any Cells

    I am having issues selecting and highlighting blank cells in a workbook. There is a new feature I believe where if I start to select the data the Cmd + Shift + Arrows works properly and has a bit of an auto stop, so it recognizes where the data ends, however, if I want to select any blank cells beyond that data, it will not move. I have to hand select these cells and use the scroll. There are times where I want to remove formatting in the blank area that has been applied to the blank cells until the…

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

    We’ll send you updates on this idea

    4 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →

    Hi Julie,

    To select empty cells, you just want to hold down the shift key as you press arrows. The ctrl key will jump to the next cell with data (or the end of the row/column if there’s no more data there)

    Hope that helps. If you’ve got more questions in this space, head on over to the Excel forum at http://answers.microsoft.com where there are experts to help.

    Cheers,
    Dan [MS]

  • Don't see your idea?

Feedback and Knowledge Base