How to Make Data Automatically In Microsoft Excel

In the previous post I explained How to Change Column Being Line Data in Microsoft Excel, This time I will explain How to Make Data Automatically In Microsoft Excel.

When creating the MS Excel documents, sometimes you need the data to be written repeatedly as the name of people, item, and so on.
This is certainly going to spend a lot of time. Therefore, to speed up and simplify, you should create automatic data-ready, so that when needed, you do not need to write data many times, but stayed put. To do so follow the steps below:

• First, right click on the Menu Home bar and select the Customize Quick Access Toolbar. 
• You will be faced with the Excel Options dialog box with options for Quick Access Toolbar is already active.

 

• Press the Advanced option and then click the Edit Custom List that is on the Popular.

 

• The next dialog box will appear Custom List. Choose the option New List in the column Custom List and enter your data in the column list entries. For example the data "tables, chairs, cabinets, refrigerator, washing machine, bed".

• Click the Add button to add the data you automatically. 
• Once the data entered in the column Custom List press the OK button. 
• Next you will be presented back to the Excel Options dialog box Advanced options. Choose the OK button to end it.  
• Then position the cursor There is the cell where the data automatically that you created earlier will be included, for example in cell B2.  
• Then write the first data word that you created earlier is "Table". 
• Then click and drag the small black box in the lower right corner of cell B2 to B7 cell.
• After that the data you made earlier will appear in cells B2: B7 automatically.

 

That is my short explanation on this post about How to Make Automated data in Microsoft Excel, may be useful for all of you.