Feedback by UserVoice

# Excel for Mac

• Hot ideas
• Top ideas
• New ideas
• My feedback
1. ## Add more basic Quick Access Commands on Office 2016 for Mac: * , / , + , - , = thank you

Need Quick Access Commands for basic math:
Multiply: *
Divide: /
Subtract: -
Equal Sign: =

Your help to add these icon commands will be greatly appreciated. It will simplify my operations.

Thank You
Pino

Thank You

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

2. ## FIX CONDITIONAL FORMATTING

You have taken something simply and made it incredibly difficult to do. Typical Microsoft. Just copt a rule from one cell to another. Simple stuff, impossible to do in your product

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

3. ## It'd be great if all versions of Excel could use the IFS equation. I think it's only available on Office 365?

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

4. ## We need a "SORT" function to automatically sort rows or columns.

The syntax would be simple: =rowsort (array,column to be sorted,0 or 1).
Array: select the array of the desired sort
Column: the column number to be sorted
0 or 1: ascending or descending.

The "column" syntax entry could be further expanded to include the order of the columns to be sorted by; ie rowsort(A1:D19,{1,2,4},0) would indicate the array A1:D19 would be sorted ascending in the order of column 1, then 2, then 4.
issues: 1. if the first sorted column is entered first (for data entry) the whole row would instantly sort when "Enter" is selected unless one has set…

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

5. ## Interpolation function for Excel

When you have a number in cell A1, say it is "10" and then another number in cell J1 and it is "100" it would be great to have a function to do linear interpolation (lerp) between the two numbers without having to resort to long and complicated formula that is easy to get wrong.

Function LERP:
=LERP(startvaluecell, endvaluecell) for a simple useage
or
=LERP2(startvalue, rangefirstcell, endvalue, rangeendcell)

So using LERP and my example:
A1= "10" , B1=LERP(A1, J1), C1=LERP(A1,J1), D1=LERP(A1,J1),…I1=LEPR(A1, J1), J1="100"

SO USING LERP2 and my example
A1="10",…

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

6. ## AutoSum Shft+Alt+T Bug

Can you please fix the auto sum keyboard shortcut Alt+T to behave like that of Excel 2011 and the Windows Version? It seems like the behavior is broken in Excel 2016. It sums a column of numbers way to fast and doesn't let you see the selection and then press enter to except it. Also, when summing from the side of a column, it does a fast 1 cell sum. In order to make this keyboard shortcut behave correctly you need to hold down Shift+Alt+T until the selection is paused so you can then hit enter or make an expanded…

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

7. ## Ability to customize the Status Bar. Please. At least the ability to see "sum" and "count" at the same time.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

8. ## Bug associated with how ISNUMBER handles blank cells when used in SUMPRODUCT

With the help of a user who is using Excel 15.25 on a Mac, we discovered a difference between how ISNUMBER handles blank cells when used within the SUMPRODUCT formula. Or at least that is what we think is going on. I am using Excel 2016 on a PC. I have attached a test workbook, a screenshot of what I see when I open the workbook in Excel 2016 on a PC, and what the user see when he opens the same workbook in Excel 2016 on a Mac.

If A1 is a blank cell, then ISNUMBER(A1) returns FALSE.

So,…

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

9. ## Provide tools for working with names. Insert->Paste doesn't work. Define has no edit. What are we supposed to do - delete and redefine th

Provide tools for working with names. Insert->Paste doesn't work. Define has no edit. What are we supposed to do - delete and redefine the table or name? That's pretty lame. Define shows the range and has a definition box, but I can't do anything with it.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

10. ## Argument tooltips in Russian localization

No argument tooltips in Russian (and, maybe, another languages, I didn't check that) localization in Excel for Mac in versions above 15.29. Looks like temporary disabled and then forgotten feature.
I have to stay on 15.29 and ignore updates.
I appeciate if you pay attention for correction and respond here (it is awkward to check each release by installing->noresult->uninstallwholeoffice->returnbackto15.29).

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

11. ## "Break link" command causes Excel 2016 to crash

Serious Issue in Excel 2016
Copying a table of data or a figure from Excel 2016 to another work book retains the links to the source workbook as it should. However, there"Break Link" command causes Excel to crash. Please fix.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

12. ## "Paste as pdf" feature is not working properly

Excel 365 (2016) issue. This is a big problem for me.
I very frequently copy content from Excel to paste into reports and other documents in WORD. In earlier Excel versions, the most efficient and highest resolution method to do this is to highlight the cells/tables/graph or other content in Excel, copy it. and paste in Word as a pdf. In Excel 2016, Paste as PDF is still an option but the resulting paste does not retain the formatting of the original content, which defeats the purpose of pasting as a pdf. The only other option to get a high…

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

13. ## Autosum Keyboard Shortcut Bug

Can you please fix the autosum keyboard shortcut to behave like that of Excel 2011. It seems like the behavior is broken in Excel 2016. it sum a row at the bottom of a column way to fast and doesn't let you see the selection and press enter to except it. Also, when summing from the side it does a fast 1 cell sum but you need to hold down the key combination to get the selection cursor in order to make a larger column selection. Please fix. Thank you.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

14. ## Issue with tracing dependents

EXCEL 15.30. I know one can use the Precedent tool to see what cells are used in the formula of a particular cell but the tool requires finding, activating, and turning off, not to mention the really annoying and completely unnecessary new feature of the message box that tells you that there is no dependent or precedent, thus requiring another mouse click to remove the message. In all previous versions of Excel, simply double clicking in a cell would highlight cells that are dependents. OK, this happens in 15.30 as well but the highlights disappear as soon as one starts…

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

15. ## Excel for Mac won'ty shoe the sum, average, count, etc all at the same time, SO SAD AND UNHELPFUL!!!

Fix this, if Windows can do something so simple why can't Mac?!?

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

16. ## Use return key to change cells and retain copied information

Why doesn't using the return key in 2016 Mac to change cells retain a copied formula to paste? Now we are forced to use navigation arrows (or clicking - both much slower) as the only way to navigate to paste. I miss this function from earlier versions

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

17. ## Name Manager

Include it please ini Excel for Mac

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

18. ## Problème de syntaxe "DATEDIF"

Bonjour, j'utilise Excel sur PC iMac.
J'ai un problème, je souhaite utiliser la syntaxe DATEDIF, mais cette dernière n'apparait pas dans la bibliothèque des formules et lorsque je la rédige elle ne fonctionne pas.
J'ai été en relation avec un conseiller via LogMeRescue, qui n'est pas parvenu à résoudre mon problème.
Merci de bien vouloir m'apporter une solution.

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

19. ## HYLN stock symbol is not being recognized in excel stock function. Can we get that updated please.

1 vote
(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

20. ## A option to select in what language the user inputs formulas.

Example: for an PT-BR version of Excel, I want to input EN-US formulas.

1 vote