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
-
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]); } -
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 -
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 -
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
-
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] -
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!
-
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] -
Excel online- More Colors!
More colors and more themes. Please!
738 votesHi,
We are pleased to announce that we have released the support for More Colors in Excel on web. Please continue to vote for your favorite features to help us prioritize our investments. Thanks & Regards, Microsoft Excel Team -
when someone has locked the excel, pls tell us me who locked the excel.
when someone has locked the excel, pls tell us me who locked the excel.
82 votesExcel Online now provides the information who has the file lock. Other related issues like the option to release the lock are under investigation.
Tamar [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.
-
make to move copy sheet like excel destop
make program move copy sheet like excel desktop,because diffuclt want copy n paste
2 votesWe are excited to announce that it is now possible to Duplicate worksheets in Excel Online.
There are still cases where Excel Online will be unable to duplicate a worksheet. Most notably, in case either one of the following is present in the worksheet:
- Images
- Shapes
- Charts
Excel Online team is working to resolve these limitations.
Please continue to leave feedback on the feature, to help us improve. -
1 vote
We are excited to announce that it is now possible to Duplicate worksheets in Excel Online.
There are still cases where Excel Online will be unable to duplicate a worksheet. Most notably, in case either one of the following is present in the worksheet:
- Images
- Shapes
- Charts
Excel Online team is working to resolve these limitations.
Please continue to leave feedback on the feature, to help us improve. -
Pivot
It would be great if PivotTable is also included online especially if you have things to modify in the table.
7 votesInserting new Pivot Tables in Excel Online is now possible. It is also possible to edit existing Pivot Tables in Excel Online workbooks.
-
Excel survey with automatic timestamp on each record
When you get many responses it often is very important to understand WHEN a certain respons was submitted. For exampel if the same respondent has submitted multiple times and you want to sort out the last one of them....
Add feature that automaically add a timestamp on each record.3 votesWe update the experience of Excel Survey with a new experience. Excel Survey will be powered by Microsoft Forms and will be renamed “Forms for Excel”. This update comes with a modern experience to make it simple and easy to collect information into Excel in real-time, with all Microsoft Forms features. You could get more detail form – https://aka.ms/formsforexcel
Zhongzhong [MSFT]
-
Please add functionality so that I can duplicate in Excel online
Why can't you duplicate a sheet inside of a workbook? Its so simple! Its dumb that its not already a feature. Please add this functionality.
1 voteWe are excited to announce that it is now possible to Duplicate worksheets in Excel Online.
There are still cases where Excel Online will be unable to duplicate a worksheet. Most notably, in case either one of the following is present in the worksheet:
- Images
- Shapes
- Charts
Excel Online team is working to resolve these limitations.
Please continue to leave feedback on the feature, to help us improve. -
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] -
Excel Survey Improvements: Multi-Select for more than 2 items
I need to be able to allow users to select more than 2 options. If you can't allow this can you add a custom checkbox option?
2 votes
- Don't see your idea?