Calc Basics: Never Type When You Can Drag

Filed under

If you're new to spreadsheets, or want to make sure you're working as efficiently as possible, this post is for you. Whenever you have a lot of similar entries to make, think drag.

Here's an example.

You've got these budget figures for 2006. The 2007 budget figures are going to be 15% more. So you create a formula for cell C2 multiplying B2 by 1.15 to get the correct figure for C2.

More Here.