Excel Fill Handle

3/20/2018

Excel has built-in lists of data that you can enter by using the fill handle. When you hesitate your mouse on the bottom right corner of the active cell, you will see a black t, this is the fill handle. The custom lists included with Excel are; days of the week, months and quarters. You can also use these custom lists to sort data and you can create your own custom lists. Here is an example of how to enter data from a custom list: Type in Monday then use the fill handle to drag down or across cells. As you move across cells it will fill in Tuesday, Wednesday, Thursday, Friday, etc. as you continue dragging. You can also use the auto fill to enter a list of numbers. If you want to create a numbered list you need to enter the first 2 numbers, select the 2 cells then use the fill handle to click and drag.

0 Comments

Computer tips that will increase productivity and your overall computer experience.

These helpful tips can make a big difference in your workflow—and save you tons of time in the process.
You may be wondering whether shortcuts really help…they do. If you become proficient with 3 or 4 common shortcuts, you will save time.
New tips added weekly

Author

With over 25 years in the computer industry, JoLynn Rihn has been helping people to become more efficient and effective with their computer software. She offers tips on using the latest programs so that using a computer can be more easy and fun to use.