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. Formula Evaluation (Auditing) doesn't exist for Mac?

    I know, I know...Mac Users are different, but it doesn't mean they can't benefit from clear insights to their Formulas.

    Alt+T, U, F in Excel for Windows gives a step-through window for evaluating a given formula. This isn't an option on Excel for Mac. Is there any work being done to enable it? Just wondering also why such basic functions for maintaining workbooks wouldn't be available across platforms.

    Looking forward to hearing back.

    Thanks.

    BPC.

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

    We’ll send you updates on this idea

    4 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  2. Data Validation to hold New dynamic Arrays function in Validation list

    Current Scenario
    While using the dynamic arrays formula in data validation list is not returning the arrays values, we need when enter the dynamic arrays formula in a column then call the arrays using # in data validation

    Requested Solution
    Allowing user to use the dynamic arrays formula in the data validation directly instead of using the helper column.

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  3. Have UNIQUE() optionally ignore blanks

    The new UNIQUE(), SORT() and SORTBY() functions are incredibly useful and they save a lot of time. It would be helpful though to allow UNIQUE() to optionally ignore blanks. I use UNIQUE() to build named arrays dynamically which I can use as a validation list for data validation. At the moment I have to create the list (e.g. SORT(UNIQUE(<some column in a table>)) and then created a Name using OFFSET() to ignore the blank at the start of the sorted list.

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

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  4. improve the filter function in excel for Mac - make it work the same as with excel for PC

    improve the filter function in excel for Mac - make it work the same as with excel for PC

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

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  5. 全環境、全バージョン、配列数式の 引数引き渡し

    配列数式を 組む際に、
     ・セル間配列数式値の 受け渡し、
     ・ネスト間配列数式値の 受け渡し、
    此等において、

    ご存じの通り、
    阻害条項が 横たわっており、

    連れて、
    名前定義を 介したり、
    INDEX構文を 持ちいたり、
    等、

    阻害への 特殊な、
    対応が 求められます。

    又、

    OFFSET構文等の、
    索引関数の 結果を、
    上位ネスト関数に 引き渡す際にも、

    かなり 以前から、
    不具合が 見られるように、
    なっていますし、

    他にも 有る、
    可能性も 横たわっています。

    一方、

    もし 此等を、
    VBAで なそうと、
    する場合、

    ループ等での 対応が、
    一般的です。

    ですが、

    此では オブジェクトタッチ数が、
    飛躍的に 増え、

    連れて、
    必要処理時間が 飛躍的に、
    増加するだけでなく、

    プリセット機能である シート関数の、
    有用性を 殺し、

    併せれば、
    Excel 其の物の、
    価値を、能力を、
    毀損しています。

    Excelの、

    持てる 能力の、
    全てを 毀損させず、
    余す事なく 発揮させるためにも、

    配列数式への 改善を、
    図っては 如何でしょうか、

    ご検討を 願います。

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  7. translation function

    It would be a great time saver if there was a translation function that worked like a reference function. Especially if you work internationally and have to enter 2 languages in e.g. a list to make it easier to understand, this function would be very practical, because you would have to enter it once and then you could transfer it to the other cells.
    For example: column A is German and column B should contain the corresponding English translations. Instead of having to translate everything manually, a function would be simpler here, which would transfer the following information: If A1…

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  8. Please improve the ASC and JIS functions

    Please improve the ASC and JIS functions so that:
    they can apply to:
    - only romajis,
    - only katakanas,
    - both of them
    For instance, this could be like:
    - ASC(Text,-1) / JIS(Text, -1) would apply only to romajis
    - ASC(Text,1) / JIS(Text,1) would apply to katakanas only
    - ASC(Text,0) / ASC(Text) / JIS(Text,0) / JIS(Text) would apply to both, just as the present versions.

    This would be very helpful for a variety of usages.
    The main usage would be to force romajis to single-byte while forcing kanas to double-byte.
    In fact, in many cases, ones would prefer transform only…

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  9. Please improve ASC and JIS functions

    Please improve the ASC and JIS functions to that:
    they can apply to:
    - only romajis,
    - only katakanas,
    - both of them
    For instance, this could be like:
    - ASC(Text,-1) / JIS(Text, -1) would apply only to romajis
    - ASC(Text,1) / JIS(Text,1) would apply to katakanas only
    - ASC(Text,0) / ASC(Text) / JIS(Text,0) / JIS(Text) would apply to both, just as the present versions.

    This would be very helpful for a variety of usages.
    The main usage would be to force romajis to single-byte while forcing kanas to double-byte.
    In fact, in many cases, ones would prefer transform only…

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  10. Reinstate ability to use the TAB or RETURN key to finish a formula and move to next over or down cell

    I'm on a Mac OS10.14.6 using Excel v16.34. Neither the Enter nor Return nor Tab key will auto-select the Done button to finalize a created formula and then bring me to the next cell over or down.

    I've hesitated to move from Excel 2011 because I'm able to, for instance, put my cursor in a cell, double-click SUM in the function dialog box (which I keep open in the window), drag/select the range of cells I want to add, then hit the Tab button to finalize the formula and move me to the cell to the right, to then use…

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  11. Select only visible cell as COMMAND+Shift+8

    On older versions of Mac Excel the key combination of COMMAND+SHIFT+8 would select only visible cells. Now (v.13.64) it does not. You need to press OPTIONS+;
    Please re-add this function back

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  12. When editing in cell, please re-add COMMAND+A as a select all option

    On older version of Excel, when you were editing a formula in a cell, if you pressed COMMAND+A, all the text would be selected. Now, the same combination of keys does nothing.
    Please re-add this function!

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  13. md5 hash function

    Please implement the MD5 hash function

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  14. Simplify SUBTOTAL

    Simplify SUBTOTAL function by eliminating codes: use the underlying functions instead. Use TRUE or FALSE to include hidden rows.

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  15. Find

    Why after so many years of people requesting that Find All button be added to the Find dialog box in Mac Excel version it's still not there? How difficult is it just to add a button?

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

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  16. Combine Arrays Function: COMBINE(Array1, Array2 , ...)

    A functions to combine arrays and return a single array. For example, I have a spreadsheet that contains a list of schools and a list of theatres. Some schools also have theatres, so I would like to combine a subset of the schools with the theatres to produce an array of venues that then be used as a validation list. Currently I use the new FILTER() and SORT() functions to create 2 arrays and then use an awkward and complex array function with helper functions (based on MID()) to combine them. Would be great if I could just e.g. SORT(COMBINE(A3#,B3#))

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  18. Temporary variables in formulas

    It would be amazing if you could implement a function that allows you to set a temporary variable to use within a formula! Something like the syntax used in OpenRefine's "with()" control (borrowing their syntax for my example - link to their wiki below).

    Syntax:
    WITH( [Function A], [Variable Name: string], [Function B] )

    [Function A] would get evaluated first, and then the result could be referenced within [Function B] using the [Variable Name] string (essentially as if it was a named range). With this you can reuse a value in a formula multiple times without needing to repeat the…

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  19. Sheet numbers change as you drag the formulae down

    Can there please be the ability to drag the below function down the column and the sheet number changes automatically only. The '$' sign fixes the cell but I need the ability for the sheet number to change automatically in numerical order as I have over 200 rows and 25 columns to change manually!!

    ='18'!$B$3

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  20. A function to populate another cell

    A function to populate another cell. Something like;

    IF(a1<>0,LET a5=a1,LETa5="") as a function in any cell other than a1 or a5

    This populates a5 if the condition is met but enables a value to be typed into a5 without overwriting a formula.

    As far as I know, this can only be done today with VBA. This would be so useful to me.

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5
  • Don't see your idea?

Feedback and Knowledge Base