Calc Basics: Never Type When You Can Drag
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.