To insert multiple rows in Excel, first highlight the number of rows you want to add. Then, right-click the selected rows and click Insert in the context menu.

Insert Line Break in Excel To move to a new line in an Excel cell, simply type text in the cell as normal and then press enter while holding down the alt key.

SEE: How to add a drop down list to an Excel cell (TechRepublic) This article assumes you know how to build a basic pivot table, but also provides instructions for building the example pivot table.