![]() ![]() Any data that you have typed in the fields is discarded. Note: Before you press Enter, you can undo any changes by clicking Restore in the data form. If a cell contains a formula, the formula result is displayed in the data form, but you cannot change the formula by using the data form. In a data form, you can enter new rows, find rows by navigating, or (based on cell contents) update rows and delete rows. Each label has an adjacent blank text box in which you can enter data for each column, up to a maximum of 32 columns. The data form displays all column headers as labels in a single dialog box. Microsoft Excel can automatically generate a built-in data form for your range or table. Use a data form when a simple form of text boxes that list the column headings as labels is sufficient and you don't need sophisticated or custom form features, such as a list box or spin button. You may find that using a data form can make data entry easier than moving from column to column when you have more columns of data than can be viewed on the screen. Learn about data formsĪ data form provides a convenient means to enter or display one complete row of information in a range or table without scrolling horizontally. ![]() When a row of data is very wide and requires repeated horizontal scrolling, consider using a data form to add, edit, find, and delete rows. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More.
0 Comments
Leave a Reply. |