How to hide a custom or default tab from the ribbon in Excel

How to hide a custom or default tab from the ribbon in Excel

  1. Click on “Excel”, select a workbook to edit
  2. Place your mouse in any empty space in the ribbon like this
  3. Right-click and then click “Customize the Ribbon”
  4. Clear the check box next to the default tab or custom tab that you want to hide
  5. Click “OK”
  6. You have successfully hidden a default tab from the ribbon

How to re-add a removed custom or default group in Excel

How to re-add a removed custom or default group in Excel

  1. Click on “Excel”, select a workbook to edit
  2. Click “File”
  3. Click “Options”
  4. Select the “Customize Ribbon” tab in the Options dialog box
  5. Ensure that the “Customize the Ribbon” box is set to “Main Tabs” or “All Tabs”
  6. Select the tab whose custom or default group you want to re-add
  7. At the bottom of the dialog box, open the list box named “Reset”
  8. Select “Reset only selected Ribbon tab”
  9. Click “OK”
  10. You have successfully re-added a removed default group

How to remove a default or custom group in Excel

How to remove a default or custom group in Excel

  1. Click on “Excel”, select a workbook to edit
  2. Place your mouse in any empty space in the ribbon like this
  3. Right-click and then click “Customize the Ribbon”
  4. Under the “Customize the Ribbon” list, click the group that you want to remove
  5. Let’s select this one
  6. Click “Remove”
  7. Click “OK”
  8. You have successfully removed a default group

How to change theme color in Excel

How to change theme color in Excel

  1. Click on “Excel”, select a workbook to edit
  2. Click the “Page Layout” tab
  3. Click “Colors” dropdown button
  4. Select the theme color you want from available ones
  5. Let’s select this one
  6. You have successfully changed theme color in Excel

How to change theme font in Excel

How to change theme font in Excel

  1. Click on “Excel”, select a workbook to edit
  2. Click the “Page Layout” tab
  3. Click “Fonts” dropdown button
  4. Select the theme font you want from available ones
  5. Let’s select this one
  6. You have successfully changed theme font in Excel