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

0
=
0
+
0
No specific Bitcoin Bounty has been announced by author. Still, anyone could send Bitcoin Tips to those who provide a good answer.
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

1
=
1
=
$1.35
1 tip with total amount of 3.43 mBTC($1.35 USD) have been sent by alex

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

SEND BITCOIN TIPS
User rating:

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

0

Too many commands? Learning new syntax?

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

Boost your productivity with FavScripts.com!

Post Answer