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.

Define Name for a range
Name a range in Excel Online and make available to use in formulas in other workbooks
14 votes 
Allow formulas working across multiple Excel files
A very powerful functionality which makes all database calculation programs unnecessary.
Simply put: allow formulas to work across multiple spreadsheetfiles.
Description: it’s already possible to use a formula in a spreadsheet file across multiple sheets in the same file. But for more complexed situations that’s not sufficient. For instance when there are (relatively) a lot of users, or a lot of formulas per sheet. It’s also not preferable to have the user data and the management info in the same file.
So the idea is that you can create a management spreadsheet file and then can use formulas which operate…
1 vote 
Please allow to 'Create an array formula' in "online excel"
Please allow the user can create the array formula in online excel as well as like ctrl+shift+enter (offline excel).
1 vote 
Add "Define Name"
Add Define Names and the Formula tab
3 votes 
Copy Values (and formulas) and paste the formulas referring to those cells
It would be great to not have to create an equal sign and toggle between tabs; instead, it would be great to just select certain cells and paste the formulas that would refer to those direct cells. So i copy values or formuals in columns AE, and I paste formulas where each cell I pasted has a formula that refers to those cells
1 vote 
Customize the time zone in a workbook's settings and in the NOW and TODAY functions.
When I use the NOW() function in Excel for desktop, it correctly displays US Central time, which is the time zone my computer is set to. When I use it in a new, blank workbook created in Excel online, it displays it in US Pacific time (my Outlook online settings are set to Central time). When I use it in an online Excel workbook that's shared with my work colleagues in the UK, it displays it in GMT. This seems like it may be a bug that needs to be fixed, but I would also add two suggestions:
1. Within…
1 vote 
Conditional Formatting formulas based on other cells
I would like to format a cell based on the content or formatting of another cell. This would become even more useful if I could apply the same formula to another cell and have the relational cell references remain the same.
Example: If $A1 contains "X", then I would like B1 to be filled red. I should be able to drag the formatting down the column so that all boxes in column B are formatted based on the content of their adjacent A cell.
I did my wedding invitation checklist this way using another online spreadsheet application and it was…
1 vote 
WE NEED COLUMN J ON THE CAPACITY TABS TO BE ABLE TO GO TO 20 PLEASE
SOME REPS NEED TO ENTER HIGHER NUMBERS OF INVENTORY AND THE SPREADSHEET DOES NOT ALLOW FOR HIGHER THAN 15
1 vote 
probably formula function should be available for online excel
IF function not working in online excel but working in local excel. Probably it should be provided for online excel as well.
3 votes 
there should be a shortcut for paste special or an option when you right click the mouse
shortcut for paste special or an option when you right click the mouse
3 votes 
show formula in excle online also
please add formula bar and show formula in excel online
1 vote 
Functions and Formulas for Startups
Excel should have functions that allow users to easily calculate:
Customer Acquisition Costs
Stickiness Ratio
Monthly Recurring Revenue (All types)
Conversion Rate
Customer Churn Rates
Lifetime Value
LTV to CAC Ratio
Good vs bad churn rates
Average Order Value
Lead Generation Rates
Inventory Turnover
Classic (Range and Return) Retention Rates
Cost Per Impressions1 vote 
When using VLOOKUP, allow table columns to be referenced rather than individual cells
Currently in Excel Online you cannot reference table columns, only individual cells, making VLOOKUP functions difficult at best. The real answer is to put all of Excel 2016 into Excel Online so folks can share the document in real time and have multiple people working on it similar to Google Docs
1 vote 
Online version should have same features alike offline one
Online version should have same features alike the offline one
2 votes 
SUMIF FUNCTION DEPENDING CELL COLOR
Apply when I need to sum a range of cells, only the cells with a selected color
1 vote 
Excel online needs to have the option to freeze individual cells not restrict to only top, side etc,
online Excel needs to have the ability to freeze individual cells.
2 votes 
Either make simple things available like FIND or abolish this whole thing
Either make simple things available like FIND or abolish this whole thing
1 vote 
Allow to easily change the Online Excel formula language
I'm not able to find a way to change Online Excel (Offce 365) formula language (I believe it picked up a standard from my account which I would like to change)
3 votes 
ImportHtml formula
Can you please implement ImportHtml formula as well as GoogleSpreadsheet has it?
It is very comfortable to be able to import tables from the websites and to use them as a data source for our spreadsheets.1 vote 
Being able to see formulas and click on cells to see a total
When I am viewing in excel on line if I click in a cell I do not see a formula bar, showing what the formula is in the cell. I often highlight several cells to see a total, however this function doesn't seem to be in excel online.
1 vote
 Don't see your idea?