Errata

Second sentence from the end of the paragraph reads "tying in the formula bar" instead of "typing in the formula bar."

Note from the Author or Editor:
page 31, second paragraph, "tying in the formula bar" should be "typing in the formula bar"

3rd line Whe should be When

Note from the Author or Editor:
page 56, third paragraph, change "Whe" to "When"

should say "cause" instead of "clause"

Note from the Author or Editor:
p. 60, first paragraph after heading, second sentence "it can clause" should be "it can cause"

Last line. "Page 167 describes to add borders..." should be "Page 167 describes how to add..."

Note from the Author or Editor:
p. 107, last line, "Page 167 describes to add borders" should be "Page 167 describes how to add"

It says "Page 167 describes to add borders" when it should say "Page 167 describes how to add borders."

Note from the Author or Editor:
p. 107, "No Borders." bullet point, "Page 167 describes to add borders" should say "Page 167 describes how to add borders"

"Here's worksheet..." should be "Here's a worksheet..."

Note from the Author or Editor:
p. 115, Figure 3-13 caption, "Here's worksheet" should be "Here's a worksheet"

"To make your worksheet's..." should be "To make your worksheets..." (no apostrophe; there is no possession here).

Note from the Author or Editor:
p. 138, 2nd paragraph under "Formatting Cell Values" the text "To make your worksheet's" should be "To make your worksheet"

Accountancy format? Should this be Accounting format?

Note from the Author or Editor:
page 144, in "Accounting" section, "Finally, the Accountancy format" should be "Finally, the Accounting format"

This section explains the use of # as a digit placeholder. The example reads "### displays .3 as .3." ### would actually show .3 as nothing whereas .### would show .3 as .3.

Note from the Author or Editor:
p. 156, first row of table, third column, "### displays .3 as .3" should be "###.# displays .3 as .3"

"You don't must be" is grammatically incorrect.
"must" should instead be "need to"

Note from the Author or Editor:
p. 224, first paragraph after heading, first sentence, "You don't must be" should be "You don't need to be"

"This means that you don't must tweak..." is not right.
"must" should be exchanged for "need to" or "have to"

Note from the Author or Editor:
p. 254, Figure 8-13 caption, second sentence, "don't must tweak" should be "don't need to tweak"

The erroneous sentence starts: "Excel includes adds a handy shortcut..."
Pick either the word 'includes' or the word 'adds', but not both.

Note from the Author or Editor:
p. 357, beginning third paragraph (not including code), "Excel includes adds" should be "Excel includes"

the two circles around the letter "R" should be replaced with little arrows

Note from the Author or Editor:
p. 392, tip box at top of page, last sentence, the are two R-in-circle symbols that should be right-pointing arrows

On p. 402 in the 2nd paragraph titled "Banded Columns", in the second sentence, there is a word missing. With the missing word capitalized (for emphasis) it should read: "Folks use banded COLUMNS less than banded rows, because..."

Note from the Author or Editor:
p. 402, second bullet point, second sentence, "Folks use banded less" should be "Folks use banded columns less"

It says "you're not completely cut off from the rest of the word" when it should say "you're not completely cut off from the rest of the world."

Note from the Author or Editor:
p. 448, Note box at bottom of page, "cut off from the rest of the word" should be "cut off from the rest of the world"