You can show or hide list of formulas while typing in Excel with the help of a shortcut key. Press Alt+Down arrow or make it invisible.

Launch Excel and open one of your documents. Locate the status bar at the bottom of the window. Right-click that status bar to display a list of options.

Highlighting or even deleting duplicate records in Excel is simple but listing them isn't as easy. Fortunately, you can use Power Query to easily display a list of duplicate values or records.