Often when you're entering data into a Microsoft Excel spreadsheet, you want certain cells to span multiple lines, either for addresses, multiline pieces of information or just for readability. But if ...

Microsoft Excel 2013 surrounds the active cell with a dark border to help identify the cell you are editing. Pressing the Enter key after editing the cell moves the active cell to the next cell down.

Many people think the Enter key in Excel is just for moving down a row, and Ctrl is for shortcuts like copy or paste. But when used together, Ctrl+Enter unlocks hidden behaviors that change how data ...