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 thirdparty 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.

Customisable formula bar size. The ability to scroll within the formula bar
Enable formula bar size adjustment. Add reliable scroll function within formula bar. Tap cursor back or forward to allow cursor movement between characters in formula bar.
24 votes 
Define Name for a range
Name a range in Excel Online and make available to use in formulas in other workbooks
139 votes 
Be able to link cells between excel files in teams.
Be able to link cells between excel files in teams.
9 votes 
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.
5 votes 
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.
3 votes 
Add function to name a cell or range of cells
Please add support to name a cell or a range of cells.
1 vote 
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)
3 votes 
formula bar is gone on online excel
help its gone and I want to get it back
1 vote 
evaluate Formula
Make Evaluate Formula and Formula tab available online.
6 votes 
11 votes

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).2 votes 
Sharing, Protecting, cross sheet functions
It will be good if we have functions like Importrange and Query functions.
Sharing , protecting the cells, is not as good as google sheets.
Cell based editor history,
Macros, like
all those things which are available in google sheets.7 votes 
Merging cells
Please allow merging of cells when there are more than one cell contains a value  such as when merging words with numbers.
6 votes 
Get data from the external worksheet in Excel Online
Get data from the external worksheet in Excel Online
3 votes 
allow protect cells function!
Allow protect and unprotect cells function !
5 votes 
Enable the insert of a table of contents
Enable a 'Table of Contents' to be created, with links to all worksheets in the Excel Book
3 votes 
I suggest for a subtotal function in the data tab.
its easier to use the subtotal function in making excel data.
3 votes 
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 
1 vote

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 carfiltered 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 SUMLibre Office has a function fairy, complex functions and equations are much more editable
1 vote
 Don't see your idea?