Restoring the drag-and-drop menu in your Excel Pivot Table is typically a quick fix. By using either right-click options or ribbon commands, you can easily access the field list again. If all else ...

Drop-down lists in Microsoft Excel (and Word and Access) allow you to create a list of valid choices that you or others can select for a given field. This is especially useful for fields that require ...