6 access should be on Quick Access Toolbar Excel

Quick Access Toolbar Excel is a quick access bar with many tools for users to add, supporting the manipulation of data tables and Excel content. Below are 6 essential accesses that must be available on Excel's Quick Access Toolbar.

AutoSave

Quick Access AutoSave, when enabled, automatically saves what you're working on to OneDrive. Then users will not worry about losing data when the computer has problems or when there is a power outage. All data is synchronized on the cloud service. Always pay attention that AutoSave must be activated in On mode.

In case the AutoSave icon turns gray, it may be due to:

1. You are not signed in to your Microsoft account.
2. You are working on an old version of Excel, so save the document in the old interface.
3. Error syncing data from OneDrive

6 access should be on Quick Access Toolbar Excel Picture 1

Check spelling on Excel

When you work in Excel, you cannot avoid spelling errors that affect the professionalism and content of the data. The Word spell checking tool will immediately display errors when you enter text, and in Excel, you should display the spell checking tool on the Quick Access Toolbar.

6 access should be on Quick Access Toolbar Excel Picture 2

Paste Special

Paste Special in Excel has many options for pasting data such as deleting formulas or borders, pasting data but ignoring content formatting, etc. When using this Paste Special, users can more easily adjust their data.

6 access should be on Quick Access Toolbar Excel Picture 3

Conditional formatting

Just as every Microsoft Word document has its own data types, Microsoft Excel spreadsheets also have conditional formatting to handle special data. Therefore, you should add the conditional formatting icon in the Quick Access Toolbar in Excel.

6 access should be on Quick Access Toolbar Excel Picture 4

Freeze Excel columns

When you want to freeze rows or columns in Excel, you need the freeze tool for quick processing. Then you can easily read the data table content while still fixing the title or data column you need.

6 access should be on Quick Access Toolbar Excel Picture 5

Action macros

Microsoft 365 native macros let you perform actions with one click. In addition, Excel allows you to add personalized macro buttons to the Quick Access Toolbar, helping to execute commands faster.

At the Excel interface, click the arrow icon in the Quick Access bar and select More Commands .

6 access should be on Quick Access Toolbar Excel Picture 6

Next we will add the Macro to the Quick Access Toolbar for use.

6 access should be on Quick Access Toolbar Excel Picture 7

Marvin Fry

Update 09 July 2024