This would let you switch between the worksheet and form views. It should be positioned in the row and column last used in the form. No synchronization with the worksheet: when you close the form the cursor where you were when the form started. You have to type in each entry and it will be accepted, unless you have validations rules as well as the drop-down list. Input message: any input message/tooltip disappears entirely from the data form.ĭrop down list: if you’ve created a drop-down list of options for each cell in a column, the Microsoft made data form will ignore it. Validation: all those nifty data validation rules you made are ignored by the Excel form until you move away from that record/row, instead of alerting you in the cell / field as it should. In the Excel data form – you’re stuck with a single text line showing less than 40 characters regardless of the cell formatting. Wrapping: have a long text field with wrapping set in the cell for easy viewing? Well forget that. For example entering a date in a data formatted cell is changed to a date as soon as you leave the cell (confirming that you typed correctly) but in the form there’s no change until you leave that row/record.
The vertical scroll bar makes it easy to accidentally jump from one record/row to another without realizing.įormatting: no cells formatting appears in the form. There’s no ‘VCR’ like forward/back buttons, no way to jump to a particular row by number. Navigation: none of the navigation tools available to Excel have been added. That’s a pity because this feature becomes more useful as the number of columns grows. Limitations: the form has a limit of 32 fields / columns.
It appears no development time or money has been given to it for years. The Excel Data Form could be a major feature, the sort that gets applause in demonstrations, instead Microsoft has given it little attention or effort. Now we’ve told you about it, now we have to tell you why this Excel feature sucks – really sucks – sucks like a heavy duty vacuum cleaner.
Select the ‘Commands Not in the Ribbon’ list and scroll down to ‘Form …’ then add that button to the QAT list on the right. Click on the wedge at the right of the QAT and choose ‘More Commands’. The easiest workaround is to put it in the Quick Access Toolbar (QAT). In recent versions of Excel, the data form feature is hidden away. Microsoft is embarrassed about the Excel data form feature (rightly so) and so they hide it away where customers can’t easily find it. Restore – reverts to the last used details for that entryįind Prev – searches the entries / rows for specified text working back (or up the rows) from the current position.įind Next – searches the entries / rows for specified text working forward (or down the rows) from the current position.Ĭriteria – filters the list / form to show only certain entries.Ĭlose – takes you back to the worksheet view. New – makes a new entry (aka row in the worksheet)ĭelete – removes the current entry or row. It takes the column headings as field labels and makes editable fields for each column. Normally making a form is a messy business but the above form is made with a single click in Excel.
0 kommentar(er)
