Excel Life Hacks - Pausing a Formula Edit

May 14, 2019


Anyone who has created an Excel Formula would have received an error stating that “There’s a problem with this formula”. Most of the time we spot the error straight away, fix it and our Formula is sorted. However, there are occasions that we simply cannot spot the mistake and it seems that the only way to come out of Edit mode is to delete all our hard work!


There is a neat alternative though. Simply place an apostrophe (‘) in front of the equals sign. This hoodwinks Excel to think you’re entering text. You can then come out of edit mode without losing all your hard work and then re-edit at a later stage.

Share on Facebook
Share on Twitter