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
Please reload

Featured Posts

Excel Tip – Using the Format Painter multiple times

November 20, 2019

1/1
Please reload

Recent Posts