Skip to content Skip to sidebar Skip to footer

Understanding and functions of the Office Quick Access Button and Toolbar in Microsoft Excel 2010

Understanding and functions of the Office Quick Access Button and Toolbar in Microsoft Excel 2010
Understanding and functions of the Office Quick Access Button and Toolbar in Microsoft Excel 2010

Understanding and functions of the Office Quick Access Button and Toolbar in Microsoft Word 2010 – Understanding and functions of the Office Quick Access Button and Toolbar. When activating Microsoft Excel 2010 we see a lot of icons in the upper left corner of the monitor. In general, the icons in question can be grouped in Office Quick Access Buttons and Toolbars. These icons are one of the differences between Microsoft Excel 2010 and earlier versions of Microsoft Excel.

1. Understanding Office Button Understanding

Understand the Office Button, The Office button is located in the upper left corner of the Microsoft Excel 2010 application window. This button contains commands for manipulating the Microsoft Excel 2010 window controls. The commands in question are Restore, Move, Resize, Minimize, Maximize, and Close. With this button you can display the Microsoft Excel 2010 window as you like.

Microsoft Excel 2010: The Office button is located in the upper left corner of the Microsoft Excel 2010 screen

Below is what it looks like after clicking the Microsoft Excel 2010 Office Button icon.

Microsoft Excel 2010: Displays the Microsoft Excel 2010 Office Button dialog box

2. Functions and symbols on the Office button

Functions of the office keys, When you click the Office button, several display menus appear to speed up the work process. Here I specify the function of the office button symbol.

=> Restore: Its function is to minimize the view of the Microsoft Excel window in use.

=> Move: Its function is to move or move the position of Microsoft Excel window after it is small.

=> Size: This function adjusts the size of the Microsoft Excel window display to your needs.

=> Minimize: Its function is to hide the Microsoft Excel window in the task bar.

=> Maximize: Function Returns the display size of the Microsoft Excel window in its maximum size.

=> Close: This function closes the currently active or running Microsoft Excel window.

3. Understand the Quick Access Toolbar

Quick access bar is a toolbar that contains icons that are used as shortcuts to invoke certain commands. This toolbar is used to group icons that are commonly used in document processing.

By default, the Quick Access Toolbar consists of three icons, namely the Save icon (to save the file or document we are currently working on), Undo (to cancel the last command), and the last one is Redo (to undo or Cancel Restore) The canceled command may add some icons (commands) to the Quick Access Toolbar as needed.

To enter or add command icons on the Quick Access Toolbar, you can use the following steps.

  • Click the arrow button to the right of the row of the Quick Access Toolbar.
  • Place a check mark in the box available next to the icon option.

Microsoft Excel 2010: The check box for selecting the command to be displayed on the Quick Access Toolbar. The selected command is checked.

If it turns out that the Quick Access Toolbar does not have the required icon, you can use the following steps to access the icon and add it to the Quick Access Toolbar at the same time.

  • On the Quick Access Toolbar, click the combo box button.
  • Select it and click the More Commands command.
  • Select one of the icons you want and type it in the Quick Access Toolbar selection box (click Add to add a command and click Remove to cancel the command).
Microsoft Excel 2010: Steps to Add Icons to the Quick Access Toolbar
  • Then click OK.

By default, the Quick Access Toolbar is located at the top of the Microsoft Excel 2010 window, just to the right of the Office Button. You can move the location of the Quick Access Toolbar below the ribbon. You can see how to do this below.

  • Click the arrow icon to the right of the Quick Access Toolbar icons to make the display look like the one below.
Microsoft Excel 2010: Base view before moving the position of the Quick Access Toolbar

  • Click Show Below the Ribbon to make the Quick Access Toolbar look like the image below.
Microsoft Excel 2010: Position display of the toolbar for quick access after moving

4. Functions and symbols in the toolbar for quick access

=> Save: Its function is to save files that have been worked on or are currently being edited.

=> Undo: Its function is to undo the last command given.

=> Redo: Its function is to undo.

=> New: Its function is to create a new paper page.

=> Open: Its function is to open files or documents created with Microsoft Excel 2010.

=> E-mail: Sending documents by e-mail to the desired e-mail address via the Internet.

=> Quick Print: Its function is to quickly print documents or files in paper form on the printer.

=> Print preview and printing: Its function is to see what the document will look like before printing.

=> Sort in ascending order: This function sorts the data from smallest to largest.

=> Sort in descending order: This function sorts the data from largest to smallest.

=> Spelling: Its function is to check the spelling of words in the text we have written.

=> Open last used file: Its function shows the tab of the file menu.