
Not All
IT Companies
are the Same.
Get 30 Years of Expertise Immediately.
Fill in the form below and we will get to work right away.
CPU respects your privacy. We will never sell, rent or share to ANYONE. You can trust us.
Spreadsheets are an integral part of nearly every business. There is a high chance that most businesses use these more than word processors. The major Achilles heel of these programs however is that it can take a long time to set them up and populate them with data. Google Spreadsheet users have a function that can help however – Auto-fill.
Auto-fill is arguably one of the most useful features of any spreadsheet program. It helps reduce the time it takes to layout a spreadsheet, and can even help you populate it with data by simply clicking and dragging. Here’s how Auto-fill works in Google Spreadsheet.
If you do this right, you should see the dates advancing, A5 will be the date four days from now. The cool thing about Google’s auto-fill is that if it recognizes a pattern, it will fill cells in, in relation to that pattern. This function works as long as there is a pattern recognized and the original cells are beside/above each other – A2 and B2 for example. If no pattern is recognized, Auto-fill will just repeat the information.
Auto-fill options a plenty
There are a number of useful patterns that auto-fill recognizes. Say you want a list of mobile electronics manufacturers. Simply enter the names of two companies that you know e.g., Apple and Samsung, followed by selecting the two cells and clicking and dragging the blue square, and you should get a list of the major manufacturers.
Other options include different kinds of beer, car makers, cities, tech blogs, days of the week, months, years, countries, etc. This should work for almost any pattern, you should take some time to discover available patterns, who knows what you will find! If you would like to learn more about Google’s apps and how they can help make your job more efficient please contact us.
Published on 21st March 2013 by Jeanne DeWitt.