Contents
PART I: MASTERING EXCEL RANGES AND FORMULAS
1 Getting the Most Out of Ranges
Advanced Range-Selection Techniques
Keyboard Range-Selection Tricks
Using the Go To Special Dialog Box
Advanced Range Copying and Pasting
Pasting Selected Cell Attributes
Combining Two Ranges Arithmetically
Applying Conditional Formatting to a Range
Get Excel 2016 Formulas and Functions 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.