If Excel is not highlighting cells in the formula, enable 'Allow editing directly in cells' and 'Enable fill handle and cell drag-and-drop' in Excel options.

To display specific values in a PivotTable in Microsoft Excel, use one of the many built-in filters, such as Top 10.

How to enable a macro in Excel for one time only If you want to run a particular macro just one time, you can configure Excel's security settings for that as well. 1.