Skip to main content

How Load or unload an Excel add-in program


Click here to visit main page

  1. Click the Microsoft Office Button , and then click Excel Options.
  1. Click the Add-Ins
  1. In the Manage box, click Excel Add-ins, and then click Go.
  1. To load an Excel add-in, do the following:
  2. In the Add-Ins available box, select the check box next to the add-in that you want to load, and then click OK.

 

To unload an Excel add-in, do the following:

  1. In the Add-Ins available box, clear the check box next to the add-in that you want to unload, and then click OK.

Excel Training in Noida

99Excel training academy is committed to provide high quality, value-based, career oriented training of Microsoft Excel and Vba – visual basic application to their students. We customized a unique excel training module at various levels to fulfill your essentials professional skill, most useful formulas, function and dashboards and applied in Institute training program.

99Excel training academy provides complete trainings of professional level MS Excel & Vba from the certified people.

Team

Our team is an expert professional from IT, Analytics and HR professionals.

Training Levels

Level 1            : Basic Excel

Level 2            : Advanced Excel

Level 3            : Excel Vba

Level 4            : Excel MIS & Dashboards

Level 5            : Excel – Vba Corporate Training

Locations

Noida, East Delhi, West Delhi, South Delhi

Contact

Business Hours: Everyday – 7am to 10pm

Emails: support@99excel.com

Mobile: +91 9654421288

Office: +120 4553178

Web: www.99excel.com

Two Methods To Create Drop Down List in Excel

Creating a drop down list is very easy. Its is very important function in excel if you want to select cell value from preconfigured items list and save your time in again and again typing it. For example , you are maintaining an inventory of cloths and there are 5 Size of a particular product then it will be really easy for you if you will create a drop down list and store all sizes values in another reference sheet , now you will just have to select the cell values from preconfigured list.

With the help of drop down lists you can avoid errors like typing mistakes  and  it will save a lot of time as you are just selecting the options from a preconfigured list. You can also add and edit items in your list any time.

Excel Dropdown List

Lets see and understand how to do it.

FIRST METHOD: DIRECTLY TYPING THE LIST

  • Select cell where you want to create drop down list and go to data tab in upper menu. Now select data validation option.
    Select data validation
  • Data validation window will open ,  In ” settings ” tab  move to ” validation criteria” and under “allow ” select “List”. Now  go to sources and insert your list as shown in the image below.dropdown list in source
  • Now you will get a drop down list in your select cell  with values you had inserted in sources box.

This method is very easy and straight forward but it is only when you have only few entries in your list , what if you have to select from a list of 200 entries then this method will become a big mess . Under such condition you will have to take help of second method.

SECOND METHOD : CREATING PRE CONFIGURED LIST

In this method we are going to create a pre configured list in different sheet and we we will used it in our desired cell. This is major method in creating drop down list  and can be used when you have a lot of entries in your list or you have to use same list many times in a sheet.

  • First create a list in ” sheet2 ” or any other sheet.
  • Select the complete list and right click on it . Then select “Name Range” .Select Nmae range in Excel
  • A ” New Name ” window will open , provide a name to our list like size , shape , weight or whatever you want.
  • Now move to sheet where you wan to insert drop down list .
  • Go to data tab in top menu . Select “Data Validation” .
  • Data validation window will open . Now select “List” in  “Allow” tab under settings .
  • It will display a “Source” option . Now insert your list name which you have entered in “Name Range ” option in previous step. If you have named it “Size” then enter “=size” in source option.data validation selecting source
  • Alternatively ,  insert your cells source for example my list is in “sheet2″  and from A1 to A6 so i will insert “=sheet2!$A$1:$A$6″  similarly you will have to insert your cell ranges.
  • Press OK and you have created your drop down list in excel !

HOW TO INSERT INPUT MESSAGE AND ERROR MESSAGE IN DROP DOWN LIST

If you want to further increase appearance of your drop down list then you can display a input message and error message in drop down list.Lest see how to do it.

  • Select the cell in which you have created drop down list.
  • Go to “Data Validation” option and then move to input message and insert your message title and message description.Input Message drop down list
  • Similarly you can also insert error alert using the same method as input message.

 

Well i hope now you can create drop down list in excel. if you have any further problems in creating list then please comment and i will solve your problems.

Easy-to-use PivotTables

What’s new in Microsoft Office Excel 2007

In Office Excel 2007, PivotTables are much easier to use than in earlier versions of Excel. By using the new PivotTable user interface, the information that you want to view about your data is just a few clicks away—you no longer have to drag data to drop zones that aren’t always an easy target. Instead, you can simply select the fields that you want to see in a new PivotTable field list.

And after you create a PivotTable, you can take advantage of many other new or improved features to summarize, analyze, and format your PivotTable data.

Using Undo in PivotTables   You can now undo most actions that you take to create or rearrange a PivotTable.

Plus and minus drill-down indicators   These indicators are used to indicate whether you can expand or collapse parts of the PivotTable to see more or less information.

Sorting and filtering   Sorting is now as simple as selecting an item in the column that you want to sort and using sort buttons. You can filter data by using PivotTable filters, such as Greater than, Equals, or Contains.

Conditional formatting   You can apply conditional formatting to an Office Excel 2007 Pivot Table by cell or by intersection of cells.

PivotTable style and layout   Just like you can for Excel tables and charts, you can quickly apply a predefined or custom style to a PivotTable. And changing the layout of a PivotTable is also much easier to do in the new user interface.

PivotCharts   Like PivotTables, PivotCharts are much easier to create in the new user interface. All of the filtering improvements are also available for PivotCharts. When you create a PivotChart, specific PivotChart tools and context menus are available so that you can analyze the data in the chart. You can also change the layout, style, and format of the chart or its elements the same way that you can for a regular chart. In Office Excel 2007, the chart formatting that you apply is preserved when you make changes to the PivotChart, which is an improvement over the way it worked in earlier versions of Excel.