Overcoming common problems - Data Entry
Entering data in rows & column can be pretty tedious especially when you have wide columns and the great number of columns. Excel has a data form feature that makes data entry a breeze. Select any part of your table and Click on Data > Form. A userform would appear and data entry can be input into your spreadsheet via this form. If there are formulas, it would be greyed out. The formula would automatically copied for the new record.