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.

You can delete a pivot table in Excel with a few clicks on a Mac or Windows PC. Here are two ways to do it.