Once the magic of Excel spreadsheets is uncovered, it's hard to imagine living without it. Just about any … More
eHow launches Android app: Get the best of eHow on the go.
Summary: Defining cell names in Excel is done by highlighting the cell, going to insert on the menu and selecting name and define. Define cell names in Excel with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Amar Enhsaihan is an assistant certified public accountant (CPA) and works with Excel applications everyday on his job.read more
"Hi, I'm Amar Enhsaihan, I'm going to show you how to define cell names in Excel. Here I have spreadsheet open. Let's say we want to name this as a year, so I highlight this cell, go to the insert, name define and I can name it anyway I want. But make sure you don't have spaces, it doesn't like spaces. So let's say, we name it as a year, click okay and this cell is named as year now. To prove that, I'll show it to you. Echo, year, look what's showing up, years of experience, because I name this cell as year. And that's how you name cells in Excel. I'm Amar Enhsaihan, thank you for watching."
eHow Article: How to Define Cell Names in Excel