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.

If you use Excel 40 hours a week (and those are the weeks you are on vacation), welcome to the MrExcel channel. Home to 2,400 free Excel tutorials. Bill "MrExcel" Jelen is the author of 67 books about ...

By default, when you select a formula or source field in a dialog box, Enter mode is activated. You can see this in the ...