Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,195,327 members, 7,957,874 topics. Date: Tuesday, 24 September 2024 at 10:45 PM

Tutorial Guide - How To Insert Data Into A Worksheet Using Excel Data Entry Form - Science/Technology - Nairaland

Nairaland Forum / Science/Technology / Tutorial Guide - How To Insert Data Into A Worksheet Using Excel Data Entry Form (449 Views)

Guides To Set A Custom Error & Input Message For A Worksheet Or Cell In Ms Excel / Guides On How To Create A Dropdown Menu List For A Worksheet Column In Ms Excel / Step By Step Guides On How To Create Custom Excel Worksheet & Workbook Template (2) (3) (4)

(1) (Reply)

Tutorial Guide - How To Insert Data Into A Worksheet Using Excel Data Entry Form by microsofttutor(m): 1:39pm On Apr 15, 2017
A data entry or input form is just a way to quickly enter data into a cell or group of cells of a worksheet. It is mostly used when the Excel spreadsheet is too big or long for the screen. Instead of scrolling to and fro to enter data into the various columns and rows, you use a data entry form which relieves you of the scrolling stress.
Guides on how to insert data using the excel data entry form

For example, to insert records in a sales record worksheet for the month of January which has a column for each day of the month, you will have move to and fro, but a data entry form makes the data entry process faster, easier and less stressful.

The Data input Forms option is normally located from the Quick Access tool bar. But by default, the Data entry Form is hidden and needs to be called out. When it is called out, the icon resides in the Quick Access toolbar. The Quick Access toolbar located above the tab bar as shown below.

The quick access tool bar

This is part 2 of chapter 7 of the Free Online Excel Tutorial Series at Microsoft Tutorial website. In the previous part (part 1)at http://www.microsofttut.com/2017/04/how-to-create-custom-excel-worksheet-template.html, I explicitly explained how to create a custom worksheet template in MS Excel. Also see the full tutorial course content of this Microsoft Excel Tutorial Series at http://www.microsofttut.com/p/microsoft.html.

HOW TO CALL OUT THE DATA ENTRY FORM ICON AND CUSTOMIZE THE QUICK ACCESS TOOL BAR IN EXCEL

Customizing the Quick Access tool bar helps you to locate and position several options and commands such as the data form command icon, which are not available in the MS Excel Quick Access tool bar and tabs by default. It also allows you to customize each tab and call out tabs like the Developers tab and the Add-Ins tab which are hidden by default. All these are available in the Excel Option dialogue box.

To Call Out the Data Input or Entry Form Icon In any Version of MS Excel:

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.

Click http://www.microsofttut.com/2017/04/how-to-insert-data-into-worksheet-using-data-entry-form.html to study full tutorial with screenshots.

(1) (Reply)

Facebook Fan Page For Sale!!! / Facebook's New Feature Helps You Easily Find Free Wi-fi / Learn Coding Online 12 Sites That Will Teach You Coding For Free

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 19
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.