Likely, the version of Excel 2021 that comes with the application when you initially install it isn’t the greatest match for the way you use it. As a result, Excel provides a wide range of options for customizing and configuring the program’s settings to fit your requirements and working style better. 

The most significant ways for modifying Excel options and functions are covered in this chapter. This chapter examines three fundamental areas where you might customize the software to meet your own needs: 

The QA (Quick Access) Toolbar is the first area where you may make changes. You may not only customize which Excel command buttons show on this toolbar (on and off the Ribbon), but you can also add macros you write to this toolbar, keeping them quickly accessible. 

The default configurations (also known as options) that regulate a variety of program assumptions and fundamental behaviors are the second location where you may wish to make considerable changes. 

The realm of add-ins, that little, specialized utilities (also known as applets) that enhance the built-in Excel functionality by joining themselves to the main Excel software, is the third location where you may personalize Excel. Excel Add-ins are accessible from different places, such as the original Excel 2021 program, the Microsoft Office website, and several third-party sellers. 

Customizing the QA (Quick Access) Toolbar in Excel 2021 allows you to quickly make changes to the program’s only toolbar, the QA (Quick Access) Toolbar. This toolbar displays on the left side of the screen, just above the Ribbon, when you first open Excel. It contains the four most regularly used action buttons: Undo, Save, AutoSave, and Redo. 

To add additional frequently used instructions to the QA (Quick Access) Toolbar, such as Open, New, Quick Print, E-mail, and so on, go to the Configure QA (Quick Access) Toolbar option and choose the action from the drop-down menu. 

Ribbon Instructions may be added to the QA (Quick Access) Toolbar   

Excel 2021 makes it simple to add a command to the QA (Quick Access) Toolbar from any tab on your Ribbon. Right-click a Ribbon command’s push-button on your Ribbon and select Attach to QA (Quick Access) Toolbar from the menu bar. Excel places the command button just in front of the Configure QA (Quick Access) Toolbar icon at the end of the QA (Quick Access) Toolbar. 

Choose the Customize QA (Quick Access) Toolbar icon and then More Commands from the drop-down box to relocate the command button to a new spot on the QA (Quick Access) Toolbar or mix it with other icons on the toolbar. 

The QA (Quick Access) Toolbar tab is chosen in the Excel Options dialogue box, then opened (just like the one shown in Figure below). Excel displays all of the buttons added to the QA (Quick Access) Toolbar in the order that they appear on the toolbar, from left to right, according to their top-down order in the list view on the right-hand side of the dialogue box. 

To rearrange a button on the toolbar, select it in the list box on the right, then hit either the Move Up or Move Down option (the one with the black triangle pointing upward or downward) till the icon is upgraded or downgraded to the appropriate location on the toolbar. 

Non-Ribbon commands may be added to the QA (Quick Access) Toolbar 

You can also build a button for any Excel command using the settings on the QA (Quick Access) Toolbar tab of the Excel Options dialogue box, even if it isn’t one of the ones listed on the Ribbon tabs: 

1. From the Select Commands From the drop-down list box, choose the kind of action you wish to add to the QA (Quick Access) Toolbar. The basic Popular Commands, All Commands, Commands Not on the Ribbon, and Macros and each of the basic and relevant tabs that may appear on the Ribbon are among the commands available. Click Commands Not on the Ribbon towards the top of the drop-down list to see just the commands on the Ribbon. Click All Commands towards the bottom of the drop-down box to get a comprehensive list of all Excel commands. 

2. In selecting the “Commands From” box on the left, choose the command option whose button you wish to add to the QA (Quick Access) Toolbar. 

3. At add the command button to the bottom of the right-hand list box, click the Add button. 

4. (Optional) Click the Move Up button until the newly added command button is at the desired place on the toolbar. 

5. To dismiss the Excel Options dialogue box, click the OK button. 

By admin