• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Rearrange the Ribbon in Excel

September 2, 2021 by Andrew Childress
How to rearrange ribbon in Excel

Excel’s ribbon is truly the control center for your spreadsheets. Let’s learn how to rearrange the ribbon in Microsoft Excel.

Excel’s ribbon is truly the control center for your spreadsheets. The ribbon is the series of tabs, menus, and options found at the top of your screen just above the formula bar. On the ribbon, you’ll see Home, Insert, Draw, and more. But did you know that you can customize the ribbon to fit your needs? You can, and it’s very easy. Let’s learn how to rearrange the ribbon in Microsoft Excel.

How to Rearrange the Ribbon in Excel

The options on Excel’s ribbon are placed in a certain order by default. But you might find it useful to rearrange this design to streamline your workflow. For example, you might want to move certain tabs that you use often closer together.

To rearrange the ribbon in Excel, begin by clicking on the File dropdown menu. You’ll find this in the far upper left corner of your screen. From the dropdown, click Preferences.

Rearrange the ribbon in Excel

The Excel Preferences menu will open up. It has several options available, and the one you’re looking for is called Ribbon & Toolbar. Click on it, and you’ll see even more choices.

Rearrange Excel ribbon

On the right side, you’ll see the Main Tabs section of the Customize the Ribbon menu. Here, you can specify the features to display on each of the ribbon’s tabs. For example, in the Home section, you’ll see Clipboard, Font, Alignment, and more.

How to rearrange ribbon in Excel

Here is where you rearrange the ribbon. Remember that this list, displayed top to bottom, represents left to right on Excel’s ribbon. To move an option to the left, simply click and drag on its name, and move it to a new spot in the sequence. Excel will make the move, and you’ll see the change reflected on the given ribbon tab itself.

When you’re finished, simply click Save. Excel will save your ribbon rearrangements, and they’ll be maintained every time to use the app. It’s a quick and easy way to make Excel work better for you.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Hour in ExcelHOUR in Excel
Next Post:Zoom in ExcelHow to Zoom in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top