Excel Life Hacks - Pausing a Formula Edit


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.

Featured Posts
Posts Are Coming Soon
Stay tuned...
Recent Posts
Archive
Search By Tags

Training Offices:

Johannesburg

106 Johan Avenue, Sandton

Durban

1 Tamarind Close, Umhlanga

Pietermaritzburg

400 Old Howick Road, Hilton

Corporate Onsite Training Available Countrywide

  • Summit Solutions Excel Training
  • Summit Solutions Excel Training
  • Summit Solutions Excel Training

Tel: 086 167 3923

Email: info@summitsolutions.co.za 

Head Office: Hilton Quarry Office Park, 400 Old Howick Road, Hilton.

2020 | Copyright | Summit Solutions