You're reading from Exploring Microsoft Excel's Hidden Treasures Turbocharge your Excel proficiency with expert tips, automation techniques, and overlooked features

Product type Paperback

Published in Sep 2022

Publisher Packt

ISBN-13 9781803243948

Length 444 pages

Edition 1st Edition

Languages

Power Query

Tools

Excel

Concepts

Programming Language

Author (1):

David Ringstrom

View More author details

Table of Contents (18) Chapters

Preface

1. Part 1: Improving Accessibility

2. Chapter 1: Implementing Accessibility FREE CHAPTER

3. Chapter 2: Disaster Recovery and File-Related Prompts

4. Chapter 3: Quick Access Toolbar Treasures

5. Chapter 4: Conditional Formatting

6. Part 2:Spreadsheet Interactivity and Automation

7. Chapter 5: Data Validation and Form Controls

8. Chapter 6: What-If Analysis

9. Chapter 7: Automating Tasks with the Table Feature

10. Chapter 8: Custom Views

11. Chapter 9: Excel Quirks and Nuances

12. Part 3: Data Analysis

13. Chapter 10: Lookup and Dynamic Array Functions

14. Chapter 11: Names, LET, and LAMBDA

15. Chapter 12: Power Query

16. Index

Why subscribe?

17. Other Books You May Enjoy

Adding Ribbon commands to the toolbar

It might feel redundant to add commands from the Ribbon to your Quick Access Toolbar, but doing so provides two benefits. First, the Quick Access Toolbar is always visible when the Ribbon is displayed, which means you don’t have to activate a specific Ribbon tab. Second, adding commands to the toolbar assigns keyboard shortcuts to commands such as Home | Center, that were deemed not to warrant a built-in shortcut.

Center text

A long-time quibble I’ve had with Excel for Windows is that you can’t press Ctrl + E to center text the way that you can in Microsoft Word, PowerPoint, or Outlook. There wasn’t a shortcut assigned to Ctrl + E for decades until the Flash Fill feature debuted in Excel 2013. with Ctrl + E now activates Flash Fill in Excel for Windows, while in Excel for macOS + E centers text, and Flash Fill doesn't have a shortcut. Fortunately, you can create your own keyboard shortcut for centering text...