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.
-
I have a problem for office excel 365 for Mac air
I have been using office 365 home edition with my MacBook Pro and now I recently bought MacBook Air and set my office account to sync with this new Mac air. I have been saving my excel files on OneDrive. When I open an excel file, the column width and the print page setups, all was mixed. I checked the same file on macbook pro it was ok. I have copied all the excel preferences from MacBook Pro but still having the same problem. Does anyone experience this thing before or any clue to solve my problem.
thank you in…1 vote -
sheet tabs
Allow user to specify location of sheet tabs (top, bottom, left, right)
3 votes -
alt key for Excel in Windows shows the labels for the shortcuts found in the ribbon. Excel for Mac doesnt have this. Need it desperately
alt key for Excel in Windows shows the labels for the shortcuts found in the ribbon. Excel for Mac doesn't have this. Need it desperately
1 vote -
office 365
Make power query and power pivot available for excel macOS.
1 vote -
Excel 16.33 for Mac has a bug the prevents the display of cells that have been formatted as "Currency"
When selecting a cell and changing the format to "Currency," the cell vanishes. The value is still there, however is does not display to screen. When re-formatting back to "Number" the cell re-appears.
1 vote -
1 vote
-
Typing words disappear from the screen
In the Mac new version 16.33 (19122502)
When I try to type some words such as £/€, the word disappears from the screen and only when clicked could it be seen from the screen, and it appears quite strange1 vote -
Importing web page into worksheet
I used office 365 personal subscription. I need to import any tables on web page into my worksheet. But I have tried many times to do that, and contacted to support as well. They said this feature is not available on Mac.
1 vote -
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 -
Allow Keyboard Shortcuts in VBE
The visual basic for applications editor for the Mac does not have the ability to edit keyboard shortcuts. The most common editing shortcut used is to step through code while debugging. In windows VBE this is F8, and those of us who are familiar with the windows version would like to have the same experience on the Mac. The current keyboard shortcut requires two hands and makes it very awkward to step through and debug your code.
According to Madoc Huang MSFT in the Microsoft community forum, I should post this here because this feature is not available on the…
2 votes -
Data "Form" for excel users on Mac computers
I really miss having Data "Form" available for excel users on MAC computers. Is there any chance this can be reinstalled. I use it all the time with my spreadsheets.
3 votes -
AutoFilter Spacebar Selector
Like in Windows, it would be much faster to use keyboard shortcuts for things like selecting items in the AutoFilter list (i.e. using the space bar). As of today, you cannot highlight and select different items in the filter list without the mouse. Also annoying, is the fact that selections are applied instantly, causing nonsense CPU work and worse yet the window shifts in view as calculations are running. Messy.
2 votes -
Please update excel to open files in Catalina OSX, all other 365 programs working
Please update excel to open files in Catalina OSX, all other 365 programs working.
Excel will open but will not open an excel file2 votes -
Add icons to charting bling to make better charts like in Windows
It is nice in a column chart to see meaningful pictures instead of boring bars. Mac only allows you to import an image. Windows supplies a library of icons making it easier and more robust.
3 votes -
Bring VBA on Excel for Mac to parity with Excel for Windows
Bring VBA on Excel for Mac to parity with Excel for Windows.
Currently, there are too many missing VBA elements missing. It is a major problem for those of us with mixed environments. Many things that worked under Excel 2011 no longer work in 2016.Why is the not being addressed?
99 votes -
Support Internet Query Connection (.iqy files)
It would be helpful for Excel to Mac to support internet query connections.
When exporting a list from Sharepoint, the .iqy file is downloaded, which I subsequently can't open in Excel for Mac.
54 votes -
Enable (or re-enable?) pivot table drill down
We're being asked to look into why Mac users can no longer double click into a pivot table to bring up a new tab with the relevant records attached. I've now had this from at least 2 people saying it used to work but a recent update (at least a month ago) has stopped it. I wasn't aware of this before it was reported so I don't know if it used to work or not. It's how our managers get their management accounts and so this is quite important. We're having to work around it with remote desktop services but…
1 vote -
Fix Conditional Formatting
When rows are inserted into a worksheet with conditional formatting, the cell (or range) references in the conditional formatting change. Fix the system so that the insertion of a row or column into an area covered by conditional formatting adopts the format (this part may already be the case) AND the formatting cell range reference in the Conditional Formatting dialog box does not get fragmented addresses; the range stays the same.
2 votes -
PowerQuery data refresh from SharePoint Online CSV file
The latest Excel for Mac (v 16.29 and later) can refresh from Text, CSV, XLSX, XML and JSON files, but not when those files are on SharePoint Online (or other cloud storage locations). Please add this functionality, as we are moving to SPO and away from file servers. I know I can refresh from a local copy (via OneDrive sync client), but each person's local file path may be different, so a shared Excel file won't update correctly for each person.
1 vote -
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
- Don't see your idea?