Starting to name cells is really easy and, shall we say, a little bit seductive and dangerous.
Names are great for helping you navigate quickly around areas of a big model. But, get into the habit of creating too many names and you’ll probably find you mess up your model.
This lesson introduces you to naming cells but also comes with a few warnings!
We’ve also got a few handy keyboard shortcuts that help you name cells, including “Ctrl” “F3” to bring up the name manager and “Ctrl” “Shift” “F3” to name a cell.
Don’t get carried away yet though please – we definitely have a few warnings around cell names!
Take the Excel formulas course
We think that, in just ten minutes a day over a month, we can check that you’re on top of critical Excel formulas useful in financial modelling – for free!