any one help me....i need data entry in specify cell and according to order...like
when i press TAB select A1 then TAB C1 then TAB D2..
any one help me....i need data entry in specify cell and according to order...like
when i press TAB select A1 then TAB C1 then TAB D2..
Not sure exactly what you are looking for but this might help.
Select the cells where you want data entered (A1, C1, D2, etc), right click to menu > Format cells
Go to the Protection Tab on the Format Cells Window and uncheck “Locked”> “Okay”
Now protect the worksheet. Review Tab> “Protect Sheet”
You can uncheck “Select Locked Cells” to prevent anyone from selecting anything but the ones you chose in step 2 above.
If you do not uncheck that, users can still only enter into the cells you chose.
If you need still more control, you can add data validation to cells to force an order. How many cells are we talking about or does it follow a specific order?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks