Feedback by UserVoice

Excel for the web

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 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. Maintain hidden rows/columns in "sheet view" so other users are not affected by the change

    Sheets view offers a private view of the Excel sheet when sorted or filtered, another common change is hiding rows/columns but that currently affects all users when sharing document.

    Allow for row/column views to remain private in Sheet View so others are not affects.

    444 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

    50 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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.

    255 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

    33 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for showing passion for Power Query and various improvements! We are indeed looking to implement this suggestion.

    In general, we’re evaluating our future investments and your votes help us to prioritize. Please keep voting if you like these ideas.

    Thanks!
    Jonathan Kahati
    [PM @ Excel]

  3. Pivot tables updating wrong data values for the given filters

    I've created a large excel file with many pivot tables from a single data source. I used macros to auto update pivot filters. The pivot data values show different values to the selected filters. When I double click on the data values it opens up source data in a separate worksheet with rows different from the selected filters.

    Please see attached screenshots.

    I can better explain this if you could call me back/arrange for a video call.

    Thanks

    10 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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  4. Enable and Disable fill handle and cell drag-and-drop Excel ONLINE

    Please make an option like in Desktop Excel, that allows to enable or disable drag-and-drop cells.
    ONLINE excel ir great for sharing one document with many people, but many times it can get annoying if someone by accident dragged the cell to other and one or both of the cells was used in formulas. Even with Password protection this dragging is possible, so it`s not an option to prevent that.

    15 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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  5. Can we add Immersive Reader support for Excel on the web?

    Since Immersive Reader also handles math, formulas, and translation, it would be really helpful to have this available in Excel. Immersive Reader also offers read aloud and is extremely beneficial in support of accessibility for all learners/users.

    56 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

    11 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  6. Ribbon display in Excel on the web is cut off

    *English follows Japanese

    ■Title(件名):
    Excel on the web のリボン表示が見切れてしまう
    Ribbon display in Excel on the web is cut off


    ■Description(内容):
    ブラウザーで Excel on the web を開き、幅を狭めるとリボンが見切れてしまう。
    デスクトップアプリでは、リボンが見切れた場合も矢印で移動させることができますが、ブラウザーでは画面サイズを変更しないと表示できません。
    PC 上に、Excel を 2 つ並べて作業をするときに不便となるので、リボンを移動させる機能を実装してください。

    When you open Excel on the web and make it narrower, the ribbon gets cut off.
    On the desktop app, if it is cut off then an arrow appears so you can move along it, but on the browser you need to resize the window to see it.
    It is inconvenient to have different behavior on two Excel interfaces on the PC so please add the ability to…

    11 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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  7. Enable Office Scripts to refresh Power Query queries

    Allow Office Scripts to refresh Power Query queries. It'd be very helpful to automatically refresh data using Power Automate, but that platform cannot currently refresh data.

    49 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  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    Hello,

    Thank you for providing the feedback. Your input helps us in making the product better.

    Reg. Power Query refresh action – yes, this is in our backlog. We don’t yet have an API that can refresh a Power Query. We’re working with the product team to prioritize the API. I don’t have an ETA yet. But, we’ll be monitoring this closely and update our docs once the feature becomes available. Feel free to email me if you need more details.

    Thank you,
    Sudhi Ramamurthy
    Program Manager
    Suramam@microsoft.com

  8. Please enable protect cells feature in online excel

    Currently, online excel doesn't have the feature to protect cells. This feature comes very handy during collaborations. Please enable this feature, even google spreadsheet has this feature.

    6 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  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
  9. I want to lock the display zoom when opening Excel on Office for the web

    *English follows Japanese

    ■Title(件名):
    Office for the web で Excel を開いた際の画面の拡大率を固定したい。
    I want to lock the display zoom when opening Excel on Office for the web


    ■Description(内容):
    SharePoint Online、 OneDrive for Business に保存された Excel ファイルを Office for the web で開くと拡大率が 100% で表示される。
    SharePoint Online からファイルを開いた際に、75% など任意の拡大率で表示できる機能の拡充を要望します。

    Excel files on SharePoint Online and OneDrive for Business will open at 100% zoom when opened in Office on the web.
    Please make it possible to open them at 75% etc. zoom levels when opening from SharePoint Online.

    13 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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  10. Connect Office Scripts to Buttons

    Similar to Excel for desktop, mapping Office Scripts to a button on excel online would be incredibly useful.

    8 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  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  11. Excel editing history

    *English follows Japanese

    ■Title(件名):
    Excel の変更履歴について
    Excel editing history


    ■Description(内容):
    現在、Excel データの変更した内容に関しては、[バージョン履歴] 確認により、更新したユーザーのみが確認できる状態です。
    データの修正や、消去した内容なども確認出来るよう機能の追加を希望します。

    Currently, changes to data in Excel can be checked in “Version history” by only the user who made the changes.
    Please add the ability for others to check what data was altered or deleted.

    12 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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  12. Allow use of the old comment functionality on Excel Online

    *English follows Japanese
    ■Title(件名):
    Excel Online で従来のコメントを利用できるようにしてほしい
    Allow use of the old comment functionality on Excel Online


    ■Description(内容):
    この度、Excel のコメント機能が新しくなり、Microsoft 365 の Excel であれば、クライアント上で新しいコメントと従来のコメント (現在のメモ機能) が両方利用できるが、Excel Online では新しいコメント機能しか利用ができない。
    Excel Online でも従来のコメントを利用できる方法を希望します。

    The comment function on Excel was updated recently, and in the Microsoft 365 client version of Excel, you can use both the new and old (now notes) versions of the function, but you can’t do this on Excel Online.
    Please add this to Excel Online.

    9 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  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
  13. Teams does not allow you to use the notes feature in excel

    Notes are much better than comments in excel and you don't let us add notes when working on excel in Teams. Accountants use spreadsheets year after year and the notes feature is key to documenting what is in the cell. Comments doesn't do the job.

    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

    0 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  14. Word Wrap By Default for all cells

    Word wrap is not enabled by default. Usually we have to enable it one column at a time or cell at a time. Can we have it enabled by default ? (Option to disable can be there)

    26 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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  15. Freeze first row in Excel by default

    In most spreadsheets the first row is usually headings. Can we have that row frozen by default (of course have undo allowed).
    Save everyone across the world the time to freeze that top row !
    Those that want column and row freeze options can do it manually.

    26 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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  16. Ability to create custom functions

    Wound be nice to be able to create custom functions with office script just like in desktop VBA.

    1 vote

    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  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  17. Add more functions to Excel on the web, such as diagonal lines, word wrapping and insertion of text boxes

    *English follows Japanese

    ■Title(件名):
    Web 用 Excel の斜め罫線、折り返し表示、テキスト ボックス挿入の機能拡充希望
    Add more functions to Excel on the web, such as diagonal lines, word wrapping and insertion of text boxes


    ■Description(内容):
    Web 用 Excel では、Excel クライアント アプリと異なり様々な機能制限があり不便。
    特に以下の機能については Web 用 Excel でも利用できる機能の拡充を希望します。
    ・ 斜め罫線
    ・ 書式設定 > 配置 > "折り返して全体を表示する"
    ・ 挿入 > テキスト ボックス
    これらが実現するだけで、業務効率は各段に向上します。

    There are a number of restrictions in the web version of Excel that differ from the client version.
    In particular, please add the following functions:
    Diagonal ruled lines
    Formatting – Align – Wrap to fit
    Insert – Text Box
    If these were added, it would improve…

    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 →
  18. Office 365 Excel needs the show formula function

    CTRL + ` would display the entire sheet in formula view. As a teacher, I need this feature to correct student work.

    5 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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  19. Allow to Enable New Simplified API

    Who gets to preview it? When will it come out of Preview (been almost a year)? Will it be available in Excel online? Is a special license required? I'm using the free Excel online.

    If i create a script containing the following:

    function main(workbook: ExcelScript.Workbook) {
      // Your code goes here
    }
    i just get an error "Cannot find namespace 'ExcelScript'." Can i enable this by adding something to the Libraries tab?

    1 vote

    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  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  20. Give Office Scripts access to an XML library

    Most of our VBA macro spreadsheets involve generating XML imports for other programs. I would prefer to move to Office Scripts and One Drive, but cannot find an interface to build an XML document like the DOM API.

    1 vote

    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  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for adding your request.
    Couple of clarification questions to help understand the ask:

    • Is the goal to generate XML document from the script? How will the XML be passed to the other programs? Do you intend to use Power Automate flows for that?
    • Could you please elaborate on which specific DOM APIs are you looking for?
      For instance:
      const doc = document.implementation.createDocument("", "", null);
      const peopleElem = doc.createElement(“people”);

    Thank you,
    Sudhi Ramamurthy
    suramam @ microsoft . com

← Previous 1 3 4 5 145 146
  • Don't see your idea?

Feedback and Knowledge Base