Skip to Content
Special Edition Using® Microsoft® Office 2003
book

Special Edition Using® Microsoft® Office 2003

by Ed Bott, Woody Leonhard
September 2003
Beginner to intermediate content levelBeginner to intermediate
1368 pages
56h 14m
English
Que
Content preview from Special Edition Using® Microsoft® Office 2003
751
Troubleshooting
For a detailed discussion of workbook scenarios, see “Storing Multiple Scenarios in a Single Workbook,”
p. 829.
Troubleshooting
Editing an Array Formula
I entered an array formula, but when I try to edit or copy it, the results change or I get an error
message.
Editing an array formula is tricky. If the array formula was entered across multiple cells, you
must select every cell that contains the array before you can edit it. If the array formula is
contained in a single cell, you can edit it just as you would a conventional formula, but you
must remember to press Ctrl+Shift+Enter to store your changes as an array formula. If you
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Special Edition Using Microsoft® Office XP

Special Edition Using Microsoft® Office XP

Ed Bott, Woody Leonhard
Special Edition Using Microsoft® PowerPoint® 2002

Special Edition Using Microsoft® PowerPoint® 2002

Patrice-Anne Rutledge, Tom Mucciolo

Publisher Resources

ISBN: 0789729555Purchase Link