Feedback by UserVoice

Excel for the web

Welcome to the web version of Excel's feedback forum! This is the place for users to send us suggestions and ideas on how to improve. 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. 162 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Hello,

    Thank you for your continued suggestions and votes. We’re currently rolling out a format task pane for charts and are investigating incorporating this feature as we continue to support more formatting capabilities on Excel Web.

    Thanks!
    Auston, [MSFT]

  2. Allow VLOOKUP across Online workbooks

    In Excel client, it is possible to define a VLOOKUP across two workbooks. Not just sheets within a Workbook, but across two different files. Excel will retrieve and keep the filename and path.

    At one time this allowed me to create a complex (ever changing) network of various different but related data listings, without having to copy list 1 to workbook 2 for VLOOKUP validation. The files were stored on a fileserver that everybody had access to using the same Drive letter. Yes, this is old school.

    Now in the Online world, I want people to work on different workbooks,…

    153 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    13 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  3. Online scripting language

    Include a scripting language on the online version in the same way that Google sheets does. The ability to automate excel on the desktop version via VBA is where the real power of excel is, the online version is therefore significantly handicapped by the lack of any scripting language. Power users need the ability to automate spreadsheet tasks.

    151 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Accepting Votes  ·  14 comments  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  4. Create the ability to lock certain cells while being able to edit other cells in the same sheet.

    Currently, there is not the ability to lock certain cells in a document online, while also being able to edit others in the same sheet. It would help a ton if there was a way to lock specified cells in a sheet and also be able to edit unlocked cells in the sheet when editing online.

    147 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    15 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  5. Notifications when file is updated

    I would like to know when my OneDrive file that I have shared with someone is updated by that other person.

    145 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Accepting Votes  ·  14 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
  6. Add custom error bars to Charts in Excel Online

    My students need to be able to add previously calculated error bars to column graphs (to make a bar graph of means +/- standard errors). Adding this to the online version will make it easier for groups to be able to collaborate in real-time using the online version. This would make Excel online beat Google Sheets hands down for me.

    142 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Hello,

    Thank you for your suggestion and votes. We’ve recently rolled out a format task pane for charts and are investigating incorporating error bars as we continue to add more formatting capabilities for Excel Web.

    Thanks!
    Auston [MSFT]

  7. Define Name for a range

    Name a range in Excel Online and make available to use in formulas in other workbooks

    129 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    13 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  8. Power Query: Make it easier to connect to files on OneDrive and SharePoint

    Connecting to Excel files stored on OneDrive and SharePoint is a difficult and confusing experience. While it is possible, it is far too difficult.

    As more and more move to working in an online environment we need a simple way of connecting.

    112 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    13 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  9. Fix Excel Online Print Paper Selection Defaulting to A4

    When printing from Excel online (in either IE or Chrome) the paper type is defaulting to A4 instead of Letter.

    105 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    28 comments  ·  Printing  ·  Flag idea as inappropriate…  ·  Admin →
  10. Support UDF(User Defined Function) in Excel Online

    Without supporting UDF (User Defined Function) in Excel online, this service is pretty useless for any professional Excel users or any corporate environments where Excel VBA, Macros, Add-Ins are widely used.
    And, do not forgot, Google Spreadsheet already has it. A lot of people think UDF+Macro are the main advantages Excel Desktop version really has.

    105 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  11. CELL function added to online

    In the desktop version of excel,

    =MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,255)

    is the only way to find the current sheet name. On Excel Online, the function CELL does not work.

    93 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    17 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  12. Please add the abilty to copy charts from Excel online in order to paste into other apps

    Hi, I have set up charts for data visualisation within Excel that I would like others to be able to use in their reports and presentations. Unfortunately Excel Online does not appear to allow you to copy a chart.

    Is there a workaround (that doesn't mean the user opening in Excel desktop and thus locking the file) or could this be added please?

    Thank you.

    89 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Hello,

    You can currently copy a chart from Excel Web and paste it into other office applications as a picture. We’re investigating expanding copy/paste from Excel Web to do more, so please continue adding votes if this is a feature you are looking for.

    If you are working in Office 365 versions Excel for Windows and Mac, opening the workbook from your desktop applications will not lock the file for others.

    You can learn more here: https://support.office.com/en-us/article/Collaborate-on-Excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104

    Thanks!
    Auston [MSFT]

  13. It doesn't have all functionality as desktop excel. Make Online excel = Desktop excel

    Data formatting could be made as easy as in Desktop excel. As we are very much used to mouse it will be better to have those functionality to copy paste & other functions. In simple words make Online version = Desktop version.

    84 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 →
  14. color and font themes need to carry over from excel offline.

    color and font themes need to carry over from excel offline.

    81 votes
    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 →
  15. When files are locked by another user

    It would be good to have a way to notify person who has locked the file out that is shared to close it by clicking a button

    75 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
  16. 68 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    16 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  17. When a document is locked (being edited by you or someone else) it would be helpful to know the machine name that where the file is opened.

    Someone else has workbook locked

    Unfortunately, the workbook needs to be closed or checked in before you can edit it. If everyone uses Excel Online, you can work on it at the same time.

    (I know there are opened ideas to show the user who has it opened; however, it would also be great to show the machine name that has it opened as currently, it states that I am editing the file and I don't know what machine it is opened from.)

    62 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    10 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  18. Allow for multi user editing without file locks as with Google Spreadsheet

    Generate the baility to multi user edit concurrently on the same file for both Excel online and application. Currently there is no true multi user editing as anytime a file is accessed even with multiple users enabled it still locks the file and cannot be edited by others.

    62 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  19. 61 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    8 comments  ·  Printing  ·  Flag idea as inappropriate…  ·  Admin →
  20. Protect Range/Sheet, Collaboration Range/Sheet, Tracking history of workbook

    There are several functions that don't work the same in the online version vs desktop. Besides that, in comparison, Microsoft Excel Online doesn't have advanced features in the Google Sheets. Below are a few that are particularly frustrating to me so far:

    ~ Protecting features only works in desktop version (not work online)

    ~ Microsoft Excel Only cannot protect sheets, but Google Sheets can protect sheets or ranges. Therefore, many users can collaborate together with high security in range/ranges, same sheet/sheets in a common workbook.

    ~ and so many advanced other feature in Google Sheets doesn't appear in Microsoft Excel

    57 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base