Click the OK button to close the dialog box. ![]() ![]() Notice the Form command appears at the bottom of the list in the second column.Ħ. In the list, scroll down and double-click on At the top of the first column where it reads “ Choose Commands From ” select the “ Commands Not in the Ribbon ” option from the drop down list.ĥ. In the category list on the left side of the screen, click on the Quick Access Toolbar category.Ĥ. The file should have a series of column headings.ģ. Therefore, the first part of the lesson shows how to add the feature to the Quick Access Toolbar, and the second part is how to use the Data Form feature in Excel 2010. The answer is “Yes!”.īy default, the icon for the Data Form doesn’t exist on the Ribbon and it doesn’t exist on the Quick Access toolbar. Her question to me was: “Is there a way to enter data going down a list (in a dialog box) instead of entering data going across in the spreadsheet?”. She found it a bit cumbersome to enter the data going across in the spreadsheet. ![]() ![]() Last week a friend of mine was doing some data entry into a large spreadsheet that had a lot of columns to it. By Maria Pribyl on Septemin Excel, Spreadsheets
0 Comments
Leave a Reply. |