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:
- Enter in the first few values in your series (e.g. 1, 2, 3)
- Select all the values
- 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