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.

  • 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 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]

  2. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  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]

  3. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    14 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]

  4. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  5. Bring back parentheses for negative number formatting

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

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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]

  6. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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]

  7. auto border

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

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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]

  8. 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
    (thinking…)
    Sign in with: Facebook Google
    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]

  9. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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
    (thinking…)
    Sign in with: Facebook Google
    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]

  11. 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
    (thinking…)
    Sign in with: Facebook Google
    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]

  12. 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
    (thinking…)
    Sign in with: Facebook Google
    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]

  13. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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
    (thinking…)
    Sign in with: Facebook Google
    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]

  15. Bring back the remove Hyperlink button

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

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    already supported  ·  1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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
    (thinking…)
    Sign in with: Facebook Google
    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