In this tutorial you will learn to use one of the most popular functions in Excel: Autofill. Autofill allows Excel to analyze and identify a series of numbers or items, and continue automatically said order in a given range of cells.
Don't forget to check out our site http://howtech.tv/ for more free how-to videos!
/ ithowtovids - our feed
/ howtechtv - join us on facebook
https://plus.google.com/1034403827176... - our group in Google+
Also check an iPhone version:
• How to Autofill in Excel for iPhone
Step # 1 – Introducing initial data
The first step is writing the first few items you would like to serve as the seed for the Autofill process. Excel will complete the series based on this initial data. Once you are finished, tap the first cell and drag the range using the green circles in the corner. You will notice that a pop-up menu will automatically appear:
Step # 2 – Using the Autofill option
Next, you will have to press the option “Fill”. You will notice that after doing this, the shape of the green square will change, featuring now small white arrows inside circles:
Finally, drag the arrows in the direction you would like to fill automatically with the rest of the series:
Excel will continue automatically with the original logic of the items; using the same format you used when introducing the initial data.
Смотрите видео How to Autofill in Excel for iPad онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь iPhone, iPad and Android Tutorials from HowTech 21 Октябрь 2015, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 71,322 раз и оно понравилось 365 людям.