You can easily create a drop-down list in Excel to limit the values that can be entered in a column. Here's how to set one up.

Let's say you're working in an Excel worksheet and realize that you need to insert additional rows of data. Luckily, Excel has a built in feature to allow users to insert multiple blank rows.

How to Make Blank Rows Between Populated Rows in Excel. Spreadsheet applications like Excel enable you to insert, delete or rearrange entire rows of business data in ways that are difficult or ...

If you want to display multiple subtotals in your Microsoft Excel PivotTables, learn how to use a hard-to-find setting.