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. ## Find the smallest value other than zero

Sometimes my question is the search for the smallest value, except for zero

The function min or small

But fail to it because it will come in short, a smallest value of zero

And we are forced to do the work of an array formula, such as in the
{min(if(A2:A10<>0)*(A2:A10<>""),A2:A10,"")}

And the following suggestion

Argument optional functions

max min av

small large

To neglected zero.

It will be a very, very useful

Greetings to you

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

2. ## Issues with structured references in single-row tables

Often, I will set up formulas for a table before the raw data is available. During this time, the table has a single, initially empty non-heading row. If I want the year of the Date column, I type =YEAR( and click on the Date cell in the same row as my formula. I end up with =YEAR([Date]) instead of =YEAR([@Date]).

Excel recognized that I selected what happens to be the entire column, and so gave me the whole-column reference [Date]. Excel should look at how the selection was made rather than what was selected.

Excel should instead behave like this:…

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

3. ## I would like to be able to change the color of the highlighted cell so it is easier to see,

When I have different colors in my spreadsheet it is sometimes difficult to see which cell I am in if I have to switch to monitor 2 and then go back to monitor one. It would be nice to have a function to change the colors of the cell that I am working in so it is easier to find.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

4. ## increase character limit on choice options in Excel Survey

When providing the options for an Choice question in an Excel Survey I found out that there is a character limit to the input box where you provide the options. Seems like this limit is around 1000 characters, which is far too little for providing full overviews of countries, products, models and many more categories that many companies have in their datasets and would like to incorporate in surveys.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

5. ## When using pivots based on data models, create "combined" drill through sheets by double clicking on pivot grand totals

Based on all existing Relationships in the data model, The "combined" drill through sheet should show all columns from all sources where a relationship exists.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

6. ## Better default format for a time from a csv file

This is relating to opening CSV files with fields formatted like 12:34:56.789

My Excel sets them to custom format mm:ss.0, which is rarely a useful form to work with the value. I'd prefer if they stayed as text or were a time in HH:MM:SS.000 format.

Sorry for duplicate suggestion of https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/15958735-i-think-the-default-way-to-format-a-time-should-be; I wasn't sure if my comment was seen.
Currently my system short time format is h:mm tt and long time format h:mm:ss tt.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

7. ## Data Graphics that will Display Excel Data

It would be super great to have the ability to insert a shape that will display data from the spreadsheet. I find myself using labels in charts and adding formulas to the labels, but I would like to be able to add any shape and add a formula to it to display data. I suppose this is somewhat like Visio, but after being in development with a major spreadsheet for several weeks I would really have appreciated having more flexibility.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

8. ## Adding a few more options to histogram charts

I really like the new histogram chats, but I am missing a few options. One of them is adding an indicator for the mean, for example as a vertical dotted line. I am also hoping for a way to change how the horizontal axes is formatted.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

9. ## Hi/Low bar and column charts

Add an additional chart type that would allow the lower limit of the bar and column to be specified instead of assuming they start at the axis (i.e. zero).

Excel already has a chart along similar lines in the stock "Open, high, Low, Close" chart - and the 2nd and 3rd data fields can be blanked to give what is effectively a high/low chart - however these charts cannot be plotted horizontally as bars.

A high/low bar chart would allow easy creation of Gant charts and would also allow easy comparison between data sets that exhibit a range of data.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Thanks for the feedback. We’ll consider this in a future release.

Thanks,
Scott [MSFT]

10. ## Enable user to choose what Workbook Structure options they want protected

When you protect the workbook structure, it prevents anyone from inserting, deleting, hiding, unhiding, moving or copying the sheets and even stops them from changing the tab colour. It would be nice if we could choose WHAT to protect (eg only deleting and unhiding sheets).

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

11. ## Enable excel online spreadsheet as data source

I would like to be able to use an online excel spreadsheet as a linked data source. Simply paste the excel file url and it likes (similar to sharepoint list, but way easier)

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

12. ## Improve cryptic number formatting (##,#) with preview...

Current number formatting using ##.#, ? , semi colons and commas is too cryptic and has no preview and is just doesn't fit the Excel style. Instead, provide a dialog box similar to font selection with instant preview along with conditional formatting, number format separation, color. Also an option to select for positive, negative, zero and text.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

13. ## Count number of the data in one column which is bigger than the value of a cell in another tab

Currently, we can only make criteria in formula 'countif' or 'countifs' as a number, a comparison with a predefined value, a cell, or a word.
It will also be helpful if we can also make the criteria as a comparison with a cell.
For example:
tab 1 contains a lot of dates in one column
tab 2 contains any other dates in one column
We can count the number of the dates which is bigger than each date in tab 2 through this function.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

14. ## Duplicate the "Scroll to the last/next sheet" on the right hand side of the status bar

When we want to view/select worksheets to the right, it is intuitive to have the "Scroll to the last/next sheet" on the right hand side of the status bar. This could be achieved either as a duplicate of those options or moving those actions to the right.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

15. ## IRM enabled SharePoint library with required metadata

With IRM enabled SharePoint document library, the user cannot create document directly from library where are some required fields.
User tries to create document in SharePoint document library which ends with error. He has to close Excel and reopen it again, fill required metadata and save it one more time.
It doesn't work in any version of Word (DVD-installed or Click to Run).

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

16. ## PowerCrud

There are at least 99 ways to read data from a database into excel. 99% of the analysis as a result has to live in local excel files, since there's no ability for data to be stored back to a database - without vba tricks, or a BI stack using SSAS. Please, for Pete's sake, spend some time authoring a write- back facility at minimum, PostgreSQL, SQL Server, Oracle and MySQL.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

17. ## Apply View > Formula Bar at sheet level

The options in the View ribbon, Show group are not consistent in their behaviour. Ruler, Grid lines and Headings are applied at the sheet level. But Formula Bar is applied at the application level, so even other workbooks will show/hide the formula bar according to the setting in the current sheet.

Please apply the View Formula Bar only at sheet level, so that other sheets and workbooks are not affected.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

18. ## restore 3-D rotation of graphs in excel

it is often useful to have line graphs that run vertically rather than horizontally. It is used to be easy to rotate a graph 90 degrees clockwise. Now the 3-D rotation function is present in all the relevant menus and toolbars, but it is grayed-out and does not function. How come? Is there a way to turn this back on?

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

Thanks for the feedback. We’ll consider this for a future release.

Thanks,
Scott [MSFT]

19. ## Please implement main historical and astronomical chronology (mini. Gregorian Calendar, Julian calendar, julian day, may be also Roman Calen

It would be very helpful to use Excel as most popular tool also in historical works.

(thinking…)
Signed in as (Sign out)

We’ll send you updates on this idea

20. ## New idea for newest version of Excel (3D version)

Each Workbook will have a few sections, and each section will has a few WorkSheets.and finaly each Worksheet has many data like old versions. Summary it means : data devided in sections and sheets (3D version). I Create 3 Pictures for this idea , in this link : https://www.dropbox.com/sh/qiqk0lk6hg681q8/AADxueKciHMyWJwBbPiV1yuba?dl=0