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.
-
Right Click Problem
The current version of Excel for Mac (19120904) could not use right click to appear the format cells function and other functions such as insert/remove the cell/row/columns, which is not good for editing data
1 vote -
Add CTRL+J for Find function to Mac version
Add CTRL+J for Find function to Mac version
2 votes -
A real worksheet template
I create a lot of workbooks with a repetitive worksheet. For example, a workbook would contain multiple sheets representing a particular day for a project, with the workbook representing the project.
Each of these worksheets have exactly the same formulas and layout, so I create a 'template' worksheet in the workbook, which is then copied to create each of the worksheets.
If I want to change the template, I have to go through each of the copies to manually alter the formulas.
What would be cool is:
- Create a worksheet as a template
- Reference that template in copies (Copy from…
3 votes -
row shortcut
Add shortcut control + '+' to insert a new row (MacBook Pro keyboard without NumBlock)
(like control + '-' to delete the marked row)2 votes -
Toggle automatic formatting of dates.
The automatic formatting of numbers to dates is incredibly frustrating when you dont want it. I am often in a situation where I need to paste a table into Excel, for instance to calculate something from the table. It always happens that some cells in the table get autoformatted as dates and this is extremely annoying. The work-arounds are difficult and cumbersome and I can never remember what they are, so my workflow gets interrupted because I have to google how to do it.
I have very little use for the autoformatting of dates, but i appreciate that some people…
2 votes -
Allow fill handle and cell drag-and-drop
I don't understand why these two features are lumped together in one check box because they are totally different features. I like the fill handle, but not drag-and-drop. As a result, I have this option set to off by default so I don't accidentally drag cells, but then I have to turn it on every time I want to use the fill handle. Please make a separate button for each feature.
1 vote -
A cella védelem egyszerűsítése direkt módon. Illetve, ha jelszóval védem a munkalapot, akkor személyre szabható legyen az opciós lista.
Túl bonyolult a pozíciók védelme. Elsősorban a függvények védelme nem értelmes számomra. A jelszó védelem esetén megadott lista személyre szabhatóvá tétele. Nem tudom hogy, kell.
1 vote -
Find and Replace Support for Non-Printable Control Characters (Alt Codes/Unicode)
For example, searching for a printable character "x" and replacing with a linefeed <Alt>+000A, or carriage return <Alt>+000D.
The Find and Replace functionality in the Windows version of Excel supports this fine when replacing with <Alt>+0010.
2 votes -
microsoft excel 2016 v15.22 read-only cannot edit the .xlsb file.
Microsoft Excel 2016 v15.22 read only i cannot edit my system generated file.
all sheet are lock. but the windows all file can be open.
please help..!
1 vote -
Copy Format by taking (with mouse) the left corner of the cell
As well as you may copy the complete cell selecting the bottom-rigth corner, with this new feature you may be able to copy both; only the format or only the values (your choise on settings) by using the "upper left corner".
1 vote -
In the Replace dialog, CMD+A executes Replace All instead of selecting all the text in the current field
when replacing text, if I CMD+A to highlight all of the field, it instead executes the Replace All command...............
1 vote -
Add Find All to the Advanced Find dialog box with list view
When using the Advanced Search box, add the Find All button (similar to the Windows version). After selecting Find All, display a list view in the same dialog box.
1 vote -
Excel for Mac | Spell Check for different languages
Make spell check for Excel 2016 work with different languages.
Spell checker works in other Office Apps (Word, PowerPoint, OneNote, etc.) but not Excel as it only detects English language in Mac OS Mojave.
Coordinated with Mac Support for possible compatibility issue but they directed the case back to Office 365.
*tried all troubleshooting steps from this link but still not working
https://answers.microsoft.com/en-us/mac/forum/macoffice2016-macexcel/office-365-2016-mac-excel-spell-check-not-working/a04d5533-5ea5-4d7b-ba33-b044dd5a066e?page=37 votes -
Find & Select on Excel for Mac
In the Windows equivalent, there is a "Find & Select" drowp-down menu on the "Home" tab. One of the useful features of this menu is the "Select Objects" cursor which allows you to select multiple objects with the cursor rather than with the mouse one by one (which does get annoying of you have many screenshots attached to the sheet.
It would be incredibly useful to have his feature added to the Mac version of Excel!!!
2 votes -
Please add the data form for the entry of data
The data form does not exist in the macOS version of Office 2019.
Please add that userful function. Thanks.
7 votes -
Bug: comment rollover causes high cpu usage, lag when selecting cells.
Workaround: disable comment rollover. Either comments off, or fully on helps.
1 vote -
Bring back custom keyboard shortcuts
In this answer to "Bring back custom keyboard shortcuts" https://excel.uservoice.com/forums/304933-excel-for-mac?query=Bring%20back%20custom%20keyboard%20shortcuts the MS team states I can find the customization option under Tools > Customize Keyboard and links to this article to show how: https://support.office.com/en-us/article/create-a-custom-keyboard-shortcut-for-office-for-mac-6bbeb90e-96d9-4e03-b199-fc026ebdc321?ui=en-US&rs=en-US&ad=US
This is NOT the case. There is no option for Customize Keyboard in the Tools menu in Excel 2016 for MAC. You guys blew it when you removed the ability of a user to create a custom key combo to complete a command.
For example I always used the F1 key to delete cells and rows, which I do a lot. I used Option+click to add…
13 votes -
Remove "Copy of" to Save as in version 16.17
In Excel version 16.17, when you click on "Save as" it adds "Copy of" to the filename. In all previous versions, it never did this. Please remove the "Copy of" in the next release of Excel for MAC.
6 votes -
make a button for making lower case letters into uppercase letters
make a button for making lower case letters into uppercase letters
7 votes -
The Quick Access Toolbar
The Quick Access Tool bar on a Mac needs to be able to be moved below the Ribbon as on the Windows platform
2 votes
- Don't see your idea?