Get a FREE 2.4 hour Excel 2019 Beginners course here ►https://simonsezit.lpages.co/excel-2019-beginner-course-ssit/
During this Microsoft Excel 2016 training tutorial video, we will demonstrate the different ways you can use the Fill feature in Excel. You can fill cells with a series by using the fill handle You will learn how to work with the fill handle, fill dropdown, and series dialog.
Checkout some of our other training on YouTube:
VBA for Excel tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ
Excel 2016 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jUeMoLReqNzzuKj7rdLhZ2
Excel 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jVfCjoptJb_mimawnVezqh
Access 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gbtcZ9Z3kbhk-2v65bfGeX
Project 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i1QJ6-Z91KRjFg5dzacD1O
Visio 2013 for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jpAwkTGD6hGNxF8ML_FfsF
SharePoint 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jloGuvewOe0Iv1EE2POKge
PowerPoint 2013 training for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gX0kiJc3k8d31y0zTLcECq
Stay in touch:
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Facebook: https://www.facebook.com/SimonSezIT/
If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)
Hello again and welcome back to our course on Excel 2016.
We’ve already looked at filling a series of cells a couple times already in the course. We looked particularly at filling a series with the months of the year. But in fact many times when you’re working with Excel you’ll find that the data follows one or more distinct patterns.
Now let me just quickly do again something we’ve done a couple of times already. I’m just going to type January in that cell and this little block, this little icon, the bottom right hand corner of the board here it’s called the Fill Handle. And if I pull the Fill Handle across, let’s just go to there say. You’ve already seen that you get the months of the year. Let me just Undo that, go back to just having January. But this time instead of pulling across with that Fill Handle what I’m going to do is to select the cells up to R4. So I’m going to hold the Shift key down, press R4 and all the cells between G4 and R4 are selected. Now what I’m going to do is I’m going to go the Fill dropdown in the Editing Group on the Home Tab and I’m going to select Fill Right. And what happens this time instead of getting the months of the year is that I get the same cell content, in this case the word January, in each of those cells. So that isn’t a Series Fill that we refer to. It’s really just a Fill, a Fill Right. Now let me Undo that yet again.
There is a Keyboard Shortcut for Fill Right that you’ll probably find yourself using quite a bit. It’s Control-R. Let me do Control-R here and that gives you a straightforward way of doing a right fill. But in that case what you’re doing is effectively copying the contents of one cell into a number of other cells.
Let me just go back. Let me Undo that yet again and I’m going to type February in H4. Again I’m going to select G4, put the Shift key down. Now I’m going to do my right fill again, Control-R. What do you think is going to happen? That’s right. You still get January in every cell because basically with my left most cell selected I select the range of cells I want to fill and basically it goes left to right filling those cells.
Now similarly if I were to hold the Shift key down and click in G14 I could do a Fill Down which is Control-D or let me just Undo that, click in G4 again, use the Fill Handle to drag down and I get my sequence of months again.
Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.