BUSINESS EXCEL
Open in Telegram
Email π nazim.khan09@gmail.com Website π https://TechGuruPlus.com Free Tools π https://eConvert.org
Show more7 369
Subscribers
+124 hours
-257 days
-5830 days
Posts Archive
7 375
List of Various Excel Errors
1. #DIV/0
2. #N/A
3. #NAME?
4. #NULL!
5. #NUM!
6. #REF!
7. #VALUE!
8. #####
9. Circular Reference
1 β #DIV/0 Error
#DIV/0! Error is received when we work with a spreadsheet formula, which divides two values in a formula and the divisor (the number being divided by) is zero. It stands for divide by zero error.
2 β #N/A Error
This error means βno value availableβ or βnot available.β It indicates that the formula cannot find the value that we suppose it may return.
For example, using Excelβs VLOOKUP, HLOOKUP, MATCH , and LOOKUP functions, we may get this error if we do not find referenced value in the source data as an argument.
3 β #NAME? Error
This error is displayed when we usually misspell the function name. We can see in the above image that VLOOKUP is not spelled correctly; that is why #NAME? Error is being displayed.
4 β #NULL! Error
This error is usually displayed when cell references are not specified correctly. We get this error when we do not use the space character appropriately. The space character is called the βintersect operator,β which specifies the range that intersects each other at any cell.
5 β #NUM! Error
This error is usually displayed when a number for any function argument is found invalid.
6 β #REF! Error
This error stands for reference error. This error usually comes when, We accidentally deleted the cell which we referenced in the formula.OR We cut and paste the referenced cell in different locations.
7 β #VALUE! Error
This error comes when we use the wrong data type for a function or formula. For example, we can add only numbers. But if we use any other data type like text, this error will be displayed.
8 β ###### Error
This error is displayed when the column width in excel, is not enough to show the stored value in the cell.
9 β Circular Reference Error
This type of error comes when we reference the same cell in which we are writing the function or formula.
7 375
π₯ Filter Keyboard Shortcut in Excel
β
We can also use the keyboard shortcut βCTRL+SHIFT+Lβ to turn on/off the filters.
β
Once the filter has been enabled on the data, we can use the drop-down menus on each column header. Follow the below steps for doing the same:
β
We must first select a cell in the header row. As we can see, every cell contains a drop-down icon like the image. Then, press the βALT + down arrow keyβ on the keyboard to open the βFilterβ menu
7 375
How to add the current date & time without typing
β
To add a current date in a cell, press Ctrl +. If you would like to add the current time, then press Ctrl+Shift+.
β
To change the date format, use Ctrl+Shift+#. Likewise, if you would like to change the time format, use Ctrl+shift+@.
