If your company is working with a large list in an Excel spreadsheet, take advantage of the program's built-in filter customization tools to limit the number of rows included in your filter results.

SEE: How to add a drop down list to an Excel cell (TechRepublic ... That dropdown list in the Row Labels cell is an AutoFilter, similar to the filter you use in a normal data set.

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. You can also add a row in Excel by ...