Simple data entry form above the targeted columns.

I want to enter data in C4 / D4 / E4 / F4
BTW I'm using excel 2013, and you lost me here: "C4:G10 Form C4"

Originally Posted by kvsrinivasamurthy

First set the selection move to right when Enter key is pressed.

If you want to enter data from C4 to G10, Select the range C4:G10 Form C4.
Now C4 is active. after typing data press 'Enter'.Now D4 will activate.Continue.
after Typing data in G4,Press 'Enter' Key.Now C5 is activated.