Fungsi Quick Access pada Microsoft Excel

Pembahasan

Quick Access Toolbar standar pada Microsoft Excel adalah save, undo, dan redo. Kita bisa menambahkan fungsi lain dengan mengklik File → Options → Quick Access Toolbar dan memilih tool apa yang ingin ditambahkan.

Table of Contents Show

Quick Access Toolbar standar pada Microsoft Excel adalah save, undo, dan redo. Kita bisa menambahkan fungsi lain dengan mengklik File → Options → Quick Access Toolbar dan memilih tool apa yang ingin ditambahkan.
What do you want to do?
Show or hide the Quick Access Toolbar
Move the Quick Access Toolbar
Change the location
Show or Hide command labels on the Quick Access Toolbar
Add a command to the Quick Access Toolbar
Add a command to the Quick Access Toolbar that isn’t on the ribbon
Remove a command from the Quick Access Toolbar
Change the order of the commands on the Quick Access Toolbar
Customize the Quick Access Toolbar by using the Options command
Export a customized Quick Access Toolbar
Import a customized Quick Access Toolbar
Why am I seeing a green ball?
Need more help?
Apa fungsi dari Quick access?
Apa yang dimaksud dengan Quick access toolbar Dalam Microsoft Excel?
Apa fungsi Quick access toolbar brainly?
Apakah fungsi quick access toolbar pada Microsoft Word 2007?

Customize the Quick Access Toolbar

Excel for Microsoft 365 Word for Microsoft 365 Outlook for Microsoft 365 PowerPoint for Microsoft 365 Access for Microsoft 365 OneNote for Microsoft 365 Project Online Desktop Client Publisher for Microsoft 365 Visio Plan 2 Excel 2021 Word 2021 Outlook 2021 PowerPoint 2021 Access 2021 Project Professional 2021 Project Standard 2021 Publisher 2021 Visio Professional 2021 Visio Standard 2021 OneNote 2021 Excel 2019 Word 2019 Outlook 2019 PowerPoint 2019 Access 2019 Project Professional 2019 Project Standard 2019 Publisher 2019 Visio Professional 2019 Visio Standard 2019 Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 Access 2016 OneNote 2016 Project Professional 2016 Project Standard 2016 Publisher 2016 Visio Professional 2016 Visio Standard 2016 Excel 2013 Word 2013 Outlook 2013 PowerPoint 2013 Access 2013 OneNote 2013 Project Professional 2013 Project Standard 2013 Publisher 2013 Visio Professional 2013 Visio 2013 SharePoint Designer 2010 Excel 2010 Word 2010 Outlook 2010 PowerPoint 2010 Access 2010 OneNote 2010 Project 2010 Project Standard 2010 Publisher 2010 Visio Premium 2010 Visio 2010 Visio Standard 2010 InfoPath 2010 InfoPath 2013 SharePoint Workspace 2010 More...Less

The customizable Quick Access Toolbar contains a set of commands that are independent of the currently displayed tab on the ribbon. You can move the Quick Access Toolbar from one of the two possible locations, and you can add buttons that represent commands to the Quick Access Toolbar.

Notes:

You cannot increase the size of the buttons representing the commands by an option in Microsoft Office. The only way to increase the size of the buttons is to lower the screen resolution you use.
You cannot display the Quick Access Toolbar on multiple lines.
Only commands can be added to the Quick Access Toolbar. The contents of most lists, such as indent and spacing values and individual styles, which also appear on the ribbon, cannot be added to the Quick Access Toolbar. However, you can Customize the ribbon in Office to personalize the ribbon the way that you want it. For example, you can create custom tabs and custom groups to contain your frequently used commands.

What do you want to do?

Show or hide the Quick Access Toolbar
Move the Quick Access Toolbar
Show or hide command labels on the Quick Access Toolbar
Add a command to the Quick Access Toolbar
Add a command to the Quick Access Toolbar that isn’t on the ribbon
Remove a command from the Quick Access Toolbar
Change the order of the commands on the Quick Access Toolbar
Customize the Quick Access Toolbar by using the Options command
Reset the Quick Access Toolbar to the default settings
Export a customized Quick Access Toolbar
Import a customized Quick Access Toolbar
Why am I seeing a green ball?

Right-click in the ribbon and do either of the following:

If the Quick Access Toolbar is shown, select Hide Quick Access Toolbar.
If the Quick Access Toolbar is hidden, select Show Quick Access Toolbar.

Note: You can also hide the Quick Access Toolbar in the Customize Quick Access Toolbar menu by selecting Hide Quick Access Toolbar.

Location

The Quick Access Toolbar can be located in one of two places:

Above the ribbon, on the title bar (default location)
Below the ribbon

Change the location

You can move the location of the Quick Access Toolbar from one location to another.

Select Customize Quick Access Toolbar.
In the list, select Show Below the Ribbon.

or Show Above the Ribbon.
Notes:
- You can set the location commands in Options.
- Select File > Options > Quick Access Toolbar>Toolbar Position.

If the Quick Access Toolbar is set below the ribbon, you can show or hide the command labels.

Important: The Quick Access Toolbar MUST be set below the ribbon to show or hide the command labels.

Select Customize Quick Access Toolbar.
In the list, select either Show Command Labels

or Hide Command Labels.

On the ribbon, select the appropriate tab or group to display the command that you want to add to the Quick Access Toolbar.
Right-click the command, and then select Add to Quick Access Toolbar on the shortcut menu.

Select Customize Quick Access Toolbar > More Commands.
In the Choose commands from list, select Commands Not in the Ribbon.
Find the command in the list, and then select Add.

Tip: If you can't find the command you want on the Commands Not in the Ribbon list, try setting Choose commands from to All commands.

Right-click the command you want to remove from the Quick Access Toolbar.
Select Remove from Quick Access Toolbar on the shortcut menu.

Right-click the Quick Access Toolbar then select Customize the Quick Access Toolbar on the shortcut menu.
Under Customize Quick Access Toolbar, select the command you want to move.
Select the Move Up or Move Down arrow.

You can add, remove, and change the order of the commands on the Quick Access Toolbar by using the Options command.

Select File > Options > Quick Access Toolbar.
Use the Add and Remove buttons to move items between the Customize the Access Toolbar list and the Choose command from list.

Note: To find an item in the Choose commands from list, it may be helpful to first confirm its location and name within the app. Commands that are no longer visible in the app could still be listed here under All commands. To help identify this type of command, a more descriptive tooltip name may appear in parentheses next to the legacy command name in this form:
Address [Document Location]
Formatting [Paste Formatting]
Formulas [Paste Formulas]
Values [Paste Values]
Reset the Quick Access Toolbar to the default settings

Open the Quick Access Toolbar short-cut menu, and then select Customize Quick Access Toolbar.
In the Customize the Quick Access Toolbar window, select Reset > Reset only Quick Access Toolbar.

You can export your ribbon and Quick Access Toolbar customizations into a file that can be imported and used by a coworker or on another computer.

Select File > Options > Quick Access Toolbar.
Select Import/Export > Export all customizations.

For more information about how to customize the ribbon, see Customize the ribbon in Office.

You can import customization files to replace the current layout of the ribbon and Quick Access Toolbar. By being able to import the customization, you can keep Microsoft Office programs looking the same as your coworkers or from computer to computer.

Important: When you import a ribbon customization file, you lose all prior ribbon and Quick Access Toolbar customizations. If you think that you might want to revert to the customization you currently have, you should export them before importing any new customizations.

Select File > Options > Quick Access Toolbar.
Select Import/Export > Import customization file.

For more information about how to customize the ribbon, see Customize the ribbon in Office.

Why am I seeing a green ball?

You see a green ball if you added a custom group or command to the Quick Access Toolbar after you customized the ribbon but didn't assign an icon to represent that custom group or command.

Notes: The icon is used:

When you add the custom group to the Quick Access Toolbar.
To help differentiate between your own customized ribbon and the default ribbon.

Need more help?

Apa fungsi dari Quick access?

Secara umum , Quick Access Toolbar berfungsi buat jalan pintas terhadap akses atau perintah yang sering kita tuang. di Quick Access Toolbar, umumnya akan dihasilkan beberapa fungsi atau tombol penting, seperti Save, Print, Email, Print Preview, Spelling, serta lain sebagainya.

Pengertian dan Fungsi Quick Access Toolbar Excel Fungsi Quick Acces Toolbar adalah untuk menempatkan tombol-tombol perintah yang sering digunakan pada microsoft sehingga menjadi lebih mudah untuk menjalankan perintah tersebut.

Quick Acces Toolbar digunakan untuk menempatkan tombol-tombol perintah yang sering digunakan sehingga pengguna menjadi lebih mudah untuk menjalankan perintah tersebut.

Quick Access Toolbar, dari istilah yang digunakan Microsoft ini kita bisa tahu, toolbar ini dapat digunakan untuk mengakses secara cepat command yang (diasumsikan) paling sering kita digunakan. Toolbar ini bisa kita kustomasi sesuai kebutuhan kita, baik variasi command maupun letaknya.