1 00:00:04,040 --> 00:00:05,380 [Autogenerated] high in this lesson. I'm 2 00:00:05,380 --> 00:00:08,030 gonna show you how to use quick edit in a 3 00:00:08,030 --> 00:00:10,540 SharePoint list. We're here in our 4 00:00:10,540 --> 00:00:13,880 employee list on our HR team site and you 5 00:00:13,880 --> 00:00:15,810 see here at the top we have a big button 6 00:00:15,810 --> 00:00:18,520 that says, Quick edit. What does that 7 00:00:18,520 --> 00:00:20,680 mean? What does that do? What can that do 8 00:00:20,680 --> 00:00:22,850 for us? Well, let's go ahead and check it 9 00:00:22,850 --> 00:00:25,310 out. We're gonna click on that quick edit. 10 00:00:25,310 --> 00:00:26,910 It's gonna take a little bit of time for 11 00:00:26,910 --> 00:00:28,930 it to do its thing home. That was pretty 12 00:00:28,930 --> 00:00:32,190 fast. But see, look what happened Now. Our 13 00:00:32,190 --> 00:00:34,560 list really looks like an Excel workbook, 14 00:00:34,560 --> 00:00:36,960 doesn't it? And you see, first thing you 15 00:00:36,960 --> 00:00:39,040 notice when you scroll down is it's only 16 00:00:39,040 --> 00:00:41,700 showing us 30 records, and we have a 17 00:00:41,700 --> 00:00:43,990 narrow, so we would have to click and get 18 00:00:43,990 --> 00:00:46,150 to the next page. But that's okay. You can 19 00:00:46,150 --> 00:00:48,280 change that in the settings, but for now, 20 00:00:48,280 --> 00:00:52,260 this is fun. Now, when we have this, the 21 00:00:52,260 --> 00:00:55,760 entire list is open for editing. Let's go 22 00:00:55,760 --> 00:00:58,540 ahead and let's say that Ah, let's find 23 00:00:58,540 --> 00:01:00,910 somebody. Let's say that Frank is no 24 00:01:00,910 --> 00:01:04,700 longer cashier. He has gone ahead and 25 00:01:04,700 --> 00:01:07,490 joined the customer service department So 26 00:01:07,490 --> 00:01:14,260 I am going to simply type in here. And 27 00:01:14,260 --> 00:01:16,390 when I hit enter, the change has been 28 00:01:16,390 --> 00:01:18,500 made. And if I look and say Oh, look at 29 00:01:18,500 --> 00:01:20,700 that. I made a mistake. I did want to 30 00:01:20,700 --> 00:01:22,830 capitalize that. Of course I can go back 31 00:01:22,830 --> 00:01:28,340 in. I don't have to open this record in 32 00:01:28,340 --> 00:01:31,500 change it. This is a great thing. If you 33 00:01:31,500 --> 00:01:33,870 have to do a lot of changes at the same 34 00:01:33,870 --> 00:01:37,100 time. And just, like, excel, you can do 35 00:01:37,100 --> 00:01:39,770 things like auto fill. So let me show you. 36 00:01:39,770 --> 00:01:42,010 I'm gonna go ahead and I'm gonna just I'm 37 00:01:42,010 --> 00:01:45,110 using my delete key. In case you I didn't 38 00:01:45,110 --> 00:01:46,980 realize that I'm gonna delete a bunch of 39 00:01:46,980 --> 00:01:49,020 these location numbers. They're all the 40 00:01:49,020 --> 00:01:51,790 same and watch what happens. I'm going to 41 00:01:51,790 --> 00:01:53,940 go to the top one. We're gonna grab my 42 00:01:53,940 --> 00:01:55,380 little Phil handle here. You see this 43 00:01:55,380 --> 00:01:57,690 little square in the lower right corner 44 00:01:57,690 --> 00:02:00,260 when I get my mouse pointer up there so it 45 00:02:00,260 --> 00:02:02,450 looks like that cross hair hold down my 46 00:02:02,450 --> 00:02:06,470 left mouse button and dragged down. Look 47 00:02:06,470 --> 00:02:12,530 at that. Just like you can do in excel. So 48 00:02:12,530 --> 00:02:16,180 this is a great way to work with a list if 49 00:02:16,180 --> 00:02:18,360 you have to make a lot of changes. We 50 00:02:18,360 --> 00:02:20,080 scroll down to the bottom and we even see 51 00:02:20,080 --> 00:02:21,880 a blank road. This is going to give us a 52 00:02:21,880 --> 00:02:27,740 place to go ahead and add on another 53 00:02:27,740 --> 00:02:34,520 record. In my case, I'm going to add a 54 00:02:34,520 --> 00:02:39,550 record for Gary Coulson, who actually 55 00:02:39,550 --> 00:02:43,300 doesn't exist as an employee right now 56 00:02:43,300 --> 00:02:46,450 because he's not on our official employee 57 00:02:46,450 --> 00:02:49,200 list. Well, I took care of that notice 58 00:02:49,200 --> 00:02:51,590 with dates. I even have a calendar picker, 59 00:02:51,590 --> 00:02:53,770 which I could choose, but well, what that? 60 00:02:53,770 --> 00:02:57,660 Let's say that Gary just started a few 61 00:02:57,660 --> 00:03:06,110 weeks ago. He's in HR and let's give him a 62 00:03:06,110 --> 00:03:13,820 number. Put him in the same area and will 63 00:03:13,820 --> 00:03:19,650 give Gary Let's give Gerry $32 an hour. 64 00:03:19,650 --> 00:03:23,380 Whatever. And when you're done editing, 65 00:03:23,380 --> 00:03:25,840 all you have to do is click on exit Quick 66 00:03:25,840 --> 00:03:29,740 at it. All your changes have been saved. 67 00:03:29,740 --> 00:03:34,350 Spaniard list is back to normal. Pretty 68 00:03:34,350 --> 00:03:36,210 cool. I like quick at it. It's a really, 69 00:03:36,210 --> 00:03:38,510 really nice feature again. Like I said, if 70 00:03:38,510 --> 00:03:40,370 you've got to make a lot of changes to a 71 00:03:40,370 --> 00:03:42,940 list, just open it up with quick at it and 72 00:03:42,940 --> 00:03:46,520 have at it. So now you know how to use 73 00:03:46,520 --> 00:03:57,000 quick at it in a SharePoint list. Thanks for listening, and I'll see you next time