Chapter 20
More tips and tricks for Excel
Watching the results of a distant cell
Calculating a formula in slow motion
Repeat the last command with F4
Bring the active cell back in to view with Ctrl+Backspace
Separating text based on a delimiter
Auditing worksheets using Inquire
Inserting and exploring 3D models
Using the inking tools and the Action Pen
Seeing Workbooks Statistics and Smart Lookup
The chapters in this book are full of tips and tricks. This particular chapter is a catch-all for some of the tips that did not find a home elsewhere in the book.
Watching the results of a distant cell
Sometimes you need to keep an eye on a single result on a worksheet other ...
Get Microsoft Excel Inside Out (Office 2021 and Microsoft 365) 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.
