Feedback by UserVoice

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

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    This 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();
    }

  2. 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 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    This 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]); }
  3. 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-a1dd627b7773

    sample : <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 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
    completed  ·  excelonlineteam responded

    I 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

  4. 22 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks 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

  5. Add Chart design feature.

    Add Chart design feather on Excel for the web 365 on the Microsoft website.

    11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    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]

  6. 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 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    completed  ·  excelonlineteam responded

    We 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]

  8. 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 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →

    Hi 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

  10. cell colors in excell online

    I am somtimes using excell online and find it a little annoying that I can't color cells.

    11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  11. Excel online- More Colors!

    More colors and more themes. Please!

    738 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    132 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,
    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

  12. 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 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    14 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
    completed  ·  excelonlineteam responded

    Excel 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]

  13. 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 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    38 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

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

  14. make to move copy sheet like excel destop

    make program move copy sheet like excel desktop,because diffuclt want copy n paste

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
    completed  ·  excelonlineteam responded

    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.

  15. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
    completed  ·  excelonlineteam responded

    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.

  16. Pivot

    It would be great if PivotTable is also included online especially if you have things to modify in the table.

    7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    completed  ·  excelonlineteam responded

    Inserting new Pivot Tables in Excel Online is now possible. It is also possible to edit existing Pivot Tables in Excel Online workbooks.

  17. 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 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Surveys  ·  Flag idea as inappropriate…  ·  Admin →

    We 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]

  18. 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 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
    completed  ·  excelonlineteam responded

    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.

  19. Tab colors

    Be able to change the tab colors at the bottom.

    10 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  0 comments  ·  Surveys  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 6
  • Don't see your idea?

Feedback and Knowledge Base