Excel Quick Access

Back

Setup Home

Quick Access Toolbar

This is to save commonly used Excel functions to a toolbar above spreadsheets

Setup

Open an Excel workbook
Using the Search Menu at the top, search "quick" and choose "Options:Quick Access Toolbar" from the results

Switch "Choose commands from" to "All Commands" (see graphic)
Select all of the recommended functions shown in the right column of this graphic:

Tips💡
Click anywhere inside the left column and start typing the name of a command to find it quicker

Double click commands on left to add to your toolbar

Double click commands on right to remove from your toolbar

Back

Setup Home