Click the worksheet tab at the bottom of the Excel program window where the cell you want to reference is located. Click to a different cell, then click back to B2. In cell F2, we’ll type =B2+1: After hitting Enter, the result is 2. Defining a cell name: Select the cell that you wish to name. To find the first name, we start reading at the left of the cell, and stop right before the first space.How to name a cell in excel Excel is adding the 1 from cell B2 and the 1 we added in the formula.
