Discover how you can quickly creat a simple user data entry tool in Excel. br br These are the keys highlghted on the video. br br Enable Developer Ribbon br 1) Right-click anywhere in the ribbon br 2) Customized the Ribbon... br 3) Check on Developer br 4) OK br br Add Record br 1) Developer ~ CODE ~ Record Macro br 2) Assign macro a name, & click on OK br 3) Select first row. br 4) Add a row using Ctrl + Shift + + (plus) br 5) Shift cells down br 6) OK br 7) Select user entry data cells. br 8) Ctrl + C br 9) Right-click on cell A10, & select Transpose. br 10) Highlight Row 11 data. br 11) Home ~ Clipboard - Format Painter br 12) Click on cell A10 br 13) Stop macro recording br 14) Developer ~ Insert ~ Button br 15) Assign newly created Macro.