Excel for Mac
Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more
-
Return the Data Entry Form, Please
Not a new idea, just return the Data Entry Form. I feel Excel has put itself back in the prehistoric era, maybe just a few seconds after the Big Bang, by removing the Data Entry Form capability. Why did MS remove it? It was around for decades, great feature.
2 votes -
1 vote
-
remove duplicate easily
remove duplicates by filtering
1 vote -
Use spacebar to check/uncheck checkboxes in pivot tables
It would be really useful to be able to check/uncheck checkboxes in pivot tables without having to rely on the mouse i.e. using the spacebar
1 vote -
Dangerous sort function! Fix default to sort entire sheet!
An empty column during SORT just ruined my entire dataset!!! It sorted the data only to the left of the empty column! Fix this please! Who would want to sort only part of their dataset if they had pressed SORT without selecting a subset of columns!!!??? Illogical functionality is DANGEROUS!
1 vote -
Filter funktion for all rows (instead of the first 10 000)
Today in the Mac version (16.44) the filtering funktion only reads the first 10 000 rows and there is nothing that give you a hint that this is the fact. (Sort funktion seems to work for at least 70K+ though). Please make this work or att least make the system tell you that the answer is wrong otherwise this can create gigantic problems......
1 vote -
1 vote
-
Can the find bar retain the last search?
So I just upgraded from an older version of office that I was very familiar with.
Now every time I try command + F, I have re-type what I was searching for.
Is it possible for the last search item to show up in the find bar? Would be great if it's already highlighted, in-case need to search for new item then can type straight away and no need to hit delete.
Thank you
1 vote -
Database
Any table in Excel can be used as a database to select, extract and copy data to another location, for further use. Unfortunately the basics of it are not clear in Excel help, where discussions on PivotTables blurr everything.
First, define an Input Table containing all data, with column labels in top row.
Second, use Advanced Filter to define Criteria and Output range.
Criteria range must have two lines : one for column labels, one for sort values.
Ouput range needs one line only, with all chosen column labels in it. Selected data will display below it.Enjoy !
1 vote -
you could give me a valid phone number to a technician so that i get walked through this combersome proceedure ro install excel one time on
none, other than GTH
1 vote -
1 vote
-
Enable merging and splitting cells
I used to use this feature a lot on windows, now I have a MacBook I can no longer use it.
1 vote -
Templates: budgeting, YTD or custom date field review (not just monthly)
Data is great - now to set up a budget for 2021 and then have actual to budget by category.
In reviewing expenses: have customers date range and YTD -- also, on the snapshot, have the option look at more items.
1 vote -
Create an option to group together sheets in an excel by category
For example, a single excel for all teachers in a school could include sheets with schedules for each day of the week, responsibilities/guidelines/priorities, student directories by grade, etc. If I could group the sheets for schedules together, or student directories of all grades, that would help organize the space.
1 vote -
Create an option to group together sheets in an excel by category
For example, a single excel for all teachers in a school could include sheets with schedules for each day of the week, responsibilities/guidelines/priorities, student directories by grade, etc. If I could group the sheets for schedules together, or student directories of all grades, that would help organize the space.
1 vote -
In the excel filter menu show a light colored bar to show how many of that value there are in the column.
An underlay behind the fliter menu to show the count of each value in the filter menu for that column.
This will give users a good indication of the impact of that value. In a second phase, hovering over the value could give a tool tip with the count or make the count show up on the right hand side of the filter menu.1 vote -
Create a user tutorial for pivot tables.
Create step by step user tutorial for pivot tables.
1 vote -
Please provide a "Find All" command on Microsoft Excel MacOS version for the Find & Select function
Please provide the Find all button on the Mac version
2 votes -
Autofilter shortcut button for filtering by selected cell — already exists in Windows version
The Autofilter shortcut is an available button in the Windows version that you can bring into the Quick Access Toolbar or ribbon. Select a cell and click the Autofilter button -> the selection is then automatically filtered by the selected cell. Currently, we have to navigate a long-winded context menu path. This would be a real time saver for all those working with reams of data in tables.
1 vote -
Add possibility to copy/paste information from filtered cells
Wfhen applying a filter, it is currently not possible to copy and paste information without getting an error message
1 vote
- Don't see your idea?