Not Enough Coffee
Musings from a library-addicted technology geek
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:
Screencast via ScreenToaster
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.
Post a Comment
Post Comments (Atom)