'%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 Restore SharePoint Edit in Grid View Button
Question details
The user wants to restore the 'Edit in grid view' button to the main SharePoint toolbar after it was moved to the three-dot overflow menu.
- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Customizing the SharePoint document library toolbar to improve workflow efficiency and quick access to grid editing.
- Observed behavior
- The 'Edit in grid view' command is hidden inside the three-dot menu instead of being immediately visible on the main toolbar.
Ensure you have the necessary 'Edit' permissions to modify views in the SharePoint document library and have basic familiarity with JSON formatting.
Use View-Formatting JSON to Reposition the Button
Apply a custom JSON script in the Advanced mode to move the 'Edit in grid view' command back to the Primary section of the toolbar.
Since SharePoint does not provide a native drag-and-drop feature to customize this specific toolbar button, you must use view-formatting JSON to override the default layout.
Click on the view menu (usually displaying 'All Documents' in the top right corner of your document library), and select 'Format current view'.
At the bottom of the formatting pane, click on 'Advanced mode' to input custom code.
Input the JSON code that targets the command bar, placing the 'editInGridView' command in the 'Primary' section and setting its 'hide' attribute to 'false'. Save your changes.
Edit Downloaded Documents Seamlessly with WPS Office
While SharePoint handles your cloud document storage, WPS Office offers a free, lightweight, and fast alternative for editing your downloaded Word, Excel, and PowerPoint files locally with maximum format compatibility.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install the Software: Run the downloaded installer and follow the on-screen prompts to set up WPS Office on your device.
- 3. Open Your Documents: Launch WPS Office and seamlessly open any documents downloaded from SharePoint for immediate offline editing.
Frequently Asked Questions
Can I drag and drop the 'Edit in grid view' button back to the main toolbar?
No, SharePoint currently does not support drag-and-drop customization for the command toolbar. You must use view-formatting JSON to rearrange the commands.
Do I need admin rights to use JSON formatting in SharePoint?
You need at least 'Edit' permissions on the specific document library to change the view formatting and save it for all users accessing that view.
Will this JSON customization affect other document libraries?
No, view formatting is applied strictly to the specific view of the document library where you added the JSON code. Other libraries and views will remain unchanged.
