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. copy-paste formatting options icons: let's make them more intuitive

    hi guys,

    I've always found the existing copy-paste formatting option icons in Excel and other MS Office programmes a bit confusing and I had to hover a mouse over to see what they are meant to do (an example attached). Could we please simplify them and make more intuitive?

    Thanks,
    Ivan

    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

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  2. Please add this icon to the conditional formatting icon sets.

    under conditional formatting and in the directional icon sets, there are no back arrows or diagonal back arrows (reverse arrows!!! pointing to the left). If you could add this icons to the new updates this will be so appreciating.

    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

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  3. Conditional Formatting caused a huge delays when undoing a paste (or using CTRL-Z)

    With 16 GB of RAM and a super fast processor undoing (or ctrl - z) of a paste takes 2 minutes to undo conditional formatted cells.

    If you copy bunch of cells, paste them on a new Excel or same Excel document, and then attempt to undo the paste, it takes 2 to 3 minutes. Pasting it does not take that long.

    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

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  4. disable text to columns

    I can't disable text to columns. After its first use, Excel forces every subsequent paste to be Delimited. I need Excel to paste without manipulating into columns but cannot turn this feature off. Very frustrating!

    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

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  5. conditional formating with icons to compare a value in the same column

    With the cell just up the active cell, it's impossible. Possible with the first value on the op of the column.
    INDIRECT and INDEX are not supported.

    With icons (ie:arrow up:down)
    to see if the value is the same, greater or lower than the value in the just up the activecell. To see the progression.

    Thanks

    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

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  6. Add Word style numbering and formatting

    While it is possible to number rows using the ROW formula, it would be nice to have the type of Numbering available in Word to give an easy way of doing list with levels in Excel.

    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

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  7. Support # in excel hyperlinks for local system files

    Currently hyperlinks in excel don't support '#' character. Hence, I am not able to create hyperlinks for local files whose path contain # character.Hence, all characters that are allowed in paths of files should be supported in hyperlinks in excel.

    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

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

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  9. Landscape and Portrait should be a toggle.

    Landscape and Portrait should be a toggle. It would save clicks...there are only two options...one or the other

    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

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  10. Keep cell formatting when editing hyperlink

    When you edit a hyperlink (eg the screentip or URL), the formatting gets set back to default hyperlink styling (eg blue underlined Times New Roman). I use completely different styling for hyperlinks (Wingdings, with conditional formatting defining the font colour) and it's so frustrating having to re-apply the formatting once you have edited a detail of it.

    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

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  11. Give us back our formatting windows, instead of the ridiculous formatting sidebars for objects, among other things.

    Give us back the formatting windows, instead of the formatting sidebars for objects in Excel 2016. It is impossible to navigate the sidebars using the keyboard, as one used to the windows, significantly decreasing productivity.

    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 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  12. More formatting options

    These are the existing format options available in excel

    General

    Number

    Currency

    Accounting

    Date

    Time

    Percentage

    Fraction

    Scientific

    Text

    Special

    Custom

    in most of my business cases i miss all the below fields

    Email

    Website url map
    Social Facebook Twitter
    Contact Mobile landline

    Pincode Country state

    Poll Q1 Q2 Q3
    Apps App URL

    it would be great if Office can consider adding more formating options
    in word,excel etc

    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

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

    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

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

    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

    4 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  15. Add 1 button for drawing "all borders" and "thick box border (outside)" of the table at the same time

    There are a lot of kind of buttons for drawing borders of the Excel table. But as long as I know the most used ones are "all borders" and "thick box border".
    I have to click both of them most of the time for each table. can you add 1 button for drawing "all borders" and "thick box border (outside)" of the table at the same time ?

    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

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  16. Add number formats for just hours for calculating time elapsed

    When calculating time elapsed, I would like a format option for the answer to show up in just hours instead of hours and minutes. Right now, 7:00 am to 3:30 pm will result in a time elapsed of 8:30. (hours and minutes) I would like an option for it to show up as 8.5 (hours only). This will help in calculating payroll.

    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 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  17. Create a new orientation in data bar (up to down, down to up)

    The current model Data bars in the conditioning format allow just you decide to change the orientation left to right or right to left. Is it possible to get this data bars orientation up to down or down to up. Thank you.

    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 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  18. Dedicated Tickmark Ribbon Financial Analysis/Auditing

    Make a dedicated Ribbon that contains tick-marks used by every financial analyst as well as auditors. This Ribbon would also have the ability to document what each tick-mark represents in a "legend" of sorts. We use Excel everyday all day and I find myself searching through fonts and conditional formatting icons for the right level of them. For example, I wanted to have a conditional formatting rule that had 6 icons but i am limited to this and had to create a work around for this and ultimately we moved over to another tool that was able to customize icons.

    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 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  19. Bring back 2 formatting shortcuts that were in older versions

    There are two in particular.
    1. When changing the format of the number on a chart & selecting "number" you have the option to specify the number of digits. There used to be up & down arrows to use the mouse to change the number of digits; you could keep your hand on the mouse & select the desired number of digits. Now you can only do this from the keyboard.
    2. It used to be possible to make a number of formatting changes to a curve, select a new curve, & press F4 to apply all of those formatting…

    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

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  20. Improve Excel Profile usage options

    There are many great ways that Excel likes to be helpful. Often its helpfullness gets in the of a simple task such as entering a number. If there was a method of telling Excel that I am not a mathematician and I don't need my numbers turning into logarithmic formulas when I'm simply importing a datasheet for inventory, invoices, and tracking information. I understand that turning the column into text will prevent that from happening but it also turns other useful features. Maybe what asking for is more granularity options in the way Excel autocompletes information.

    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

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base