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. Linking of excel sheets in multiple files using formulas in sharepoint.

    Working in single file is a basic thing. However linking of multiple excel files through formulas are not present in sharepoint. For example VLOOKUP(), SUMIF(), MATCH() e.t.c.

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  3. Libre Office has a function fairy, complex functions and equations are much more editable

    there would be no need for macro solutions if the calculation formula could be embedded in a car filter function on the worksheet. Only the car-filtered results would be subject to the calculation of the specified function and the relevant one.
    Although there is a SUBTOTAL function, only a few functions are capable of doing so.
    Függvénykód
    (also hidden values) Function code
    (omit hidden values) Function
    1 101 AVERAGE
    2 102 WORKS
    3 103 WORKS2
    4 104 MAX
    5 105 MIN
    9 109 SUM

    Libre Office has a function fairy, complex functions and equations are much more editable

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  4. calculation of car filtered data with car filter function

    there would be no need for macro solutions if the calculation formula could be embedded in a car filter function on the worksheet. Only the car-filtered results would be subject to the calculation of the specified function and the relevant one.
    Although there is a SUBTOTAL function, only a few functions are capable of doing so.
    Függvénykód
    (also hidden values) Function code
    (omit hidden values) Function
    1 101 AVERAGE
    2 102 WORKS
    3 103 WORKS2
    4 104 MAX
    5 105 MIN
    9 109 SUM

    With this solution, car function results could be calculated with any function

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  5. ability to see number of filtered rows

    be able to see how many rows are filtered.

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  6. Request to please add formulas name manager in this format of Excel(web)

    Request to please add formulas name manager in this format of Excel(web)

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

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  8. Add Query (See Google Sheets for functionality)

    Query is a lot easier to use when performing aggregations than VBA.

    =Query({Shee1t!B2:E}, Select Col1, Col2, Sum(Col4)/1048576 Group By Col1, Col2 Where Col2 IS NOT NULL Label Col1 'Cluster', Col2 'Index', Sum(Col4)/1048576 'Size (MB)'
    -> Would take data from Sheet1, cell range B2 upper left to last row of E), and for each combination of values from Col1 (matching the first column in the original cell range, which is column B ) and Col2 (column C) sum the corresponding values from Col4 (column E).

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  9. Link to another tab in same sheet appears to be disabled in a shared file. Tried on PC and Mac. Commonly done in multi-tab spreadsheets

    I have a multi-tab spreadsheet that is shared in one-drive. Formulas need to link to data in other tabs. It's a common function used to create a total "tab" from several sub-tabs. Example: Global Sales tab summed from several Regional tabs.

    This appears to be locked when the sheet is shared. There is no clear way to unlock it and no clear help on doing so.

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  10. Excel Data Group Need to Function in Protected sheet

    In a Protected Work sheet, Data Groups of Columns & Rows is not working.

    I like to suggest, We need to have Multi User & Multi Function password Protection based on user requirements

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  11. Function Library (book icons) in the Formulas Tab

    Basic and intermediate users may be happy to see all the book icons in the Formulas Tab (Function Library group) as we have in the desktop version, to help them to find which functions can be used. Even the mobile version has the categories there... This would be welcome on the online version too.

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

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  12. LET function

    By when can we expect LET function to be rolled out in excel web? I understand that the function is still in beta and currently only available to a portion of Office Insiders but still I haven't faced any issues so far in the beta version and it saves a lot of time in writing long formulas which use repetitive arrays and calculations.

    My request to the MSFT team is to come out with a basic version of LET function for excel online even if it is not perfect.

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  13. Expand The NLP "Ideas Function" To Create, Manipulate And Delete Data, Not Just Summarise And Visualize Data

    Today, under Excel Ideas, you can enter in a question about your data using NLP (writing plain English without formulas). However, there is no way to use Ideas to create, manipulate or delete data. For instance, I know I'd like to pivot and condense a complex dataset, but I do not know how to formalize this using formulas.

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

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  14. ERROR in TODAY FUNCTION

    =TODAY() is giving 04/05/2020 still even though time is 05/05/2020 9:51

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  15. New formula for pasting value or multiple but in a cell referenced in the formula.

    Create a formula which drives a function and shows the value in target cell.

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  16. New formula for pasting value or multiple but in a cell referenced in the formula.

    Create a formula which drives a function and shows the value in target cell.

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

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  18. In Online excel formulae on different should be applied . As of now have to keep both reference data in single sheet .

    Online excel to apply vlookup formula , data is to be maintained in a single sheet to apply the same . Data if present in multiple sheets , then formulae should be applied irrespective of data present in single sheet .

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  19. Be able to link cells between excel files in teams.

    Be able to link cells between excel files in teams.

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

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  20. I suggest for a subtotal function in the data tab.

    its easier to use the subtotal function in making excel data.

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

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 6 7 8
  • Don't see your idea?

Feedback and Knowledge Base