Questions and Answers
What does CTRL+PgUp do?
What does CTRL+PgDn do?
What is the function of CTRL+SHIFT+(
What does CTRL+SHIFT+) do?
Signup and view all the answers
What is the result of using CTRL+SHIFT+&?
Signup and view all the answers
What does CTRL+SHIFT+_ do?
Signup and view all the answers
What format does CTRL+SHIFT+$ apply?
Signup and view all the answers
What does CTRL+SHIFT+% do?
Signup and view all the answers
What number format does CTRL+SHIFT+! apply?
Signup and view all the answers
What does CTRL+SHIFT+: do?
Signup and view all the answers
What function does CTRL+1 serve?
Signup and view all the answers
What does CTRL+C do?
Signup and view all the answers
What is the action of CTRL+D?
Signup and view all the answers
Study Notes
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.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Test your knowledge of essential Excel keyboard shortcuts with this quiz. Learn how to efficiently navigate and format data in your spreadsheets using these time-saving commands. From unhiding rows to applying number formats, see how well you know your Excel skills!