I am using a spreadsheet that makes rocket science look simple. This workbook has hundreds of named cells, but unless I go look in the Name Manager I have no idea a cell is named.
It would be nice if up at the top you displayed the name 'Name: Calc1' or something.4 votes
A default start file can be saved to XLSTART as Book.xltx
There should be a button to allow people to do this more easily5 votes
Include these functions with same criteria management as SUMIFS and SUMIF2 votes
It will be extremely useful Tool for Filtering the Excel Data if it is possible to enter the Cell Reference to the Filter Search Bar
I find that it will be highly useful if there are dynamic Filtering facility in Excel. This will help to dynamically change the filtering criteria of a Table by changing the content of a particular Cell (manual change or calculation output). In order to do this, there needs to be a facility in Excel to link the Cell reference to the Filter search bar as shown in the attached screen shot.2 votes
It would be incredibly time saving to have the option to automatically format by font color a workbook, worksheet, or selection based on whether the cells are inputs (hardcodes), references within the tab, references to another tab or another workbook. The functionality would be very practical if the option to add/edit the default colors for this auto-formatting action existed.2 votes
Current grouping by day is in fact by "day of year". When dealing with date-time values, it is useful to throw away the time data in a pivot table. The grouping does some of this, but it also throws away the year data as well.
In other words, I want to be able to aggregate "1/1/2017 10:00" and "1/1/2017 11:00" as "1/1/2017" and not "Jan-01"2 votes
Please create automatic handling of Divide by Zero errors, so that users don't need to create IF functions around the majority of formulas. For example the user could select what result is applied across the entire workbook when a DIV0 errors occurs. Commonly I use an IF function to set the result back to Zero again such as:
The 'Insert' row or columns option in keyboard shortcuts is not working. Till now it was working fine. I need help on this please.
I have purchased Office 2016 Student and Home edition from Microsoft store on 4 Apr 17. The 'Insert' option for row or column with keyboard shortcuts is not working. Till now it was working fine. I need help urgently for this error please.2 votes
Chord diagrams show the relationship between a group of items/points/people. It would be fantastic to have a default option for this kind of chart instead of messing around with work-arounds.2 votes
In the prior version of Excel, if you wanted to add or remove a row or column that was part of a merged cell you were able to easily delete the row or column in question without deleting the entire merged cell.3 votes
Excel 2013 (15.0.4927.1000), Windows10 Hebrew/English
Regardless of the current chosen language, Hebrew or English, the caret points from right to left.
This is very confusing.
See attached screenshot.3 votes
The PROPER, LOWER and UPPER functions are optimal, but please include the same possibilities in cell formatting3 votes
Utility to backup all user's customizations. I have a batch file to backup all my settings below but I'm not sure if I have them all.
Custom Lists must be exported from registry and imported. Most users won't know how to export from the registry and they shouldn't attempt it either.
It would be nice to have a utility that backups all user's customizations/settings.
Hi! I would like, if possible, to request a direct contact with one of the people of the development team of Microsoft Excel to explain an error that I found in the programming of an Excel formula.
This error generates results that are not real mathematically, nor logically.
I await a response and contact.
Dear Excel Team,
When working with millions of data rows power pivot is definitely the right tool.
However, all my research came up with the same result that changing a calculated column in power pivot using VBA is not possible.
Here an example where we would like to change a calc. column via VBA. We need to alter many different settings (based on several input columns) in order to find the optimal operating point.
It would be wonderful if this could be considered.2 votes
From within Office, you can share a doc with someone new, but not email anyone who already has access (for example, if you want to notify them that you updated the doc). I want to be able to email collaborators without having to manually open an email message in Outlook, find the sharing link on SharePoint, and lookup the emails of everyone who has access to the doc.3 votes
There should be an option to close out of error messages. When one comes up, there are OK, Cancel, and X buttons. Clicking any of them will open the same message again. The only way to get out of it is to press CTRL+ALT+DEL and close Excel through the task manager.3 votes
When a spreadsheet is opened from email or the web, it is automatically put into "Protected View" where little can be done with it. I need to use the data, but I want to be safe from malicious macros. It would be nice if there was an option to remove all macros from the spreadsheet allowing me to access it safely.2 votes
Even though I have sharepoint locations set up as a Trusted Locations, Excel will not default to opening those files in Edit mode. I have all of my frequent files pinned, and they all default to read-only mode when I open them. This means many many extra clicks every day as virtually everything I work on is located on sharepoint.4 votes
- Don't see your idea?