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.
-
When I click through multiple tabs of the same workbook in Excel Online, the tabs get re-arranged almost as if I'm dragging them.
This needs to be fixed.
22 votesThanks for submitting this request! Based on your feedback, we’ve fixed that issue and it’s now available in production as part of the new sheet tabs bar UX. We invite you to go and try the new design and improved functionality of the sheet tabs, including a new drop-up sheet menu. We’d be happy to get your feedback!
Thank you,
MSFT -
Embedded SharePoint Online Excel file doesn't display horizontal scrollbar
When embedding a Excel online file into normal CSS webpage using codes, Online Excel file doesn't display horizontal scrollbar.
The only way to get to the data to the right of the view port is to click on a cell and then use the right arrow key to scroll to the right.Codes referenced from this official article.
https://support.microsoft.com/en-us/office/embed-your-excel-workbook-on-your-web-page-or-blog-from-sharepoint-or-onedrive-for-business-7af74ce6-e8a0-48ac-ba3b-a1dd627b7773sample : <iframe height="500" width="100%" frameborder="0" scrolling="no" src="[SharingURL]&action=embedview&wdHideSheetTabs=True&wdAllowInteractivity=False&wdHideGridlines=True&wdDownloadButton=True"></iframe>
Screen shot attached.
3 votesI would like to share with you that this bug is now fixed.
Thank you for reaching out and providing such a detailed information on the issue. It is was super helpful and allowed us fixing the issue quickly.
We will be happy to get more feedback from you in the future.
Thanks,
Excel Team -
Demo script - return entire table content
Would be good with a demo script showing how to return an entire tables content. Assume its something like
let entireTable = workbook.getTables('Table1');
return entireTable;
Demo script could include converting data to table first, then returning entire data content.1 voteThis code below will achieve that:
function main(workbook: ExcelScript.Workbook) {
const entireTable = workbook.getTable(‘Table1’);
return entireTable.getRange().getTexts();
// Or return values
// return entireTable.getRange().getValues();
} -
Sample Script To Add New Record From Other Locations in Sheet
Sample Script To Add New Record From Other Locations in Sheet. I have a sheet used to fill out information and I want to use another sheet as a database and just add a new record to the next available Row.
1 voteThis script will allow you to add a row to a worksheet at the end:
function main(workbook: ExcelScript.Workbook) { const sheet = workbook.getWorksheet(‘Sheet2’); // SAMPLE DATA – Use 1-dimensional array to represent the row to add const dataToAdd = [‘22773342’, ‘markdown-preview’, ‘MIT License’, ‘https://api.github.com/licenses/mit’]; const startCellToUpdate = sheet.getUsedRange(true).getLastRow().getCell(0,0).getOffsetRange(1,0); console.log(startCellToUpdate.getAddress()); const targetRange = startCellToUpdate.getResizedRange(0, dataToAdd.length-1); targetRange.setValues([dataToAdd]); } -
Add Chart design feature.
Add Chart design feather on Excel for the web 365 on the Microsoft website.
11 votesHi,
We’re happy to announce that we’re currently rolling out a format task pane for charts. This enables many of the formatting actions you may be familiar with on Excel Desktop.
Once the update reaches you, it can be accessed through the “Format” button, found by right-clicking on a chart or by selecting a chart and navigating to the “Chart” tab that appears in the ribbon at the top of the screen. Thank you for your continued feedback and responses.
Thank you for your continued feedback and responses.
Thanks!
Auston [MSFT] -
Examine copy and paste function within the browser version of Office 365 Excel
Copy and paste function is so hit or miss in Office 365 Excel.
For example, formatting of tables is completely lost even when I'm copying and pasting from one tab of Office 365 Excel to another.
63 votesHappy to share with you that Copy and Paste between tabs in Excel for the web is now supported.
Thank you for voting and influencing.
You can read more about it here: https://support.office.com/en-us/article/copy-and-paste-in-office-for-the-web-682704da-8360-464c-9a26-ff44abf4c4fe#bmk-excelonline
-
right click paste options
Currently in Excel desktop when you copy something to your clipboard the right click menu includes a Paste Special drop down menu, as well as icons for paste, paste values, paste formula, etc etc
In Excel online the only way you can access Paste Special options is the long way round on the Home menu. Can the Paste Special drop down menu be added to the right click (or better still the icons)?
15 votesWe are happy to share that you can now find the ‘Paste Options’ in the right click menu.
Thank you all for voting and influencing Excel for the web!
-
Bug: Formulas not displayed in the Excel interface language
In Excel online, the formulas are not displayed in the same language that the interface is. For example, interface in English and formulas in French.
10 votesWe are happy to announce that this issue was fixed.
Thank you for voting and influencing Excel for the web priorities.Thanks,
Excel for the web team [MSFT] -
Allow the time and date to be corrected or the time zone to be adjusted in Excel Online
Not so much an idea as a fix. MS should make it so you can correct your timezone (time and date) within Office Online so time and date related formulas are correct.
68 votesHey all, we’d to share that we’ve fixed the time zone on Excel for the Web workbooks to be the time zone taken from the operating system, instead the time zone taken from the host account.
Following your feedback, we understood that the main pain is the difference between the host time zone (that was set previously for Excel for the Web) and the OS time zone (that applies for Excel desktop app).
Now, the time zone will be adjusted to be the same as in your device.This new capability is supported in SharePoint Online, OneDrive and Exchange hosts.
Thank you for voting and influencing our priorities. Keep voting for other ideas you want us to address.
Thanks, Excel team.
-
Should have vertical list of sheet's name.
When my file have many sheet. I have a horizontal list to select the sheet i need to see but is too many i must click three dots symbol to show for each until i see the sheet i need. It hard and take more time. So i suggest that we should have a vertiabe list of sheet name when right click on three dots symbol. That's all.
8 votesHi All,
Happy to announce that the new Sheets menu is now available in Excel for the web.
Thank you for voting and influencing our priorities.
Keep voting for other ideas you want us to address.Thanks,
Excel for the web Team -
cell colors in excell online
I am somtimes using excell online and find it a little annoying that I can't color cells.
11 votesHi,
You can apply a fill color to cells via the Home ribbon under Font Options. Hope this helps!
Thanks,
Auston [MSFT] -
When a document is locked (as it's being edited by another user) it would be great to know who is editing the file offline.
When a document is locked (as it's being edited by another user) it would be great to know who is editing the file offline.
213 votesCurrent versions of Excel indicate who the user is, if known, that has the file locked. Please note in the help article that Steps 3 and 4 point out that you need to use a version of Excel that supports co-authoring in addition to storing the file in a location that supports co-authoring. Please see this help article: https://support.office.com/en-us/article/Excel-file-is-locked-for-editing-by-another-user-6fa93887-2c2c-45f0-abcc-31b04aed68b3.
-
Add Image insert function into excel online, please.
Add Image insert function into excel online, please. See Google sheet does.
140 votesHappy to share that now you can insert an image from your computer in Excel Online.
Tamar [MSFT]
-
Add ability to open Online files with more than 10 MB
Add ability to open Online files with more than 10 MB and increase file size to 30-40Mb
296 votesWe are currently supporting file size upto 50MB for Sharepoint Online and 25MB for OneDrive.
Please continue to vote for your favorite features to help prioritize our investments.
Thanks & Regards,
Microsoft Excel Team. -
Spellcheck in Excel Online
Ability to do Spellcheck in Excel Online
187 votesHi,
We are happy to announce that spell check functionality is now available on Excel Web!
Thank you all for voting and influencing Excel Online priorities.
Keep voting for other ideas you want us to address.Thanks,
Excel Online Team [MSFT] -
Tab colors
Be able to change the tab colors at the bottom.
10 votesHi,
You can currently change the tab colors by right-clicking the tab at the bottom of the screen and selecting the “Tab Color” menu option. Hope this helps!
Thanks,
Auston [MSFT] -
There is no way to select non-adjacent cells as in normal Excel.
In order to tot-up figures, it is useful to be able to use Ctrl+click and select different cells. There is no functionality in Excel online to do this currently.
822 votesWe are excited to announce that it is now possible to select non-adjacent cells in Excel for the Web.
There are still several functionalities that are not available on non-adjacent cells, but the Excel team is working to add them.
Please continue to leave feedback to help us improve.
-
Need the ability to change the cell STYLE
Online versions needs to be able to change the cell style.
49 votesWe are pleased to announce that cell styles is now available in Excel for the web. Please continue to vote for your favorite features to help prioritize our investments. Thanks & Regards, Microsoft Excel Team.
-
Allow for personal user views/filters
When using Excel Online, if you add a filter, everyone using that spreadsheet in Excel Online will see that filter. Can you please add an option for only the one user to see that filter?
2,924 votesWe are excited to announce that Sheet View is now available on Excel Web!
Thank you all for voting and influencing Excel Online priorities. Keep voting for other ideas you want us to address.
Thanks,
Excel Team [MSFT] -
Find and Replace for Excel Online
Excel Online only has Find, not replace. We really need a Find and Replace function. Similar to what is available in Excel, and Word Online.
330 votesHappy to share, Excel Online now supporting improved Find dialog and Replace dialog. You are welcome to try it and provide us feedback through the service (File → Help → Provide feedback to Microsoft)
Tamar [MSFT]
- Don't see your idea?