In Excel, the formula bar is the toolbar at the top of the spreadsheet that lets you enter or view the information in a cell. ... The Ctrl+Shift+U key is used to expand or collapse the Formula Bar.

How to display or hide the formula bar in Excel? Open your spreadsheet and click on the File menu. Next, click on Excel Options and move to the Advanced tab. Scroll to the Display section. Uncheck the ...

Select the array of cells that you want to collapse and expand. Click "Data" in the Excel ribbon. Click "Group" in the ribbon's Outline section to open a pop-up menu.