How can I bypass "formula errors"?

Occasional Visitor



I'm trying to make a grammar chart for word endings, which would basically consist entirely of "formula errors" - that is, for example, entries such as "-us," "-ī," and "-ō" in each cell; however, as you can clearly see, these aren't intended formulae. When I move on to the next cell, whatever I just typed immediately turns into "#NAME?" How can I bypass this error so it doesn't think they're supposed to be formulae?



1 Reply


Option 1: format the cells you're going to enter these endings in (for example a column) as Text before you start entering values.


Option 2: prefix each such value with a single straight quote '. This instructs Excel to treat the value as text. For example:




The single quote will be displayed in the formula bar, but not in the cell.