This website or its third-party tools use cookies which are necessary to its functioning and required to improve your experience. By clicking the consent button, you agree to allow the site to use, collect and/or store cookies.
The platform this site runs on doesn't have the option to turn off cookies server side, but you can do that in your browser and then return to the site.
I accept
Deny cookies Go Back

Annielytics.com

I make data sexy

  • About
  • Resources
  • Services
  • Blog
  • Contact
  • Log In

Feb 07 2014

How To Save An Excel Formula Midstream

freeze formulas in Excel

I’m going to start a series called Function Friday where I will share common Excel functions and formulas marketers should learn. I’ll kick this series off with a tip that every marketer needs to know before entering the icy waters of function madness. Think of it as an appetizer to tide you over until your meal is served next Friday. 🙂

Have you ever been in the middle of a really complicated Excel formula, just to lose everything because you can’t finish it? It’s happened to me more times than I care to admit. I’ll be knee deep in colored parentheses just to find out I’m missing a key element or I’m stuck and have to look something up. If you just press Enter (Mac: Return), Excel will throw a tantrum and kill off your hard work with a dull blade. If you press the Esc key, you’ll lose everything. And Excel has no built-in functionality that allows you to save your work for later.

To avoid becoming a statistic, this hack will allow you to freeze your formula wherever you are so that you can return to it later when you’re ready: While the cell is still active, just put a single apostrophe in front of the formula. This stores your formula as text. When you’re ready to proceed, simply remove the apostrophe, and you’re good to go. If you don’t remove the apostrophe, although you can still add to the formula, you won’t get the helpful tool tips.

how to freeze a formula in Excel

As you can see in the screenshot above, the apostrophe isn’t apparent in the cell after you press Enter, but you can see it in the formula bar.

In related news, if you have numbers that are left-aligned (which is an indicator that Excel thinks your numbers are text), look for an apostrophe in the formula bar!

Pro Tip: If Google Spreadsheets is more your cuppa, no worries. This hack works there too.

Image by Robert Terrell

Written by Annie · Categorized: Excel · Tagged: Excel Formulas, Function Friday

Comments

  1. Ivan Kreimer says

    September 9, 2014 at 6:25 PM

    I usually use the point “.” to do this. I didn’t know you can also use an apostrophe.

    Reply
    • Annie Cushing says

      September 9, 2014 at 6:44 PM

      Yep. There are many paths to the same goal. 🙂

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

CAN I HELP YOU FIND SOMETHING?

‘MAKING DATA SEXY’ IS LIVE ?

Want to learn how to create compelling, aesthetically pleasing charts in Excel? Learn how with Making Data Sexy.

Note: Also offered for Mac

STUFF I BLOG ABOUT

LEARN HOW TO USE ALL THE TOOLS

marketing strategy guide

DIY marketing strategy guide. This guide provides step-by-step instructions on how to perform 66 unique marketing tasks using 15 reputable marketing tools (both free and paid). Steal it for $295! Learn more.

LEARN TO DO A SITE AUDIT

site audit template

DIY site audit template. 20 sections, 215 checkpoints, 100+ explainer graphics, 218 pages, step-by-step instructions. Steal it for $295! Learn more.

LEARN TO DO AN ANALYTICS AUDIT

analytics audit template

DIY analytics audit template. 8 sections, 61 checkpoints, 100+ explainer graphics, 205 pages, step-by-step instructions. Steal it for $295! Learn more.

TO THIS DATA I DO THEE WED

dashboard course

Learn to build dynamic dashboards in Excel with Google Analytics data. 16 hours of video, 3 sample dashboards, 142-page workbook, practice Excel file, and more! Learn more.

FOLLOW ME ON TWITTER

SUBSCRIBE TO MY YOUTUBE CHANNEL

Privacy Policy
  • Email
  • LinkedIn
  • Twitter
  • YouTube

© 2023 annielytics.com