You have a SharePoint list with hundreds of items in it, now you need to edit one column for the entire list. Your toolbar once had an option for edit, which in the SharePoint list means "bulk edit."
Now, the only item on your toolbar is "+ new task."
Ever heard of "Tabular View"? Maybe you have seen this option when setting up different list views in the view settings:
The Tabular View option controls the ability to bulk edit.
The Tabular View option is not universal for all of your views, but only for the view where it is selected. For example, you may have the following views:
If you have the Tabular View checked for the "Upcoming" view, but not on the "Summary" view you will be able to bulk edit the "Upcoming" view, but not the "Summary" view.
Additionally, the Tabular View does not impact the Calendar and Gantt Chart views since those views are controlled by the list views. You do not the ability to bulk edit those particular views.
At a glance, here's how to determine if the Tabular View is selected, you will see a checkbox column as your first column and the edit option is available.
Notice below that a checkbox column has been added. Also, notice that you have the option to "edit this list."
Notice below that the checkbox column is no longer available and you no longer have the option to edit. You only have the option to add a new task.
If you are still unsure if the Tabular View is checked, navigate to the view settings.
When edit is selected, your list will look very similar to an Excel document. You will be able to move from cell to cell by clicking tab or directly inside different cells. Your toolbar will only have one option while in edit mode, "Stop editing this list".
Notice how the list changed to be similar to an Excel document and is a similar concept for navigating, copy paste, and drag options within a column. Once you are finished with the bulk edit, make sure to click "Stop editing this list" to save your work.
If you were convinced that Microsoft removed your ability to bulk edit, now you know Microsoft gives you the ability to have a choice based on the view. Share this tip with other SharePoint Power Users.
Have more questions about SharePoint? Need help launching a new MS Teams site? Download our Microsoft Teams Deployment and Government Guide.
For more insights, give our team at C5insight a call today at: 704-895-2500.
The complementary paper includes over 12 years of research, recent survey results, and CRM turnaround success stories.
This 60-second assessment is designed to evaluate your organization's collaboration readiness.
Learn how you rank compared to organizations typically in years 1 to 5 of implementation - and which areas to focus on to improve.
This is a sandbox solution which can be activated per site collection to allow you to easily collect feedback from users into a custom Feedback list.
Whether you are upgrading to SharePoint Online, 2010, 2013 or the latest 2016, this checklist contains everything you need to know for a successful transition.