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.

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.

How can we improve Excel for Windows (Desktop Application)?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Option to Permanently Disable Displaying Page Breaks

    For some reason, Page Breaks just annoy my eyes and serve as a distraction when I am working in a spreadsheet. I would love for there to be a setting in the Options to disable them so I don't have to hassle with toggling them off every time they appear.

    9 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      2 comments  ·  Printing  ·  Flag idea as inappropriate…  ·  Admin →
    • Trace dependents to graphs and names

      When I clean up others' workbooks, I use Trace Dependents to make sure that I can safely delete a value without messing up any part of the file. However, Trace Dependents does not go to graphs or names, so I have to manually check those.

      I feel that Trace Dependents should trace anything that depends on the cell being traced, not just cells.

      24 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        3 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

        Interesting idea. We’ll consider this in the next round of feature planning. In the meantime, please continue to vote on this idea.

        Thanks,
        Scott [MSFT]

      • Printing control - worksheets single/double page

        It would be great if there was some way for preferences to save a setting to specify printing individual worksheets as either single- or double-sided.

        7 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          1 comment  ·  Printing  ·  Flag idea as inappropriate…  ·  Admin →
        • "Clear all" feature should be clearer to spot (and have shortcut)

          I teach excel, and it feels like around 90% of students (daily Excel users) don't know the clear all function exists. Also when someone press the delete key, 90% of the time, they mean to press clear all, they just don't know it exists, so they then remove the fill, change the colour, delete borders, unmerge cells etc, These all take many clicks.

          I truly believe that MOST Excel users waste time every day because they don't know of the existence of "Clear all". Excel should make this really obvious by 1. Adding a keyboard shortcut (Shift + Delete maybe?)…

          22 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

            5 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
          • Bioinformatics: gene names errors

            http://www.ncbi.nlm.nih.gov/pmc/articles/PMC459209/
            http://www.ncbi.nlm.nih.gov/pmc/articles/PMC459209/bin/1471-2105-5-80-1.jpg

            i have recently noticed this while trying to modify a dataset in excel and importing it back into R, which throws the duplicate rowname error (e.g. sep1 and sept1 get automatically formatted into the same values).

            this is a really minor nuisance because most of the work is done in R, and maybe it's better addressed by guys at R. i dunno

            1 vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
            • run calc on save doesn't complete saving for large tables

              follow up for large table and iterative comments. If running calc on save is selected and attempted on very large tables, it won't function completely before closing and data is lost.

              1 vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

                1 comment  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
              • NA() result option in conditional formatting to improve charting of large tables

                Conditional formatting should include NA() result option. Such that if charting from a large table, conditions in data will be ignored. This eliminates the need for long formulas doing the same thing, also allowing for performance improvements

                1 vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  1 comment  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                • Selecting multiple sheets & copying from editing sheet

                  Selecting All Sheets & Editing/Formatting First Sheet Then All Selected Sheets Copying The Format Which We Are Formatting In First Sheet

                  2 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    1 comment  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                  • Improve the precision of object placement on charts

                    Since Excel 10, the precision of placed objects like lines on charts has deteriorated. For example, drawing a 45 degree line on a chart from one corner to the other is very imprecise because it seems the cursor has trouble picking up the correct pixel in the chart axes corner. Sometimes the chart has to be resized to nail the placement down.

                    1 vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      2 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

                      Thanks for the feedback. Would you be able to provide a sample file that illustrates the problem or more specific repro steps?

                      Thanks,
                      Scott [MSFT]

                    • Make points into objects

                      Make scatterplot data plot points into objects that can be selected with the mouse in order to remove them from a regression or move them to another series.

                      2 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        1 comment  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

                        Thanks for the feedback and further details. We’ll consider this in our next planning round for a future release. In the meantime, please continue to vote on this feature idea.

                        Thanks,
                        Scott [MSFT]

                      • PivotTable-able crosstab data entry

                        PivotTables and data entry butt heads with each other.

                        Data is easiest to enter in a crosstab format (headings on rows and columns). The row and column headings eliminate having to specify them for each value.

                        For example, a fuel price table:

                        .........Canada..................................USA....................................
                        .........Diesel...Gasoline...Propane...Diesel...Gasoline...Propane
                        2012
                        2013
                        2014

                        If I want to specify $50 as the Canadian diesel price for 2013, I enter "$50" at the intersection of the correct headings.

                        However, to be able to use PivotTables, the data must be moved to "record" format (no row headings, only column (field) headings, and a lot of repeated information). This is…

                        13 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          12 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                        • Macros usable to other users

                          When you create a macro and send the workbook to other users, unless they have their settings such that they can run a macro, you need to give them special instructions so that the macro runs.
                          Surely, there must be a way to send a workbook with a macro in it to someone without having to tell them to change their security settings which often causes them to think they're doing something to put them at risk.

                          3 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            2 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                          • Drag & drop tools from the ribbon to the Quick Access Toolbar

                            I would like to make a suggestion to Microsoft regarding the next version of Microsoft Office. I am a heavy user of the Quick Access Toolbar (particularly in Excel) and am often adding new tools to the toolbar as I find new tasks I do frequently. It would be nice to have the option to drag and drop tools from the ribbon to the toolbar, rather than going into the Customize window.

                            2 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                            • Capture the unique list of items that are displayed when hovering over a worksheet autofilter

                              rovide the ability to Capture the unique list of items that are displayed when hovering over a worksheet autofilter. It would be a very useful VBA capability.

                              1 vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                              • enable the export of find results to a worksheet

                                It would be very useful to be able to capture the results from a worksheet find operation. Particularly when the search has been carried out for the complete workbook.

                                1 vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                • Possible to have Excel split worksheet into more than two vertical sections?

                                  With Dual Screens almost standard in the Business World, and data columns increasing in number, there are times when we are finding ourselves somewhat frustrated at the vertical screen split limitation. Would it be possible to allow the end user to split the worksheet into more than two vertical sections. Even three sections would be a fantastic help. This would allow the viewing of the beginning, middle and end of the data set, not just select two of the three.

                                  2 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    4 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Animations

                                    Please give users ability to turn off animations when cell is selected. This is annoying and there is no way to turn this off.

                                    13 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      8 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Redundant checkbox when protecting sheets

                                      If you right-click on a sheet tab and go "Protect Sheet", there seems to be a redundant checkbox labelled "Protect worksheet and contents of locked cells". If it is checked, you can press OK. If it is unchecked, you cannot.

                                      If the user wants to protect the sheet, they will click OK, otherwise they will click Cancel. There is no need to activate OK first.

                                      1 vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Data validation - allow Table references as List Source.

                                        If I'm using Data Validation in List mode, and I use a Table reference (e.g. "=Table1[Column1]") as the source, for some reason it doesn't work!

                                        The workaround is to create a separate named range for that Table reference (e.g. make a named range called "Table1Column1" that Refers to "=Table1[Column1]", but it's a real pain to have to do this every time, and it is something that I use a lot!

                                        29 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          7 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Create NETWORKHOURS as a new function

                                          I would like to see a function that calculates hours worked over a period of Excel Dates that incorporates working hours and non-working hours as well as holidays and weekends parameters. This function could use similar logic to the NETWORDAYS.INTL function's use or holidays and weekends parameters.

                                          20 votes
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                                          • Don't see your idea?

                                          Feedback and Knowledge Base