Naming Cells

The idea behind naming cells is to be able to reference a cell by name rather than by cell address. This proves useful when building formulas because you don't have to remember the exact cell address, only a name. You can assign a name to a single cell or to a range of cells. This comes in handy if you plan to export portions of your spreadsheet for use in another application. One of the options you will have is to export a named range. Put simply, it's easier to remember “net profit” or “jan2003 sales” than it is to remember “d123” or “A13:A47.”

To name a cell or group of cells

1.
Select the cell(s).
2.
Choose Insert, Name, Name Cells (Ctrl+F3) to display the Cell Names dialog box (see Figure C.12).
Figure C.12. You can name a single ...

Get Absolute Beginner's Guide to WordPerfect® 12 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.