O'Reilly logo

2007 Microsoft® Office System Step by Step, Second Edition by Joan Lambert, John Pierce, Steve Lambert, M. Dow Lambert III, Curtis D. Frye, Joyce Cox

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Key Points

  • You can add a group of cells to a formula by typing the formula, and then at the spot in the formula in which you want to name the cells, selecting the cells by using the mouse.

  • Creating named ranges enables you to refer to entire blocks of cells with a single term, saving you lots of time and effort. You can use a similar technique with table data, referring to an entire table or one or more table columns.

  • When you write a formula, be sure you use absolute referencing ($A$1) if you want the formula to remain the same when it’s copied from one cell to another or use relative referencing (A1) if you want the formula to change to reflect its new position in the worksheet.

  • Instead of typing a formula from scratch, you can use the Insert Function ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required