[Music]
Hello, it's Matt, and welcome to Collaboration Coach.
This time I'm going to give you five tips that are going to make your life easier
when you want to make large edits to your Microsoft lists in SharePoint.
First of all, why would you want to make large edits?
Well, when you're working with a list to make a change to a row,
you have to open up the item, change the data,
wait until it saves and then close it.
An easier way to do that is to open it up in quick edit mode,
and then go to the individual cell and make the changes,
but if you have to make tens or even hundreds of edits across lots of rows
you don't want to edit each row separately.
So luckily there are a few ways you can speed up the process...
...of updating lots of rows and columns at the same time.
I've got a few tips for you here on how to do that
and all of them use quick edit.
So to start with, I'm going to open up my list here called "backlog",
and then from the ribbon on top there I'm going to choose "quick edit".
The list changes into a cell format and looks a little bit like Excel.
My first tip is for you if you want to copy the contents of your cell somewhere else in the list.
For example, if I want to change the value of these numbers so they are all 2009,
I just have to select the cell and I take my mouse pointer to the bottom right corner of the cell now -
- where this little dot is and my mouse pointer turns into a big plus
so when I do that I can now drag that cell across the other cells beneath it
or even to the left or the right
and just like in Excel it will copy the contents of that cell onto the other cells.
You can do the same thing with multiple cells from a row or column.
So now if I select multiple values from this top row
then I take my mouse to the bottom right corner again
then I can drag the selection down to the row below
and that will copy the values from the whole row into the row below
and I can do the same thing with the column.
I just need to select multiple values from a column
and drag it either left or right to copy those values from one column to another.
And I can also do this with multiple selections.
If I drag my mouse across more than one row or column
I can copy the whole selection.
By the way, if you like this video so far then please subscribe to the channel
and press the bell button.
We post twice a week.
Ok, next tip.
If you need to edit lots of rows at the same time,
you can select more than one row by taking your mouse to the far left hand side of the list...
...where these little selection dots are,
and then you drag down across all the rows you want to update.
Now you see I can choose the edit button from the ribbon above
and edit the values of more than one row at a time.
That also works for delete, so again from the left hand side...
...I can drag across multiple rows,
then choose the delete button from the ribbon above to delete more than one row at a time.
You can also paste data from apps straight into your lists using quick edit.
Here I have some data in Excel.
If I select it and copy it using control c (or command c if you're on a mac),
then I can come back to the list, scroll to the bottom,
click into a new item and then do a control v (or a command v),
and it will paste in the Excel data as new rows into my list.
This will also work from a Word table as well,
so if I go to Word, copy the cells from a table and then paste them into the list...
...I get new rows in my list.
This also works the other way around with Excel.
I can drag across the cells in my list in SharePoint,
copy them using control (or command) c,
then I can switch back to Excel and paste the cells back in using control v.
By the way, if you want to come out of quick edit you just choose "exit quick edit" at the top.
So there you go - there's five tips on how to use bulk edits to quickly update your lists.
Thanks for watching and I'll see you next time.
[Music]