I need you to fill in a spreadsheet with data. Instead of entering data manually on a worksheet, you can use the Auto Fill feature to fill cells with data that follows a pattern or that is based on data in other cells.
You have several options when you want to enter data manually in Excel. You can enter data in one cell, in several cells at the same time, or on more than one worksheet at once. The data that you enter can be numbers, text, dates, or times. You can format the data in a variety of ways. And, there are several settings that you can adjust to make data entry easier for you.
Add, edit, find, and delete rows by using a data form:-
[url removed, login to view] the Form button to the ribbon
If necessary, add a column header to each column in the range or table. Excel uses these column headers to create labels for each field on the form.
Important: Make sure that there are no blank lines in the range of data.
Click a cell in the range or table to which you want to add the form.
To add the Form button Form Control button to the Quick Access Toolbar, do the following:
Click the arrow next to the Quick Access Toolbar, and then click More Commands.
In the Choose commands from box, click All Commands, and then select the Form button Form Control button in the list.
Click Add, and then click OK.
On the Quick Access Toolbar, click Form Form Control button .
[url removed, login to view] a data form
You can use a data form to add, find, change, and delete rows in a range or table.
Add a new row of data
In the data form, click New.
In the data form that appears, type the data for the new row in the fields provided.
To move to the next field in the row, press Tab. To move to the previous field, press Shift+Tab.
After you have finished typing data, press Enter to save your changes and add the row to the bottom of the range or table.
Important: If you see a message that states "Cannot extend list or database," this could mean that existing data may be overwritten if you continue. If you add a row to a table or range by using a data form, Excel expands it downward. If expanding the table would overwrite existing data, Excel displays the message Cannot extend list or database. Rearrange the data on your worksheet so that the range or table can expand downward from the last row.
[url removed, login to view] a row by navigating
Do one or more of the following:
To move through rows one at a time, use the scroll bar arrows in the data form.
To move through 10 rows at a time, click the scroll bar in the area between the arrows.
To move to the next row in the range or table, click Find Next.
To move to the previous row in the range or table, click Find Prev.
[url removed, login to view] a row by entering search criteria
Click Criteria, and then enter the comparison criteria in the data form.
All items that begin with the comparison criteria are filtered. For example, if you type the text Dav as a criterion, Excel finds "Davidovski" and "Davis." To find text values that share some characters but not others, use a wildcard character as your criterion.
The following wildcard characters can be used as comparison criteria for filters, and when you search for and replace content.