Affinity Consulting Blog

How do you fill in data automatically in Microsoft Excel?

Microsoft Excel features many different time saving tricks. One of the best and often overlooked tricks in Microsoft Excel is the "AutoFill" feature.

AutoFill is great for typing a series of repetitive lists like dates (6/1/16, 6/2/16, 6/3/16). Start the series and move the cursor on the screen to the lower right part of the last cell—the fill handle. When it turns into a plus sign +, click and drag down to select all the cells you need to fill. The cells will fill in the pattern you started. This can also go up a column, or left nad right on a row as well.

You can AutoFill without much of a pattern as well. Again, pick a cell or cells, move to the fill handle, click, and drag. You'll get a menu of options. The more data you input at first, the better the AutoFill options.

Let's Get Started Today

with a plan that's right for your practice.

Let Us Teach You

Take advantage of our blog resources, sign up for our law office technology white papers, take a course from Affinity University, Attend all of our Live Events.

Start Now

Hire Us To Do It For You

Hire Affinity Consulting Group to make your law office run more efficiently than ever… We can deliver the hardware, the software, and the training that is perfect to make your law office more efficient.

Start Now

Work With Us

We can give you expert guidance, helping you make smart choices for your law firm. We can help you analyze your current situation and make suggestions that will point you in the right direction.

Start Now

Sign up for our newsletter and

keep your law office efficient.

Join over 4,000 successful law firms who receive our newsletter today.


Read Our Previous Newsletters