How To Use AutoFill on a Google Docs Spreadsheet [Quick Tips]
- by The Geek
Have you ever wanted to fill an entire row or column with a series of values? If you’re an Excel user, you can do the same thing in Google Docs. If you haven’t used either, here’s the quick way to do it.
Just type in a couple of numbers in sequence… 1 2 3 works pretty well. You could also put them across a row instead of down a column.
Then move your mouse over the dot in the corner until the pointer changes, then just drag it downward (or if you are filling a row instead, you can drag it to the right).
Let go of the mouse, and your data will be automatically filled in.
You could also make it skip by 1 instead, like 2 4 6 8, etc…
It all works the same way. Sadly there’s no really advanced options like Excel has, but for most uses, this is good enough. Also, we’re aware this is a very simple tip for most of you, but we’re trying to help the beginners out as well!
Similar Articles
Productive Geek Tips
Integrate Google Docs with Outlook the Easy WayHow To Export Documents from Google Docs to Your ComputerHow To Monitor Sites Without an RSS Feed Using FirefoxGeek Software: Use DeliCount to Get Site-wide del.icio.us Bookmark CountsMake Excel 2007 Read Spreadsheets To You
TouchFreeze Alternative in AutoHotkey
The Icy Undertow Desktop
Windows Home Server – Backup to LAN
The Clear & Clean Desktop
Use This Bookmarklet to Easily Get Albums
Use AutoHotkey to Assign a Hotkey to a Specific Window
Latest Software Reviews
Tinyhacker Random Tips
DVDFab 6
Revo Uninstaller Pro
Registry Mechanic 9 for Windows
PC Tools Internet Security Suite 2010
Combine MP3 Files Easily
QuicklyCode Provides Cheatsheets & Other Programming Stuff
Download Free MP3s from Amazon
Awe inspiring, inter-galactic theme (Win 7)
Case Study – How to Optimize Popular Wordpress Sites
Restore Hidden Updates in Windows 7 & Vista