Feedback by UserVoice

# Excel for Windows (Desktop Application)

Welcome to the Excel for Windows (Desktop Application) feedback forum! This is the place for users to send us suggestions and ideas on how to improve. If you think you have found a bug, please send us feedback in-app instead! To do so, please click “File”, then “Feedback”, then “Send a Frown” in Excel. This way, we will get detailed information that will help us better diagnose the problem.

• Hot ideas
• Top ideas
• New ideas
• My feedback
1. ## Anti-aliasing on diagonal borders

Diagonal borders are common to X out a cell. The problem is that you can see the jaggedness as the borders' edges step through each row and column of pixels. Most other visuals in Excel are smoothed out.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

2. ## Grouping in Power Pivot reports

To be able to use Grouping in Power Pivot reports as is works in Pivottabels.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

3. ## Suggest formula simplifications to the user

For those without a strong Excel, math, and/or computer science background, formulas can be much more complicated than they need to be. To help them along, Excel could suggest simplifications to commonly used simplifiable expressions. It would be like a spell checker, but for logic.

Here are some simplifications that I've done over the years:
IF(A1=1,"",IF(A1<>1,"s","error")) has an unreachable part "error" and becomes IF(A1=1,"","s").
NOT(A1<B1) becomes A1>=B1.
IF(A1<0,0,A1) becomes MAX(A1,0).
DATE(YEAR(A1),MONTH(A1)+1,1) becomes EDATE(A1,1).
SUMIFS(,,"="&A1) becomes SUMIFS(,,A1).
(A1B1)+C1 becomes A1B1+C1.
...
and so on.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

4. ## vlookup should treat the lookup value as it APPEARS

If you VLOOKUP (or HLOOKUP) 123 (or a range containing 123) into a range which clearly has 123 in it, but the latter is formatted as text, it doesn't find it. If it LOOKS right, it should find it!

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

5. ## Really badly need "Total Editing Time" as a property.

It would be very helpful if Excel could record the total editing time spent working on a spreadsheet. Or if Excel could better still, automatically log each time period spent editing a spreadsheet. Helps when billing customers and giving volunteer hours as I do a lot with Excel.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

6. ## Fix filter annoyances

1) Bug: when panes are frozen, in the moment when filter is applied the sheet is being violently scrolled horizontally in a random direction, hiding the active column.
Please do not scroll on filter application.

2) Missing functionality: The filter popup list can be re-sized to show more or wider items. Unfortunately the size of the popup is not remembered on the next pop.

Many thanks!

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

7. ## Go to Pivot table name

If I give an Excel-table a name, then I can use the Go-To function to find it. Why can’t I find named Pivot tables in the same list?

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

8. ## Pivot Table Calculated Item

It is observed that the pivot "calculated item" feature has two serious drawbacks:
(1) The calculation takes a long, long time compared to "calculated field" feature.
(2) The calculated numbers generated via "calculated item" on the pivot table can be altered or defaced which does not happen when "calculated field" feature is used.
The above drawbacks render the use of "calculated item" in pivots unusable. Can we address these?

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

9. ## Allow Edit of the Macro Button

Allow users to edit the Macro Button (like we could in an older version of Excel) for custom macros in the Quick Access Toolbar. Currently, we can select from ~180 images but it was so much nicer when you could go in and 'draw' your own button.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

10. ## Excel: Achsenbeschriftung bei logarithmischer Skalierung (German)

Excel: Achsenbeschriftung bei logarithmischer Skalierung

Logarithmische Aachen lassen sich im X-Y-Diagramm von Excel 2010 und 2013 durch die Eingabe eines festen Minimum und Maximumwertes unter den Achsenoptionen frei skalieren. Die Festlegung eines Haupt- oder Hilfsintervalls bleibt ohne Wirkung, da Ziffern an logarithmisch skalierten Aachen (zur Basis 10) nur an den Hauptgitternetzlinien in Dekaden (1; 10; 100; …) angezeigt werden (Bild 1).

Die Darstellung von Ziffern an den Achsen innerhalb einer Dekade (z.B. X = 200; 300; 400; 500; 600) gelingt nicht. Liegen z.B. Messwerte bei X = 200; 300; 400; 500; 600 vor und wird die Skalierung der X-Achse entsprechend…

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

11. ## Microsoft keyboard shortcuts for in-cell alignment.

Other Microsoft products allow keyboard shortcuts to align text. Please add these to Excel: Ctrl-E to center a cell's contents, Ctrl-R for right alignment, Ctrl-L for left alignment.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

12. ## Do we need 15 decimal places?

Who needs 15 decimal places? The IEEE round off error were users get, say, 12.3 × E-15 when they expect zero just confuses then and undermines their confidence in Excel and in themselves.

I cannot see any one in the finance world needing 15 decimal places.

Few, if any, engineers/scientist work with that sort of precision. Look up physical constants and you will find they are generally known to only 9 significant figures: Planck constant h = 6.626 070 040(81) × 10−34, were (81) is the std dev in the last two decimal places. Albeit some work with atomic masses…

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

13. ## Change default calculation for pivot table items

When I drag new items into the values section of a pivot table, they always default to the 'Count' calculation. In my work, it's almost always 'Average' that I want though, and I'm left dragging a bunch of items in and changing them one by one in the dropdown. Annoying.

So, I'd ask you to consider adding one or both of the following options:
1. Change the default calculation for newly added items
2. Allow changing of calculation for multiple items at once (this would be particularly good if it let me change all the options for multiple items together)

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

14. ## Function to only use every xth-row or column in another function

Function to only use every xth-row or column in another function

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

15. ## Add a Switch Reference button to Ribbon

Many know the F4 is used with authoring a function. However it needs to be memorized. please create a button on the ribbon to switch between types of referencing.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

16. ## Please fix the bugs in pivot tables! (I am only using XL2010 so far).

1. If the data source range is updated to zero records (ie only the one row of column titles), Excel gives a useless error message and then displays the previous dataset's results instead of an empty pivot! Not only is this a potential security risk in a multiple user situation, but it means that all pivot table code has to be surrounded by workround code to add a null record to the range so that it doesn't fail.

2. If you double-click on a pivot…

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

17. ## Add an IN() function to check for existence of a value

Right now, I often use formulas like this:

``````=IF(COUNTIF(&quot;A&quot;, myRange)&gt;0, ..., ...)
``````

It's be handy to be able to just use:

``````=IF(IN(&quot;A&quot;, myRange), ..., ...)
``````

This could also help with formulas where a number of different criteria are allowed:

``````=SUMIFS(B:B, A:A, &quot;2016&quot;) + SUMIFS(B:B, A:A, &quot;2013&quot;) + SUMIFS(B:B, A:A, &quot;2010&quot;)
``````

becomes

``````=SUMIFS(B:B, A:A, IN(A2, &quot;2016&quot;, &quot;2013&quot;, &quot;2010&quot;))
``````

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

18. ## creating Layout of directory in excelsheet directly from your local hard drive

if it was possible that just with one click, we can create a Tree Grid Map of directory, which will give option of inducing sub folders & files with option of inserting hyperlink.

So that i don't have to open 7-8 sub folders before opening my files.

(nothing against VBA, its a great tool) if i create a directory using VBA it is not very beautiful..... i wish i could see small folders with little Expansion buttons it would be very great.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

19. ## Pin newly opened files to visual area (or just the upper left hand corner)

I open my excel to cross over multiple screens, but when i open a file its a crap shoot as to where it appears across the screens. I know the file is open as I can see it in the list of open files but beats me where it is. I have to go to "View/Arrange All" and then vertical to be able to find the file. But doing that moves all my other files that I have placed in my work area for a reason.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

20. ## Save As Cell Contents, instead of the default "Book1.xlsx"

Often I have typed a heading in a workbook, and then had to re-type the same or nearly the same information when saving the workbook. MS Word has an intelligent guess at the Save As option by using the first words in the document, but Excel just offers Book1.xlsx. What if we could have Save, Save As, and Save As Cell Contents? In other words, select your chosen cell, click on Save As Cell Contents, and you have your desired file name with no duplication of effort.