How to correct a #DIV/0! error in excel with Kutools

Hello friends , one of my viewer Requested me to solve this Error. Here i gave you a explanation about
#DIV/0! error from microsoft page.

What is  #DIV/0! error in excel ?

Excel displays the #DIV/0! error when a number is divided either by zero (0) or by a cell that contains no value.

Symptom

Excel displays the #DIV/0! error in one or more cells on a worksheet.

Causes

Entering a formula that performs explicit division by zero (0) — for example, =5/0.
Using a reference to a blank cell or to a cell that contains zero as the divisor in a formula or function that performs division.
Running a macro that uses a function or a formula that returns the #DIV/0! error.

How To Turn off Group Mode in excel/How to make un group your excel

Hello Geeks,let me give a example how i create this post.Yesterday  i used multiple excel at once,suddenly my data tab (filter) gone inactive. it was Oops moment for me to get rid immediately.than i saw its was in group mode which i selected multiple sheet !!!!. I thought this will happen to many who works in multiple sheets.so here are the solution.please check the step by step pictures to learn.

When my Excel Ungroup Data Tab is active ( Filter options works fine)

By mistake you would have select all sheets using shortcut keys(Ctrl+Shift+Click)

This is how your excel mode will be shown at top if you select all sheets (or) multiple sheets. 

 Your Data Tab(Filter) will be inactive mode

The very simple step just right click on one of the sheet uncheck (ungroup sheets)

Thats it,your excel will be normal mode as like before.just put a comment if this post helped you.

Common errors that occur in spreadsheets with solution

COMMON ERRORS IN EXCEL

Some of the most common mistakes with building formulas include:

• Forgetting the equal sign (=) at the start of the formula.
• Inserting a space before the equal sign (=).
• Having your data in the wrong format (for example, as text rather than as numbers).
• Selecting the wrong data range.

These problems can be easily avoided. If, however, you do have something wrong in a formula, Excel might return an incorrect result such as #VALUE!, as shown in the picture on the left. A full list of error types and ways to solve them is available in the Help topics; you'll find a link in the Quick Reference Card at the end of the course.

Source