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
-
Enable Forms in Excel
Forms are not enabled with Excel enterprise version
I understand that it is available only with the School version
With forms its very easy to collect data, especially for surveys.
2 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
It would be great if you could provide feedback for us – https://aka.ms/excelsurveyfeedback
Zhongzhong [MSFT]
-
2 votes
-
Checkbox as a question option
I would like a question where people can select more than one option in their answer
2 votes -
Ensure submit is not activated by pressing enter
Many users tend to press enter to go to a new line and then pressing it automatically submits their survey answers even if they aren't finished filling it out. The survey should only be submitted by clicking on a dedicated Submit button.
2 votes -
Command + Shift + Arrow Keys to Select Cells (Keyboard Shortcut Enhancement)
In the desktop Excel app, users can use Command + Shift + up/down arrow keys to quickly select a set of cells without having to manually drag the mouse to select all of them. Please bring this keyboard shortcut to the Excel Online app as well!
2 votesThank you for voting.
Tamar[MSFT]
-
Print the Survey results
Give the option to send the results to a printer
2 votes -
Allow find down to be found on search as find next or...
Given the differences between excel online and the desktop app, i would suggest that things such as Find next be a bit more visible as options, or at least make a link to the keyboard shortcuts more visible.
2 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]
-
Find exact match
Find an exact match as entered option of exact match on or off all the time
2 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]
-
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]); } -
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. -
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. -
Excel survey needs to capture email address/user name for respondant
There doesn't appear to be a way to automatically capture the user name/email address of the respondent to an Excel O365 survey. This means I am having to create an extra question filled with people's names to capture this information which reduces the value of the survey.
1 vote -
I would like to restrict the survey participants to answer only once in excel survey.
I would like to restrict the survey participants to answer only once in excel survey.
1 vote -
Improve find functionality
Functionality is very limited in browser. Can't search entire workbook or find all
1 voteHappy 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]
-
Excel online survey form for mobile
If the answer can only be a date then make a calendar appear to make it easier to select your answer. Having to use a virtual keyboard to type out a date is pretty troublesome especially for people who are accustomed to different date formats.
1 vote -
Being able to include a survey in a frame within a sharepoint page
not able to include as a frame within a webpage.. I find miccrsoft has many features but no always we are able to use them
1 vote -
Comment section
Hi
I would like a return facility in the comment box which isn't there at the moment for larger commentsAlso it would be better to have only one comment visible when I click on the comment box rather than all the comments boxes being visible at the same time
1 voteThanks for posting. This is a bug we found and have fixed internally. It is in the process of rolling out through rings of validation and should be in production in the next week or two.
Cheers,
Dan [MS] -
hope find function can find by sheet
hope find function can find by sheet
1 voteHappy 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]
-
be able to change font in Excel
i want to make the font bigger for science fair
1 voteHi,
You can already set the font, and font size in Excel Online – you’ll find the controls on the Home tab of the Ribbon (make sure you are in Edit mode by logging in and clicking “Edit in Excel Online”
Cheers,
Dan [MS]
- Don't see your idea?