You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.

Generating these ID numbers automatically will save you from having to waste time typing them manually, remove the possibility of error, and keep your spreadsheet tidy.

How to Make Excel Continue to Count Up for Each Row. Entering a series of sequential numbers into an Excel spreadsheet, one per row, can be a time-consuming and repetitive task.