You can use "Copy" (Ctrl+C) and "Paste" (Ctrl+V) options, but there is a faster way to "copy" a formula to multiple adjacent cells.

If you have lengthy text in a cell, you can force Excel to display it in multiple lines within the cell.