Category: Excel Shortcuts

The shortcut Ctrl+Shift+7 is to apply an outline border to the selected cells. Please also refer to the shortcut Ctrl+Shift+Ampersand (&). Step 1: Select the data range you want …

The shortcut Ctrl+Shift+6 is to apply the scientific number format with two decimal places. Step 1: Select the data range you want to change the data format; Step 2: …

The shortcut Ctrl+Shift+5 is to format data into percentages without decimal places, e.g., 4 to 400%. Step 1: Select the data range you want to turn into percentages; Step …

The shortcut Ctrl+Shift+4 is to apply the Currency format with two decimals. Please also refer to Ctrl+Shift+Dollar Sign ($). Step 1: Select the data you want to add dollar …

The shortcut Ctrl+Shift+3 is to apply the date format with the day, month and year, please also see shortcut Ctrl+Shift+Number Sign (#). Step 1: Select the data you want …

The shortcut Ctrl+Shift+2 is to apply the time format with the hour and minute, and AM or PM. Step 1: Select all the numbers that you want to format; …