The formula bar in Excel is above the spreadsheet, under the Ribbons. It displays the contents of the current cell. If the current contents is a result of a formula/function, it actually displays the formula/function.
If there is a lot of information in a cell, or there are two or more lines of info, the formula bar display is limited to one line.
Press Control + Shift + U to expand the display in the formula bar to display up to 3 lines of cell contents. Press Control + Shift + U to restore the default formula bar size.
Expand Formula Bar in Excel Spreadsheets
posted in: Shortcut of the Week
0
Leave a Reply