Suppose you have a template as shown below, and you have to enter data in excel in all the cells highlighted in red, in the order specified by the arrows.
While this seems easy enough, it could be nerve-wracking when you have many such non-contiguous cells and you are burning your eyes by spotting and filing these cells one by one.
Quick Way to Entering Data in Excel in a Specific Order:
Select all the cells where you need to enter the data (press control and then select one by one). Start with the second cell in your sequence of data entry (D3 in this case). Select the first cell B3 (where data entry begins) at last Once selected, go to Name Box (which is on the left of formula bar) Type any name (I used InputRange) without spaces
That’s It!! Select the Named Range by clicking the Name Box drop-down. Now start entering your data and use Enter/Tab to jump to the next cell.
Why did we Start the Selection with the Second Cell?
When you select the first cell in the last, it becomes your active cell. Now whenever you select the named range, you can directly start typing, as the first cell would be your active cell.
Enable Data Entry only when a dependent cell is filled. Creating and Using Excel Data Entry Forms. How to Select Non-adjacent cells in Excel?
