Excel Keyboard Shortcuts Quiz

Excel Keyboard Shortcuts

• CTRL+PgUp: Navigate between worksheet tabs from left to right.
• CTRL+PgDn: Navigate between worksheet tabs from right to left.
• CTRL+SHIFT+(: Unhide any hidden rows in the selected area.
• CTRL+SHIFT+): Unhide any hidden columns in the selected area.
• CTRL+SHIFT+&: Apply an outline border to selected cells.
• CTRL+SHIFT+_: Remove the outline border from selected cells.
• CTRL+SHIFT+~: Apply the General number format to selected cells.
• CTRL+SHIFT+$: Apply Currency format to selected cells (two decimal places; negative values in parentheses).
• CTRL+SHIFT+%: Apply Percentage format to selected cells (no decimal places).
• CTRL+SHIFT+^: Apply Exponential number format to selected cells (two decimal places).
• CTRL+SHIFT+#: Apply Date format to selected cells (day, month, year).
• CTRL+SHIFT+@: Apply Time format to selected cells (hour, minute, AM/PM).
• CTRL+SHIFT+!: Apply Number format (two decimal places; thousands separator for negatives).
• CTRL+SHIFT+*: Select the current region around the active cell (data area enclosed by blank rows/columns).
• CTRL+SHIFT+:: Enter the current time in the active cell.
• CTRL+SHIFT+": Copy the value from the cell above into the active cell.
• CTRL+SHIFT+Plus (+): Open the Insert dialog box for adding blank cells.
• CTRL+Minus (-): Open the Delete dialog box for deleting selected cells.
• CTRL+;: Enter the current date in the active cell.
• CTRL+`: Toggle between showing cell values and formulas in the worksheet.
• CTRL+': Copy a formula from the cell above into the active cell.
• CTRL+1: Display the Format Cells dialog box.
• CTRL+2: Toggle bold formatting on selected cells.
• CTRL+3: Toggle italic formatting on selected cells.
• CTRL+4: Toggle underlining on selected cells.
• CTRL+5: Toggle strikethrough formatting on selected cells.
• CTRL+6: Switch between hiding objects, displaying objects, and showing placeholders for objects.
• CTRL+8: Toggle display of outline symbols.
• CTRL+9: Hide selected rows in the worksheet.
• CTRL+0: Hide selected columns in the worksheet.
• CTRL+A: Select the entire worksheet or the current data region, depending on context.
• CTRL+SHIFT+A: Insert argument names and parentheses in formulas when the cursor is at a function name.
• CTRL+B: Toggle bold formatting on selected cells.
• CTRL+C: Copy selected cells; pressing again opens the Clipboard.
• CTRL+D: Fill down command to copy contents and format from the top cell into selected cells below.
• CTRL+E: Function is currently available.
• CTRL+F: Open the Find and Replace dialog box (Find tab).
• SHIFT+F5: Same function as CTRL+F; opens Find and Replace dialog.
• SHIFT+F4: Repeat the last Find action.
• CTRL+SHIFT+F: Open Format Cells dialog box (Font tab).
• CTRL+G: Open the Go To dialog box; same as pressing F5.