1. If you are using MS Excel 2007 and lower versions, click the
Office button located in the extreme
top left of the Excel workbook screen. Then click Excel Option which is the last option in the resulting menu list.
If you are
using MS Excel 2010 and later versions, click the File menu or tab and then click Options. This prompts the Excel
Option.
2. If you are using MS Excel 2007 and lower versions, click Customize located on the left menu.
If you are using MS Excel 2010 and later version, click the Quick Access tool bar option on the
left section of the dialogue box as shown below. The rest of the steps are the
same for all versions of MS Excel.
3. To add the Data Form option to the Quick Access toolbar,
click the Choose Commands From drop
down arrow and select Commands Not in
the Ribbon from the resulting menu options.
4. Select Form from
the resulting option and click the Add>>
button located in between the second and the third column of the dialogue
box as shown below.
NOTE:
To add or remove any other command to or from the Quick
Access toolbar, Select the command from the Excel Options dialogue box and click the Add>> or the Remove<<
button as the case may be.
5. Click OK to return to exit the dialogue box and return to
your worksheet.
6. Next, type a column title for each of the days in the month
of January in separate columns of the worksheet. For example, DAY 1, DAY 2,
DAY3, …, DAY 31.
7. Highlight the column title row, which is normally row 1.
Then click the Data Form icon you just added in the Quick Access tool bar (the
last icon there). A notification dialogue box pops up asking if you would like
to use the highlighted row as your column title. Click OK.
8. This prompts the Data
Form dialogue box showing all the columns you highlighted.
9. Enter values for each of the column title’s text box as
shown below.
10. Click the New button
to start a new row or click the Delete button
to delete the previous row or data entered as shown below. Click the Close button when you are through.
So
with the help of MS Excel data form, you can easily add records to a long or
wide worksheet.
This is the end of part 2 of chapter 7 of this online tutorial series.
In the next part (part 3), I will explain how to create a drop down menu list for a column in MS Excel.
Was this tutorial helpful to you?
Inform your friends about this post by clicking the share button below. Comment below if you are hooked up along the installation process.
Also click Here to subscribe for free so that you will get our latest game updates in your email.
Truth be told, after further examination, I found that Clickbank really had these purported Data Entry Projects expelled from their Commercial center.
ReplyDelete