Category: Excel Shortcuts

The shortcut Ctrl+Shift+At Sign (@) is to apply the time format with hour, minute, and AM or PM. Step 1: Select the data you want to add time format; …

The shortcut Ctrl+Shift+Ampersand (&) will apply an outline border to the selected cells. Please refer to shortcut Ctrl+Shift+Underline to remove the outline border. Step 1: Select the data range …

The shortcut Ctrl+Semicolon (;) is one of the formatting shortcuts and it will enter the current date. Step 1: Click any cell you want to enter the time; Step …

The shortcut Ctrl+Q is to display the "Quick Analysis" options for the selected cells with data. Step 1: Click any cell in the data range (e.g., A1) Step 2: …

The shortcut Ctrl+Minus (-) is to display the "Delete" dialog box. Step 1: Select the contents that you want to delete; Step 2: Press and hold the key "Ctrl", …

The shortcut Ctrl+L is to display the "Create Table" dialog box, which is the same as the shortcut "Ctrl+T". Example: Step 1: Click anywhere in the data range, or …