MS Excel - how to create a new line in the formula bar?

0

MS Excel - how to create a new line in the formula bar? Is there any keyboard shortkey? I've tried Ctrl+Enter combination but that did not work

Tags:

1 Answer

Answer:

  • you should use Alt+Enter shortcut key combo, however:
  • in formula bar, it only works if current text already has "text wrap" formatting option ON
  • however, in the cell that is in the middle of the spreadsheet, it works right away, AND it also turns "text wrap" ON for that cell right away if it was OFF

HTH

User rating:

Thanks dude, please have some coins so you could do more testing :)

0

Too many commands? Learning new language?

FavScripts.com is a free tool that allows you to save your favorite scripts and commands, then quickly find and copy-paste your commands with just few clicks.

Boost your daily productivity with FavScripts.com!

Post Answer