'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Edit a SharePoint Choice Field Without Opening an Item
Question details
The user needs to change the value of a Choice column directly from the list view without opening the full details pane for each item.
- Product
- SharePoint Online
- Device & OS
- not provided
- Scenario
- Updating multiple Choice field values quickly in a standard SharePoint list.
- Observed behavior
- SharePoint Online's standard list view does not allow users to modify a Choice field simply by clicking its choice pill.
Ensure you have at least 'Edit' permissions for the SharePoint list and that your view is not grouped by the choice column you intend to modify.
Use Edit in Grid View to Modify Choice Fields
Switching to Grid view allows you to edit list items directly in a spreadsheet-like interface, making it easy to change Choice fields without opening each item.
The 'Edit in grid view' feature (formerly known as Quick Edit) is the most efficient native method in SharePoint Online for making rapid, inline modifications to list columns, including drop-down Choice fields.
Navigate to the SharePoint site and open the specific list containing the Choice field you want to modify.
Click the 'Edit in grid view' button located in the command bar at the top left of the list view.
Click directly on the cell under the Choice column for the specific item you want to edit.
Click the drop-down arrow that appears in the cell and select the new value for your Choice field.
Once you have finished updating the fields, click 'Exit grid view' in the top command bar to save all modifications.
Need a Lightweight Office Suite for Your Downloaded SharePoint Files?
While SharePoint manages your lists and cloud storage, you still need a reliable office suite to open, edit, and create the documents stored within them. WPS Office is a completely free, highly compatible alternative to Microsoft Office that provides everything you need in one application.
- 1. Download the Installer: Visit the official WPS Office website and click the free download button.
- 2. Install the Software: Run the downloaded executable file and follow the quick on-screen instructions.
- 3. Open Your Files: Launch WPS Office and directly open your downloaded SharePoint documents to start editing.
Frequently Asked Questions
Why is the 'Edit in grid view' button missing in my SharePoint list?
The feature might be disabled in your list settings. To fix this, go to the gear icon > List settings > Advanced settings. Scroll down to 'Quick property editing' and ensure it is set to 'Yes'.
Can I edit a Choice field if the SharePoint list is grouped by that column?
No, SharePoint grid view has limitations when a list view is grouped. You will need to switch to a standard ungrouped view to enable 'Edit in grid view' and modify the fields.
Do I need special permissions to use grid view in SharePoint?
Yes, you must have at least 'Contribute' or 'Edit' permissions on the SharePoint list. If you only have 'Read' permissions, the 'Edit in grid view' button will not be available or will be greyed out.
