How to manage Add-ins

Excel 365 2016 2013 2010 2007
Some function in Excel is available only when the add-in is installed. For example, Solver or the Analysis group is not available in standard ribbons, you need to install the add-in before you can use it. See also Using Solver.

To install the add-in, follow next steps:

   1.   Select Tools -> Add-Ins....

   2.   In the Add-Ins dialog box, place a check mark next to the item named Solver Add-In:

Add-Ins in Excel 2003

   3.   Click OK.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.

Calculating the number of work days between two dates

Calculating the number of work days between two dates

When calculating the difference between two dates, you may want to exclude weekends and holidays.
How to create non-resizable font in charts

How to create non-resizable font in charts

When you scale Excel chart, the font of text items is scaled proportionally to the size of the chart. Unfortunately this powerful feature is a big source of a headache. Scaled fonts break formatting consistency, when those charts are being inserted into the Word document or PowerPoint presentation. Fortunately you can turn off auto-scaling for the particular chart item or disable it at all.
How to add Dividers to the chart

How to add Dividers to the chart

Most reports and presentations contain a lot of boring charts that describe the state before and after some event, action, etc. However, using simple visual tricks you can shake up the audience and draw an attention to the essence of your presentation.