How to write more in an Excel cell

Basically, Excel caters for calculations.

 

Screen Shot 2016-06-13 at 6.23.58 PM

Therefore, it seems if cells can only be used for a limited amount of characters, depending on the breadth of the cell, which can be enlarged to fit more characters. However, you can insert more lines in a cell by following these steps:

  • Press alt+Enter (Windows) or
  • Press Alt+Option+Enter (Mac).
  • This will automatically set Wrap Text ON for the cell where you want to add more lines of text.

 

If you want to be updated when new posts are added, please complete the following form.

[sbscrbr_form]

(42 visits)

Leave a Reply