SUPER EASY Excel Data Entry Form (NO VBA) - Excel Tips and Tricks - video Dailymotion

RabiGurungXybernetics

Learn about the easy Excel data entry form. No VBA required.   Add Record  1) Place you cursor anywhere in the dataset.  2) Alt + D, release D while holding Alt press O    Excel Tutorials,Excel 2016,Excel 2013,Excel 2010,Advanced Excel tricks,Excel online course,Excel tips and tricks,  Excel for analysts,  how to create data entry form in excel,data entry from without vba,data entry,excel data entry form,excel data entry form with data validation,excel data entry form for table,excel data entry form button,excel hidden features,excel hidden tips,

Transcript

00:00There's a super easy Excel data entry form that you can use where BBA is not

00:05required. All you need is a hotkey. First hold down alternate and then toggle D and

00:11keep holding down alternate and press O. What this does is it opens up the data

00:15entry form here. If you want to create a new record click on a new here and enter

00:20your data and once that's done if you hit close you can see that the new record

00:27is being entered in here. Again let's open up the data entry form alternate D keep

00:31holding on alternate O and then let's say if you want to delete a record let's say

00:37if you go next you want to delete say it is Puma here. If you hit delete and

00:42acknowledge say okay you can see that the record is gone. Likewise you can also do

00:46edits. Let's say for example you don't want this $88 on Puma say you want to

00:51increase the price to $100.99 and if you close you can see that that

00:56particular record the pricing has changed.

SUPER EASY Excel Data Entry Form (NO VBA) - Excel Tips and Tricks

Category

Transcript

Recommended