Carriage return / new line in ms excel / openoffice spreadsheet

to insert a carriage return / new line in a cell in the two popular spreadsheets

Screenshot-Untitled1 - OpenOffice.org Calc.png

in Microsoft Excel
press alt+Enter

in OpenOffice Spreadsheet
press ctrl+Enter

Leave a Reply