When you first open Excel, there are, by default, two toolbars visible above the worksheet area - the Standard toolbar and the Formatting toolbar. These toolbars contain many of the commands that you will use in Excel on a regular basis.
So, it is a good thing that they are there, but unfortunately -- in my opinion -- the toolbars are side by side on one line, which means that many of the buttons are hidden from view.
To Quickly Separate the Toolbars Onto Two Lines
- Click on either of the available toolbars' Options buttons (there is one at the end of each toolbar). This toolbar Options button is shown circled in red in the image.
- Click on the Show Buttons on Two Rows option from the drop down menu. The toolbars will split onto two lines, making all of the buttons visible and readily available for use.
If you want the toolbars back on one row (splitting them into two rows does make the worksheet area slightly smaller) just repeat the above steps. This time, though, the option in the drop down menu will read Show Buttons on One Row
