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. Center Wrapped Text Without Left Offset that Occurs Now

    When you Wrap Text in a cell in excel and center, the text is distinctly further to the left whether or not there is any wrapping occurring, not centered as it would be if you manually spit the text into two cells and used the built-in centering.

    Make wrapped text center without the offset.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

      This is already supported.

      After you wrap text in a cell, click on the “Align Center” button, and the text will align in the middle of the cell

      Cheers,
      Dan [MS]

    • please make a way for test boxes to snap to the grid

      please make a way for test boxes to snap to the grid

      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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
      • Bring back parentheses for negative number formatting

        Bring back parentheses for negative number formatting as in previous excel versions

        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

          3 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

          Using parentheses for negative number formatting is still supported by Excel (just like in previous versions).

          To use it:
          1. Select the cells/range you want to use parentheses when negative.
          2. Press Ctrl+1 to bring up the Format Cells dialog (or on the Ribbon, click on the Number format drop down, then select “More Number Formats…”)
          3. On the Number tab of the Format Cells dialog, select the Number category, and then one of the number formats that uses parentheses for negative numbers.

          Cheers,
          Dan [MS]

        • 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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

            Hi,

            This is already supported in Excel. To clear a print area
            1. Click anywhere on the worksheet for which you want to clear the print area.
            2. On the Page Layout tab, in the Page Setup group, click Clear Print Area.

            You can see these steps here: https://support.office.com/en-us/article/define-or-clear-a-print-area-on-a-worksheet-2e5992fa-f201-41a1-9f39-370ff14deca1?ui=en-US&rs=en-US&ad=US#bmclearprintarea

            You can see this visualized here: http://www.solveyourtech.com/how-clear-print-area-excel-2010/

            Cheers,
            Dan [MS]

          • auto border

            An automatic function that would put borders in your table in an automatic way.

            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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

              You can do this a couple ways -

              1. If you apply a table style that has a border, you’ll get a border on your tables

              2. You can take #1 a step further by defining a table style (or customizing an existing one) to have a border you like, and then you can set that table style as the default table style.

              Of course, you can also add a border around your table using the border button on the ribbon too (but it’s not automatic, and takes two clicks per table).

              Cheers,
              Dan [MS]

            • Add gradient fill as a cell fill option

              The ability to fill a range of cells with a gradient color would allow for a greater level of creativity and a professional polished finished product.

              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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

                One and Two color gradient fills are already supported. To add one,

                1. Select the cell you want to fill
                2. Press Ctrl+1 to bring up the Format Cell dialog
                3. Click on the Fill tab, then “Fill Effects…”

                Now you can create your gradient.

                Hope that helps,
                Dan [MS]

              • I think the default way to format a time should be HH:MM:SS.000

                Currently the default time format is MM:SS.0 which I don't find helpful because I don't know which hour the time is from. Alternatively we should able to set a default time format for Excel

                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

                  1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

                  The default time format is taken from your system time format. In US English, it is h:mm:ss AM/PM

                  (actually it is [$-x-systime]h:mm:ss AM/PM)

                  Cheers,
                  Dan [MS]

                • Add default formatting to File-Options

                  Add default formatting to File-Options. I prefer my spreadsheet format to be vertically aligned to TOP, CENTERED and WRAP. I have to adjust this on every new spreadsheet. Add the initial format to File-Options where the user could set it up according to their preferences. Then, we would only have to modify exceptions.

                  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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
                  • Allow Relative References in Conditional Formatting Formulas

                    The ability to use formulas in conditional formatting is a great feature.
                    Unfortunately only absolute cell references are permitted in the formulas, and not relative cell references.
                    For example, I often want to apply red/yellow/green conditional formatting based on the value of an adjacent cell.
                    For example the formula >=2*$A$1 can be used with green formatting to highlight cells with values that are twice the value of cell A1.
                    What I want is the ability to use a reference like >=2*A$1 which will compare to the first cell of each column (A1, B1, C1, etc), rather than comparing everything to…

                    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 →

                      Hi,

                      This is already supported.

                      To make a conditional format relative, define it on a single cell, using the relative formula that you’d like it to use (like the one in your idea, if you want it to adjust across columns).

                      This will format the cell on which the conditional format is applied.

                      Then, in the “Applies To” range in the Conditional Formatting Manager, change the range from that original cell, to the range on which you’d like the CF applied.

                      That will adjust (according to the referencing you’ve specified) the conditional formatting rule for each of the cells in that range.

                      Cheers,
                      Dan [MS]

                    • Time not as Time of day

                      Excel has plenty of number formats and time functions, however there is no way to have times (for athletes tracking times etc.) with longer decimals in the seconds position. I want to have cells formatted as hh:mm:ss.### given that "#" is a number representing the partial seconds after the decimal. Clearly I can use the apostrophe to input these times as text, but then I cannot use functions to find how much time has passed. Excel needs to have more time formats that do not necessarily correspond with the time of day, and that allow for fractional seconds beyond one…

                      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 →

                        Excel already supports showing fractional seconds. To get them, you can use the following number format:

                        hh:mm:ss.000

                        (you can also omit the hh:mm if you just want seconds)

                        Hope that helps,
                        Dan [MS]

                      • Allow me to format with "" and insert /n

                        Can you allow me to format text with "" Example "John Doe" Also, can you create button that inserts a \n where I need it?

                        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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

                          Hi George,

                          You can already format text with quotes (but maybe I’m misunderstanding what type of formatting you’d like to see – please clarify).

                          For inserting a new line, you can press Alt+Enter

                          Cheers,
                          Dan [MS]

                        • 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 →
                          • Windows 10 does not allow me to place the commas on accounting values where i want to sometimes

                            I must always be able to format giving me the commas after three places in accounting and currency format

                            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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

                              You can use a custom number format to place the comma, if the built-in ones don’t work for you. If you’re having trouble even with custom formats, please upload a copy of the file that shows this issue, or list out the specific steps that reproduce the issue, so we can look into it.

                              cheers,
                              Dan [MS]

                            • Bring back the remove Hyperlink button

                              Please bring back the "Remove Hyperlink" button on the right click cell menu.

                              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 →

                                Hi George,

                                The Remove Hyperlink option on the cell context menu should still exist (I just verified it in the current version).

                                Marking this completed so you get your vote back.

                                Cheers,
                                Dan [MS]

                              • Merge Cells - Allow User to Change the Default Merge Cells Format

                                Instead of always merging AND centering, I would rather it maintain the formatting of the original cell that contains the data. More often than not, if the original cell is formatted as left justified prior to merging then I want it left justified after the merge as well.

                                If this isn't possible, then at least allow me to change what it defaults to in the home excel options as well as give me more standard options to choose from. Or allow me to create my own combinations of merge and format combinations to default to.

                                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

                                  12 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

                                  Hi jf,

                                  We’ve got this in Excel today! :-)

                                  Instead of hitting “Merge & Center” on the ribbon, click the drop down arrow beside it and choose “Merge Cells.”

                                  Cheers,
                                  Dan [MS]

                                • date format is impossible to change

                                  When typing in a date such as this: "7/15" it is impossible to make this value show up in a new worksheet as 7/15/currentYear in a format I want. It will always show up as "15-jul" or "dd-mmm". Yes, the date will be correct, it will also be correct for the USA, but it's not in a visual format that I like and I have to manually change the cell format because there's no universal way to make this setting.

                                  4 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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

                                    Hi,

                                    This is already supported in Excel today. Right click the cell, select Format Cells > Number tab > Date, and then choose the date format you’d like.

                                    Hope that helps,
                                    Dan [MS]

                                  • Don't see your idea?

                                  Feedback and Knowledge Base