If you are wanting to increment the same amount over a range, the easiest way to do this is use paste special. You can add, subtract, multiply, and divide.
1. Find an empty cell, enter the amount you want to change, hit enter, and then copy the cell using ctrl-v or copy from the menu bar.
2...