I have a spreadsheet where a certain column has a lot of data which generates "number stored as text" errors. I want the numbers to be stored as text in this column for certain formatting purposes. Is there a way for me to quickly dismiss all these errors at once, or tell Excel to ignore this error for the entire row as a rule, without entirely disabling the error for the whole sheet or program?
- Select the top-left first cell in the sheet that has the green triangle indicating the error
- Scroll to the last bottom-right cell that has the error. Hold Shift and select that last cell
- Go back to that first cell, there will be a clickable icon to do something about the error
- Click on it and then click "Ignore Error"
This will ignore all the errors in the selection you have. But you must start with the first error to get the pop-up to ignore them.
Here's a more precise version of the answer by @JosephSerido:
- Select the range of cells where you want to ignore the error.
- Use Tab, Shift+Tab, Enter, Shift+Enter to navigate within the selected range to a cell that has this error. Screenshot below where the first cell doesn't contain this error, so step 2 is required.
- The clickable icon to ignore the error appears on the top left or top right of the selected range, depending on the scrollbar position. Don't confuse it with another icon on the bottom right.
- Select one cell with the error.
- Press Ctrl+A once or twice, until the range you want is selected.
- Click the icon, like in step 3 in the method above.