O'Reilly logo

Excel 2019 All-in-One For Dummies by Greg Harvey

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2

Customizing Excel 2019

IN THIS CHAPTER

check Customizing the Quick Access toolbar

check Changing various and sundry Excel program settings

check Extending Excel’s capabilities with add-in programs

Chances are good that Excel 2019, as it comes when first installed, is not always the best fit for the way you use the program. For that reason, Excel offers an amazing variety of ways to customize and configure the program’s settings so that they better suit your needs and the way you like to work.

This chapter covers the most important methods for customizing Excel settings and features. The chapter looks at three basic areas where you can tailor the program to your individual needs:

  • The first place ripe for customization is the Quick Access toolbar. Not only can you control which Excel command buttons (on and off of the Ribbon) appear on this toolbar, but you can also assign macros you create to this toolbar, making them instantly accessible.
  • The second place where you may want to make extensive modifications is to the default settings (also referred to as options) that control any number of program assumptions and basic behaviors.
  • The third place where you can customize Excel is in the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required