Feedback by UserVoice

Excel for Windows (Desktop Application)

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

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.

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.

• Hot ideas
• Top ideas
• New ideas
• My feedback
1. 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…

2 votes

We're glad you're here

Please sign in to leave feedback

Signed in as (Sign out)

We’ll send you updates on this idea

2. 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)

4 votes

We're glad you're here

Please sign in to leave feedback

Signed in as (Sign out)

We’ll send you updates on this idea

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

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

3 votes

We're glad you're here

Please sign in to leave feedback

Signed in as (Sign out)

We’ll send you updates on this idea

4. 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.

2 votes

We're glad you're here

Please sign in to leave feedback

Signed in as (Sign out)

We’ll send you updates on this idea

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

There are loads of bugs and omissions in Pivot Tables (maybe already solved in the latest version).

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…

3 votes

We're glad you're here

Please sign in to leave feedback

Signed in as (Sign out)

We’ll send you updates on this idea

6. 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.

3 votes

We're glad you're here

Please sign in to leave feedback

Signed in as (Sign out)

We’ll send you updates on this idea

7. 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.

3 votes

We're glad you're here

Please sign in to leave feedback

Signed in as (Sign out)

We’ll send you updates on this idea

8. 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.

2 votes

We're glad you're here

Please sign in to leave feedback

Signed in as (Sign out)

We’ll send you updates on this idea

9. I had excel on this machine when I had windows 8 - Microsoft offered to put windows 10 onit free and I accepted - however I now havent got E

I WANT THE EXCEL I PAID FOR WHEN I BOUGHT THE MACHINE AND WHICH HAS DISAPEARED WHEN MICRO SOFT INSTALLED 10 - REPLACING WINDOWS 8 - WHY IS THIS SO - I WANT MY EXCEL WHICH I PAID FOR BACK.

2 votes

We're glad you're here

Please sign in to leave feedback

Signed in as (Sign out)

We’ll send you updates on this idea

10. Allow excel files to be moved to second screen without having to open program twice.

I have two screens but if I want to display and work on two or more excel files on separate files then I need to open the program a number of times and then open the file within that open file. Word allows you to open and move any number of documents to a second screen, I don't understand why you can't do it in excel. Cheers. Matt

2 votes

We're glad you're here

Please sign in to leave feedback

Signed in as (Sign out)

We’ll send you updates on this idea

11. Lets users set exponential smoothing beta and alpha

In some fields, such as supply chain management, it helps for analysts to be able to set their own alpha and beta values when using the new exponential smoothing functions. I don't think it's necessary to build it into the Forecast Sheets.

2 votes

We're glad you're here

Please sign in to leave feedback

Signed in as (Sign out)

We’ll send you updates on this idea

12. Excel in Windows 10 requires 2 Alt-tabs to switch away from Excel

In Windows 10, Excel seems to require 2 Alt-tabs in order to switch away from the application whereas all other programs (including office programs like PPT or Word) only require 1. Can you figure out why this is happening?

2 votes

We're glad you're here

Please sign in to leave feedback

Signed in as (Sign out)

We’ll send you updates on this idea

3 votes

We're glad you're here

Please sign in to leave feedback

Signed in as (Sign out)

We’ll send you updates on this idea

2 votes

We're glad you're here

Please sign in to leave feedback

Signed in as (Sign out)

We’ll send you updates on this idea

15. Fix interface implementation bug on worksheets.

Excel compiles this code:

'
'Class IView (interface):
'
Option Explicit

Public Function SayHello() As String
End Function

'
'Microsoft Excel Object Worksheet1 (IView implementation)
'(Instancing: PublicNotCreatable)
'
Option Explicit

Implements IView

Private Function IView_SayHello() As String

IView_SayHello = Worksheet1.Cells(1, 1).Value

End Function

When saved (tested on every possible version of Excel) and opend again application crashes or corrupts workbook.

Can you fix this? That would open many new possibilites for developers, for example implementing MVP pattern.

2 votes

We're glad you're here

Please sign in to leave feedback

Signed in as (Sign out)

We’ll send you updates on this idea

16. Sheet list window/dialog is too small at just 289px*249px. Use a task pane instead.

In Excel 2010 the Sheet list window/dialog is just 289px*249px (and in Excel 2016 it is not much different). That's insanely small for today's monitors, and it results in not showing the full list of sheets in most of my workbooks.

I'd like to see this replaced by a task pane navigation that separates worksheets from chartsheets, allows sorting, maybe shows you a thumbnail, lists Headings inside each worksheet (which right now are of little use in Excel as compared to Word)... More in general, improve sheet navigation, which also has become much slower in Excel 2013+ in comparizon with…

2 votes

We're glad you're here

Please sign in to leave feedback

Signed in as (Sign out)

We’ll send you updates on this idea

17. Why not have the slider appear at the top of the embeded form so that it's not necessary to scrol it up to start reading.

Why not have the slider appear at the top of the embeded form so that it's not necessary to scroll up to start reading.

2 votes

We're glad you're here

Please sign in to leave feedback

Signed in as (Sign out)

We’ll send you updates on this idea

18. Want the Pen (electronic stylus on Surface Pro 4) in Excel to be able to make an "X"

Want to be able to tap the face of the touch screen on the SP4 in any particular cell and to have that tap enter a programmable character, like an X into the tapped cell. This has huge applications for a variety of Excel templates for various inspection situations for inventories, and other applications where Users have developed Excel templates for use on MS tablets for field use where you don't really want to be typing and just want to input an X in a predetermined blank. But this means that both Excel and the electronic pen need to be…

3 votes

We're glad you're here

Please sign in to leave feedback

Signed in as (Sign out)

We’ll send you updates on this idea

19. Preserve text colour when using Find/Replace

Currently using Find/Replace on a cell containing more than one text colour results in all the text becoming the same colour. This is not a desirable default.

3 votes

We're glad you're here

Please sign in to leave feedback

Signed in as (Sign out)

We’ll send you updates on this idea

20. Vertical text in the footer/header as in Word

Make it possible to add vertical text on the page margin in the footer/header. For example, to have the path and file name standing along the edge of the paper while printing.

2 votes

We're glad you're here

Please sign in to leave feedback

Signed in as (Sign out)

We’ll send you updates on this idea

• Don't see your idea?