Have you ever experienced data entry in a workbook that jumps around the place, or you want users to enter data in a specific order?. Excel CAN force the sequence of cells that you want users to select.
This solution relies on defining a named range which essentially is a sequence of cells that you specify.
See below as an example of the sequence of cells that I want users to type into Excel.
So let’s give this a go.
- Click in the cell that is second in your required sequence
- Hold down the CTRL key and click the cell sequence 3, carry on and select the cells in the correct order
- When you have reached your last cell in the sequence, click the first cell in the sequence
- Click the cursor into the Name Box (the area to the left of the bar that shows the cells addresses)
- Name this area of cells, i.e a named range in this example I am using MyDataSequence – then hit Enter and the name box will return to showing a normal cell reference
- Save your file
- When you need to get a user to enter data into Excel in that order just select your named range MyDataSequence.
- Begin typing and press enter
- Excel will jump to the next cell sequence ready for data entry
- Formula Tab
- Defined Names
- Name Manager
So, as you can see the named range is just a sequence of cells, that we selected earlier in the exercise. Give it a go.