Office Button in Excel
MS Excel is one of the most popular spreadsheet software programs included with the Microsoft Office suite. However, Office suite also has some other popular products, such as Word, PowerPoint, etc. To make all these software user-friendly and effectively similar in the interface, Microsoft tries to make the UI quite similar for all its products, allowing users to find commands and tools easily. One such common option in all Office 2007 product interfaces, including Excel, is the Office button.
This article discusses the Office button in Excel (also called the Microsoft Office button). The article also elaborates all the options found inside the office button along with their functions.
What is an Office Button in Excel?
The Office Button was an experimental feature of the Microsoft Office suite 2007. All Office 2007 products (such as Word, Excel, PowerPoint, etc.) have a common button inside the active window, named Office Button. Since it is also present in Excel thus, we call it Office Button in Excel while working with Excel or referring to the button concerning MS Excel.
The Office button found in MS Excel 2007 and other Office 2007 products looks like this:
Note: It is very important to note that the Office button is only available in Office 2007 products. This means that the Office button is only present in Excel 2007. Later, the Office button was deprecated in Office 2010 and has since been no longer available in Excel 2010 and later. However, the options present in the Office button have been provided under the File tab.
Where is Office Button found in Excel?
When we open Excel 2007 program, we see an Office Button on the top-left corner of the Excel window. The button is attached to a ribbon and is identified by a circle containing an Office logo inside it.
The office button situated on the top-left corner in MS Excel 2007 looks like this:
What is the primary function of the MS Excel Office Button?
The primary function of the Office button in Excel and other Office 2007 products was to help users perform frequently used actions immediately using the shortcuts. The office button provides many useful options and helps us open, save, print any workbook with ease. Furthermore, we can easily access the Excel options and configure them instantly as per our choice directly from the Office button.
Excel Office Button Menu Options
When we click the Office Button in Excel, we get the following menu options:
The 'New' option in the Office button menu primarily displays the 'New Workbook' dialog box where we can select to either create a blank workbook/spreadsheet or use any of the existing templates by Microsoft.
The 'Open' option in the Office button menu displays the 'Open' dialog box using which we can choose and open any specific excel file from our computer.
The 'Save' option in the Office button menu helps us save the changes to an active workbook. This option typically saves temporary data to the current file for future use, even after the corresponding file is closed. Besides, if the 'Save' option is used the first time in a newly created spreadsheet, it will launch the 'Save As' dialogue box, which is the next option in the menu list.
The 'Save As' option in the Office menu displays the 'Save As' dialog box, which helps us to save the copy of an active file in the desired file format and with the desired file name at the desired location.
We further get some options when moving the mouse cursor onto the 'Save As' option or click the option. They are:
It mainly involves the most common spreadsheet file formats to help us save an active workbook instantly. However, we can select the 'Other Formats' to display the 'Save As' dialogue box or get a list of all the supported formats.
The 'Print' option in the Office menu helps us take a hard copy of the current spreadsheet on paper with the help of a connected printer. Additionally, we can also save a copy of an active document to a portable document format (PDF).
We further get some options when moving the mouse cursor onto the 'Print' option or click the option. They are:
The 'Prepare' option in the Office menu helps us to prepare the current spreadsheet for distribution. That means we can view or modify the properties of the spreadsheet as per our choice. Additionally, we can inspect the hidden metadata and other personal information of an active workbook using this option.
We further get some options when moving the mouse cursor onto the 'Prepare' option or click the option. They are:
The 'Send' option in the Office menu helps us to share the current spreadsheet document with others directly through the Excel program. We don't need to save it and then send it to others. Excel provides a variety of sharing options under the 'Send' command. The option was later renamed as 'Save and Send' in Office 2010.
We further get some options when moving the mouse cursor onto the 'Send' option or click the option. They are:
The 'Publish' option in the Office menu enables us to distribute the current spreadsheet with people on the network. Additionally, we can also create a blog article using the spreadsheet's content and share it accordingly.
We further get some options when moving the mouse cursor onto the 'Publish' option or click the option. They are:
The 'Close' option in the Office button menu helps us close the current spreadsheet or workbook opened in Excel.
The 'Excel Options' button in the Office button menu helps us configure or modify the settings/ preferences of the MS Excel program. By using this, we can customize the entire Excel accordingly.
The 'Exit Excel' button in the Office Button menu helps us to exit the Excel program. This means that we can close all open spreadsheets/ workbooks, including Excel itself, at once.