Office 2010/Excel autofill

Advertisement


Question
I'm using Office 2010 Excel and want to autocomplete a column of text but can't find on Google anything that works for me. I type into the first cell 10:51 AM and 10:52 AM in the next. I can easily autofill this down the column with the handle, but my column will have over 7000 entries - I'd be there all day doing that. How do I autocomplete the column?

Answer
Hello Leo,

Thanks for the question.

When you fill in data based on adjacent cells by dragging the fill handle in Microsoft Excel, the Auto Fill Options button is displayed just below and to the right of your filled selection. When you click the Auto Fill Options button, a list of options appears that allows you to choose to fill the cells with text or data, and whether or not to include the format of the initial selection or to copy only the format.

Good luck and happy auto filling.

Regards,


Mary Lindsey

PS:  If you would like an image of what this would look like, please send me a request at marayalindsey@gmail.com.  

Office 2010

All Answers


Answers by Expert:


Ask Experts

Volunteer


Mary A. Lindsey

Expertise

New features of Office 2010

Experience

Microsoft Certified trainer with over 20 years of experience

Organizations
ASTD, ASTE

Education/Credentials
Microsoft Office 2010 Certified instructor

©2016 About.com. All rights reserved.