What does exclamation mark do in Excel?

Typically, a single exclamation mark in an Excel worksheet cell will alert you to something that has gone wrong with the value that was entered. If the cell you’re looking at has an error, you’ll see a red line under the cell that contains the error. If the cell that contains the error has a formula, you’ll see the error message with an exclamation mark in a pop-up box.

What does exclamation point do in excel?

The Excel exclamation point is a reserved symbol that has a slightly different function in different areas of the program. For example, in the worksheet context, the exclamation point is used to highlight cells that contain formulas. The cell background color will change to light-yellow to indicate that the cell contains a formula. When you select a cell that contains a formula, the Formula bar will show you the result of the cell evaluation. The exclamation point is also used when you sort on the calculated value

What does an exclamation point mean in excel?

An exclamation mark is used to alert you to something that may be wrong in your worksheet. It’s basically a pop-up window that says what the problem is and helps you resolve it. You can activate the alert by using the mouse or the keyboard. If you press the ‘Esc’ key the alert will be dismissed.

What do exclamation mark do in excel?

An Excel exclamation mark is used to indicate a "warning" or "error" in a cell, and usually refers to a #VALUE! error. If a cell in your Excel spreadsheet is returning an error value (like if you accidentally typed in =0 instead of =NULL or =ABC instead of =ABCDE), you’ll often see an exclamation mark in the cell.

What does exclamation mark do in excel?

The Excel exclamation mark is one of the punctuation marks that are used in spreadsheets to make your formulas more clear. It refers to a logical true. If the value in the cell is greater than 0, then the cell will assume a TRUE value. If it is less than 0, it will assume FALSE. This is one of the most important roles of the Excel exclamation mark.