Create Your Custom Excel Workbook with a Few Clicks

how to make a custom excel tab

Excel Custom Tabs

Excel’s User Interface is one of those handy and easy-to-use interfaces. By spending just a few minutes, you can see this software is straightforward to work with. 

That’s because Microsoft groups all functions very well. But now, you can change this grouping and customize them based on your needs. Let’s see some of the most common customizations that are made possible in Excel. 

What is Excel Ribbon?

Excel Ribbon is the technical term for a row of tabs at the top of the Formula bar.

the excel ribbon

This feature was represented in Excel 2007 and replaced Excel 2003 and earlier versions’ menus and toolbars. This feature has a bar of buttons and icons that contains commands and functions. These buttons and icons are classified into different tabs based on their properties. Clicking a tab in the tab list changes the Excel ribbon tab. 

Clicking a tab in the Excel tab list changes the ribbon tab.

How many tabs are in Excel?

Generally, we have eight tabs in Excel. You can find them in the Excel Ribbon on top of the worksheet.

 These tabs are:

  1. File
  2. Home
  3. Insert 
  4. Page layout 
  5. Formulas 
  6. Data 
  7. Review 
  8. View
the 8 Excel tabs including file home insert page layout formulas data review view

File Tab

The File tab was introduced in Excel 2010 to replace the Office button in Excel 2007. A new window opens with a navigation pane on the left as you click this tab. All the customizations we are discussing could be done through this tab.

Here, we’ll mention common options for each feature:

Info

This feature offers you the Protect Workbook option to control the changes from your co-worker if you share the Excel file with them. According to the next image, protecting a sheet or a workbook by defining a password is very common.

excel info page including protect workbook inspect woekbook manage workbook and browser view options

Is it possible to recover an unsaved Excel file?

Software like Excel usually has an option that enables users to recover unsaved files. You can follow these steps to recover your unsaved Excel file:

  1. Go to the File tab.
  2. Click Info.
  3. Click Manage Workbook.
  4. Click Recover Unsaved Workbook.
how to recover an unsaved Excel file

New:

For those who need predefined templates, Excel offers lots of templates. Nevertheless, you can search online for different categories you need.

Excel new page where you can use predefined templates or search templates based on categories

Open, Save, Save as, Print, and Share:

These features help you open another file, save in a specific path, print your files, and share your files in each Microsoft software.

You can press CTRL+S as a shortcut to Save and CTRL+P as a shortcut to Print. The Save as a shortcut is F12.

SaveCTRL+S
PrintCTRL+P
Save asF12

Export:

This is a ubiquitous feature that can create a PDF file of your Excel file. So, to make a PDF file from an Excel file, take these steps:

  1. Go to the File tab from the Ribbon.
  2. Click Export.
  3. Click Create PDF/XPS Document.
  4. Click the Create PDF/XPS button.

You can learn more about Converting PDF to Excel in this blog: Converting PDF to Excel: The Easy Way

how to create a PDF file of your Excel file, click on Export in the File tab, click Create PDF/XPS Document and click on its icon

Publish, Close, and Account:

You can save your document to OneDrive and Publish it to Power BI. This feature automatically refreshes your shared workbook.

And the Close part, close your workbook, which is not applicable here. The Account feature lets you sign in to MS Office.

Option:

Option is the last item in the File tab, but the most important feature of the File tab. Why? Because through this option, we can customize our ribbon. The Excel Options dialogue box contains these categories:

  1. General
  2. Formulas
  3. Proofing
  4. Save
  5. Language
  6. Advanced
  7. Customize Ribbon
  8. Quick Access Toolbar
  9. Add-Ins
  10.  Trust Center
Excel options window

Let’s go through these ten categories, learn how to use them, and customize our workbook. To be more specific and helpful, we’ll discuss these categories in the form of questions and responses.

Note: There are various options, but we’ll mention the more common ones.

1- General
How to enable or disable Mini Toolbar in Excel
the mini toolar of a cell in an excel spreadsheet
  1. Go to the File tab.
  2. Click Options.
  3. Click General.
  4. From the User Interface Options part, check or uncheck the “Show Mini Toolbar on Selection.”
Go to the File tab. Click Options. Click General. Check or uncheck the “Show Mini Toolbar on Selection " from the User Interface Options part.
How to enable or disable Quick Analysis in Excel?
the Quick Analysis box of a column in an Excel spreadsheet
  1. Go to the File tab.
  2. Click Options, click General.
  3. Check or uncheck the “Show Quick Analysis options on Selection” from the User Interface Options section.
Go to the File tab. Click Options then General. Check the “Show Quick Analysis options on Selection” from the User Interface Options section.
How to change the default font when creating new Excel workbooks?
  1. Go to the File tab.
  2. Click Options.
  3. Click General.
  4. From the “When Creating New Workbooks” section, change the default font, font size, etc.
Go to the File tab. Click Options. Click General. From the “When Creating New Workbooks” section, change the default font, font size, etc.
2- Formulas
How to enable the Automatic calculation in Excel?
  1. Go to the File tab.
  2. Click Options.
  3. Click Formulas.
  4. From the “Calculation Options” section, set the workbook calculation on Automatic.
Go to the File tab. Click Options. Click Formulas. From the “Calculation Options” section, set the workbook calculation on Automatic.

Note: The recalculating shortcut in Excel is F9.

How to enable the Formulas AutoComplete in Excel?
  1. Go to the File tab.
  2. Click Options.
  3. Click Formulas.
  4. From the “Working with Formulas” part, check the Formula AutoComplete checkbox.
Go to the File tab. Click Options. Click Formulas. From the “Working with Formulas” part, check the Formula AutoComplete checkbox.
Where is the error checking options button in Excel?
  1. Go to the File tab.
  2. Click Options.
  3. Click Formulas.
  4. The “Error Checking Rules” section (You can enable the rules to check for errors in your workbook.)
Go to the File tab. Click Options. Click Formulas. The “Error Checking Rules” section (You can enable the rules to check for errors in your workbook.)

Do you need to know about the Formula Errors in Excel?

Check out this blog: “What Are Excel Formula Errors.”

3- Proofing

This option is used for Translation, Thesaurus, Spelling, and Custom Dictionaries in English, Spanish, and French.

The proofing option in excel is used for Translation, Thesaurus, Spelling, and Custom Dictionaries in English, Spanish, and French
4- Save
How do I change the save options in Excel
  1. Go to the File tab.
  2. Click Options.
  3. Click Save.
  4. Customize how your workbook will save by Excel options.
How to change the default file format to save in Excel
  1. Go to the File tab
  2. Click Options
  3. Click Save
  4. From the “Save Workbooks” section, select the format you want from the “save files in this format” menu.
In the File tab. Click Options. Click Save. From the “Save Workbooks” section, select the format you want from the “save files in this format” menu.
How to change the default save location in Excel
  1. Go to the File tab.
  2. Click Options.
  3. Click Save.
  4. From the “Save Workbooks” part, check the “Save to Computer by default” checkbox.
Go to the File tab. Click Options. Click Save. From the “Save Workbooks” part, check the “Save to Computer by default” checkbox.
5- Language
How to change the editing language in Excel?
  1. Go to the File tab from the Ribbon.
  2. Click Options.
  3. Click Language from the menu.
  4. In the “Choose Editing Languages” part, find the language you want from the “Add Additional Editing Language” list.
  5. Press the ADD button (if a browser page opens, click the Download button and run the downloaded file.)
in the File tab from the Excel ribbon, click Options then Language. In the “Choose Editing Languages” part, select and add your preferred language

You can also remove the language or set it as the default Excel language by pressing two buttons (Remove and Set as Default) on the right side of the Choose Editing Language section.

You can remove the language or set it as default in Excel language using the Remove and Set as Default buttons of the Choose Editing Language section.
How do I change the display language in Excel?
  1. Go to the File tab from the Ribbon.
  2. Click Options.
  3. Select Language.
  4. Under the “Choose Display and Help Language” section, there are two boxes for Display and Help language.
  5. You can set the display language (the language for tabs, buttons, and help) based on your Microsoft Windows default language.
in the language section of the Excel Options window, change the display and help the language of excel under the choose display and help languages
6- Advanced
How to enable or disable edit mode in Excel?
  1. Click the File tab from the Ribbon.
  2. Go to the Options from the left menu.
  3. Click Advanced.
  4. From the “Editing Options” part, check or uncheck the “Allow Editing Directly in Cells” checkbox.
in the advanced section of the Excel Options window, check the “Allow Editing Directly in Cells” options to enable editing mode
How to change the ruler default units in Excel?
  1. Go to the File tab.
  2. Select Options.
  3. Click Advanced.
  4. On the “Display” section, choose the desired units from the “Ruler Units” drop-down list.
in the advanced section of the Excel Options window, under “Display”, choose the desired units from the “Ruler Units” drop-down list
How to enable or disable multi-threaded calculation?
  1. Go to the File tab from the Ribbon.
  2. Click Options to pops-up the Excel options dialogue box.
  3. Select Advanced.
  4. On the “Formulas” part, check or uncheck the “Enable Multi-Threaded Calculation” checkbox (you can set the number of calculation threads manually under this checkbox.)
in the advanced section of the Excel Options window, under “Formulas”, check or uncheck the “Enable Multi-Threaded Calculation” checkbox
7- Customize Ribbon
How to customize the ribbon in Excel?
  1. Go to the File tab.
  2. Select Options from the left menu.
  3. Click Customize Ribbon.
  4. Change the Commands or the Ribbon based on your desire.
in the customize section of the Excel Options window, you can change the Commands or the Ribbon based on your desire

You can also click right on the Ribbon and select Customize the Ribbon from the menu.

right click on the the Excel ribbon and select Customize the Ribbon from the menu
How to create a new tab in Excel?
  1. Right-click on the Ribbon area.
  2. Click Customize the Ribbon.
  3. Press New Tab.
  4. Select the new tab (custom) from the drop-down list.
  5. Press Rename to choose a name for the new tab.
  6. Press OK.
In the Customize Ribbon section of Excel options window, select the new tab and type in the new name of the tab in the box that opens to rename it.
How to add a command to the ribbon in Excel?

Whenever you want to add a custom command to your Excel ribbon, you have to create a custom group. You can follow these steps to add your desired command:

  1. Right-click on the Ribbon area.
  2. Select Customize the Ribbon.
  3. Select a tab from the right-side drop-down list to add the command. Also, you can create a new tab by pressing the New Tab button and name it by pressing the Rename button.)
  4. Press the New Group button.
  5. Press the Rename button to select a symbol and change the Display name.
  6. Choose the command from the left drop-down list.
  7. Press the Add button between the two drop-down lists.
  8. Press Ok.
How to add a command to the ribbon in Excel
How to remove a command from the ribbon in Excel?
  1. Right-click on the Ribbon area.
  2. Click Customize the Ribbon.
  3. From the right-side drop-down list, find the command and right-click on it.
  4. Click Remove.
  5. Press OK.
In the Customize the Ribbon section of the Excel options window, find the command you want to remove and right-click on it. Click Remove. Press OK.
How to hide or show a tab or a group in Excel?
  1. Right-click on the Ribbon area.
  2. Select Customize the Ribbon.
  3. You can check or uncheck tabs or groups to show or hide them.
  4. Press OK.
How can I reset my ribbon customization in Excel?
  1. Right-click on the Ribbon area.
  2. Select Customize the Ribbon.
  3. Click the Reset button.
  4. You can reset a customized tab or all customizations.
  5. Press OK.
Right-click on the Ribbon area. Select Customize the Ribbon. Click the Reset button. You can reset a customized tab or all customizations. Press OK.
How to customize built-in tabs in Excel?

You can build your desired ribbon by learning RibbonX (VBA) and getting absolute control over the Excel Ribbon.

8- Quick Access Toolbar
Quick Access Toolbar in excel
How to add more buttons to the quick access toolbar?
  1. Right-click on the Ribbon area.
  2. Click Customize Quick Access Toolbar.
  3. Choose the command you need from the left-side drop-down list.
  4. Press the Add button.
  5. Press OK
In the Customize Quick Access Toolbar section of the excel options window, choose a command from the left side drop-down list, press Add, click OK.
How to remove a button from the quick access toolbar?
  1. Right-click on the Ribbon area.
  2. Click Customize Quick Access Toolbar.
  3. Choose the command you want to remove from the right-side drop-down list.
  4. Press the Remove button.
  5. Press OK.
In the Customize Quick Access Toolbar section of the excel options window, choose a command you want to remove, and click Add then OK.
How can I move the quick access toolbar in Excel?
  1. Right-click on the Ribbon area.
  2. Click Show Quick Access Toolbar below the Ribbon.
  3. The Quick Access toolbar will appear under the ribbon.
Right-click on the Ribbon area. Click Show Quick Access Toolbar below the Ribbon. The Quick Access toolbar will appear under the ribbon.

You can right-click on the Ribbon area and click Show Quick Access Toolbar Above the Ribbon to return it above the ribbon.

How to reset a quick access toolbar customization in Excel?
  1. Right-click on the Ribbon area.
  2. Select Customize quick access toolbar.
  3. Click the Reset button.
  4. You can reset a customized command or all customizations.
  5. Press OK.
Click the Reset button in the Customize quick access toolbar of the excel options window. select reset a customized command or all customizations.
9- Add-Ins
Excel add-ins section in the excel options window
How to add solver add-in to Excel?
  1. Go to the File tab.
  2. Click Options.
  3. Click Add-Ins.
  4. From the Manage drop-down list, select Excel add-ins.
  5. Press Go.
  6. On the Add-Ins dialogue box, check Solver Add-in.
  7. Press OK.
  8. You can find the Solver button in Analyze group from the Data tab.

If you need to work with the Solver Add-In option in Excel, check out our “How to Use Solver in Excel” blog. You can also add the Analysis Tool Pak –VBA and Euro Currency Tools to Excel by these steps.

10- Trust Center
  1. Go to the File tab.
  2. Click Options.
  3. Click Trust Center.
  4. Press the Trust Center Setting button.
  5. Change the setting you need.
  6. Press OK.

The great point about software such as Excel and Microsoft Suit as a whole is its customization options. They can help you with your workflow and efficiency. 

We tried to gather the common questions about the customizations of the workbook in Excel. But if you have any other relevant questions or need help building your workspace, get in touch with us with Microsoft Excel Consulting Team and Excel Support.

Subscribe to our Newsletter

Share this post with your friends

Leave a Reply

Your email address will not be published.