Keystroke to increment Excel cell by fixed value? - TechRepublic
Question
February 26, 2008 at 08:25 AM
charliespencer

Keystroke to increment Excel cell by fixed value?

by charliespencer . Updated 14 years, 11 months ago

Is there a keystroke to increase an Excel cell by a fixed amount?

I have a spreadsheet where I track the number of times a NASCAR driver has been selected by each of several fantasy team owners. If a cell has the value of ‘2’, indicating an owner has used that driver twice, is there a single keystroke to add 1 to the existing value?

I’m trying to eliminate data entry, since the number entered in each cell will vary but is always 1 more than the existing value. A keystroke shortcut would allow me to use the same key repeatedly to increment ‘2’ to ‘3’, ‘4’ to ‘5’, etc. while reducing the chance that I enter the wrong number.

This discussion is locked

All Comments