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.
-
Changes to VLOOKUP/HLOOKUP
I suggest 2 changes in Vlookup/Hlookup:
A. VLOOKUP/HLOOKUP functions user can only search for the lookup value in the first column/row, and the result column/row is always after (right/bleow) the lookup column/row.
I suggest to make it more flexible by letting the user decide which column to search in and which columns to retrieve the value from.B. Sometimes user need to drag lookup function to several columns and needs the column index to be incremented, for example to be 3 in the first column, the second column to be 4 and so on, I suggest to add new parameter…
29 votes -
Make Microsoft Excel for Mac EXACTLY THE SAME as Microsoft Excel for PC.
If Mac subscribers of Office 365 are getting less features and PC subscribers, prorate the Mac annual subscription accordingly. If not, MAKE BOTH VERSIONS OF EXCEL HAVE THE SAME MENU FEATURES!
20 votes -
Name Manager
Include it please ini Excel for Mac
3 votes -
Need a way to turn off a recurring disclaimer after it presents itself a few times
I've started using the Stocks data types and now all workbooks that have them get the disclaimer banner on each sheet every time I open it up. After seeing it a few times, the user needs to have a way to turn it off. Otherwise , it just an annoyance. Thank you.
16 votes -
In Excel for Mac, fix the issue that the characters on the formula bar get corrupted when pasting a folder name in a cell
Copying a folder name and pasting it in a cell may not be a common operation, but sometimes we do so.
Therefore, it would be great if you could fix the issue that the characters on the formula bar get corrupted in the operation above.
This issue has not been fixed for a long time and is always reproducible.8 votes -
Alt shortcuts for the Mac pls
Please provide Alt key equivalent shortcuts for the Mac
5 votes -
2 votes
-
Change the vlookup formula to have a default value if the formula returns an error
I have to wrap my vlookups in an IF statement to check for the result being ISNA. Would be amazingly helpfuly if it could take another input patameter to default on any error condition (e.g. 0 or space are ones that I would use most often).
1 vote -
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 validationRequested Solution
Allowing user to use the dynamic arrays formula in the data validation directly instead of using the helper column.17 votes -
enable "Relationships" or "OLAP Tools" buttons in Excel Mac
enable "Relationships" or "OLAP Tools" buttons in Excel Mac
1 vote -
Need to be able to step through formulas and functions in Excel.
It would be nice for the mac version to have the same features as the windows version. Especially when I have to switch between OSes.
1 vote -
existe versión de Power Pivot, Map, View compatible con la MAC?
Solicito una versión de Power Pivot compatible con la MAC ya que a pesar de tener la ultima versión 365 de Microsoft no me permite instalar
1 vote -
duration
if you use negative rates in the DURATION o MDURATION function you don't get anythins #NUM, what shall we do ? thks in advance.
1 vote -
1 vote
-
1 vote
-
Add Sort Argument in STOCKHISTORY
I simply would like to sort the data from newest date to the oldest date.
1 vote -
lambda function naming
why can't you use =lambda('myfunc', [param1,...,param253], calculation) instead of that horrible name manager...it breaks the flow of programming, negating the potential of an otherwise brilliant feature
1 vote -
Enable Hyperlink to Open Local Files
I'm using 16.44 and trying to use the Hyperlink Function to open my local files. For each file I try to open, I get an Excel Warning message "Some files can contain viruses or otherwise be harmful to your computer" which I must approve with an OK click; Every time and every file. I opened a case with tech support: Case #:1015178416 and was told that feature was not enabled for the MAC version, although it is enabled for Windows
1 vote -
Adding individual cells without having to shift and plus for each cell
In the past versions of Excel we were able to add individual cells by using the equal sign followed by just going to the individual cells WITHOUT having to go to shift and the plus sign each time. This was far more convenient.
1 vote -
Adding individual cells without having to shift and plus for each cell
In the past versions of Excel we were able to add individual cells by using the equal sign followed by just going to the individual cells WITHOUT having to go to shift and the plus sign each time. This was far more convenient.
1 vote
- Don't see your idea?