| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 38361 | 2003-10-05 00:37:00 | Excel | Peter H (220) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 180487 | 2003-10-05 00:37:00 | In theory easy, but I can't figure how. I need to add 1 to every number in a column. People age. Bye |
Peter H (220) | ||
| 180488 | 2003-10-05 00:48:00 | Put "1" in a spare cell somewhere. Select it, and "copy" Highlight the entire range of cells you want incremented. Select "Edit" - "Paste Special" - Add This will increment every cell in the highlighted range by 1. Including empty cells. |
godfather (25) | ||
| 180489 | 2003-10-05 01:21:00 | Thanks GF. Knew there had to be an easy way. Bye |
Peter H (220) | ||
| 1 | |||||