Control+Option+Return Not Working

Copper Contributor
Hello,
I am attempting to enter a line break in excel on my MacBook and the keyboard shortcut control+option+return is not working. Any suggestions on how to fix this?

Thanks!
9 Replies

Hi @Meghan96 

 

Just to make sure you follow these steps to insert a new line break

Here are the steps to start a new line in Excel Cell using the shortcut in Mac

  1. Double click on the cell where you want to insert the line break.
  2. Place the cursor where you want to insert the line break.
  3. Hold  Control and Option keys and hit the Enter key.

@Meghan96 

Don't forget to apply Wrap Text to the cell(s)

@SergeiBaklan I have tried the "control + option + enter" combo and ensured the wrap text but it isn't working. It is not breaking the entries into their own lines. Any other ideas?

@izsyy 

Sorry, I'm not on Mac. Please check this Start new line in Excel cell - 3 ways to add carriage return (ablebits.com) , perhaps Control+Command+Return will work 

@Meghan96 I have the same problem, but intermittent. This seems to have happened when upgrading to latest Excel through O365....

@Meghan96 

Try with Command + Shift + Enter. It will work to split the line excel cell in Mac

@Ravireddy 'option' + 'enter' works. 

command + shift + enter worked for me. None of the other options listed here worked. Im using Excel 16.70 on a MacBook Pro.

@Meghan96 Was having same issue when I logged in for work (from Mac).. ‘Command’ + ‘option’ worked for me.