Spreadsheet Autofill

If you ever have to enter long series of numbers into a spreadsheet, don't waste your time typing all of the values. Instead, enter in the first few values and then let your spreadsheet application input the rest. Here's how:
  1. Enter in the first few values in your series (e.g. 1, 2, 3)
  2. Select all the values
  3. Click & Drag the lower-right corner across as many cells as you need to fill.
This technique works in most spreadsheet applications, including: Microsoft Office Excel, OpenOffice, Google Docs, and Zoho Sheet.

No comments:

Post a Comment