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.
-
95 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:
1. Create a worksheet as a template
2. Reference that template in copies…2 votes -
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 -
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…
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 -
Paste Values
Bring back Paste as Values ribbon and keyboard shortcut. These are basic commands that shouldn't require multiple steps to get the required result.
Why do you remove key functionality when releasing new product versions, it's extremely frustrating.
3 votes -
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 -
The new comment threads, recently introduced in windows excel, are not compatible with the latest 2019/office 365 excel program.
Excel needs to be compatible between platforms. Unfortunately we are now experiencing data loss because of the approach Microsoft used to implement the threaded comments capability.
1 vote -
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.
6 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…
12 votes -
return the keyboard shortcut for paste values
there was a keyboard shortcut for paste value in Excel for mac 2011, its missing in Excel 2016
7 votes -
It seems that once an entry is made, it cannot be edited, except by complete replacement ?
It would be nice to be able to edit rather than replace a box
1 vote -
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.
5 votes -
copy and paste console
have a shorcut that labels what you have copied, and displays it on the console to the side of the workbook. like if you press command+shift+1(this would be the first thing you copied, and if you press copy again before pasting your last copy you would have to press command+shift+2 if you wanted to store it along with the previous copy.
1 vote -
make a button for making lower case letters into uppercase letters
make a button for making lower case letters into uppercase letters
6 votes -
ACTUALIZE EXCEL Y ESTA MUY LENTO, INDICA 4 SUBPROCESOS
Actualize Excel y esta muy lento, me indica 4 subprocesos.
1 vote -
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?