Thursday, May 25, 2023

The Secret Shortcut You Need to Know About the Excel Formula Bar!

Microsoft Excel
Are you tired of scrolling left and right to view long formulas in Microsoft Excel? 

Do you want to learn a quick and easy way to expand the formula bar? 

Expanding the formula bar in Microsoft Excel is a useful trick that can help you view long formulas without having to scroll left and right. 

There are two ways to expand the formula bar in Excel. 

  • The first way is to hover your mouse near the bottom of the formula bar until you see an up-and-down white arrow
    • Click that arrow and drag down until the bar gets big enough to accommodate the entire formula. 
  • The second way is to use a keyboard shortcut: Press Ctrl + Shift + U.
Microsoft Excel Formula Bar
fig. 1 - Expand the Excel Formula Bar

Please LIKE and SHARE!

Cool Tech Tips for a Cooler Life!

#Microsoft #Excel #MicrosoftExcel @Microsoft #ExcelTips, #ExcelTricks, #ExcelShortcuts, #MicrosoftExcel, and #SpreadsheetHacks #TechTip #OneCoolTip 

No comments: