MS Excel Data Forms 2007/2010
HOME If your spreadsheet is too big to manage, and you constantly have to scroll back and forth just to enter data, then a Data Form could make your life easier. To see what a Data Form is, we will contruct a simple spreadsheet. But a data form is just a way quick to enter data into a cell. It is used when the spreadsheet is too big for the screen. To get a clearer idea of what data form is, try this. 1. Enter January in Cell A1 of a new spreadsheet. 2. From A1 to L2, AutoFill the rest of the months to December. 3. Now, highlight the columns A1 to L1 (click on the letter A and drag to letter L). 4. On the Home tab in Excel, locate the Cells panel. 5. On the Cells panel, click the Format item. (In Excel 2013, you will see a menu when you click Format. From the menu, select Column Width . 6. From the Format menu, click Width. 7. Enter a value of say 20 for the column w...