Options have disappeared in Excel 2007 and Excel 2010. In the version of Excel 2007 we have, Data Forms have been hidden. You then enter data in the form to completeĪ row on your spreadsheet. And then scroll back again to start a new row. Some of your months should disappear from the spreadsheetThe problem is, if you have to enter data under each month, you'd have to scrollĪcross to complete the row.Enter a value of say 20 for the Column Width, and click OK.On the Cells panel, click the Format item.On the Home tab in Excel, locate the Cells panel.Now, highlight the columns A1 to L1 (click on the letter A and drag to letter L).From A1 to L1, AutoFill the rest of the months to December. Enter January in Cell A1 of a new spreadsheet. It is used when the spreadsheet is too big for the screen. To see what a Data Form is, we'll construct a simple spreadsheet.īut a data form is just a way to quickly enter data into a cell. To scroll back and forward just to enter data, then a Data Form could make your If your spreadsheet is too big to manage, and you constantly have
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |