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.
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.
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.
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.