Podcast
Questions and Answers
What does CTRL+PgUp do?
What does CTRL+PgUp do?
- Displays the Format Cells dialog box.
- Applies or removes bold formatting.
- Copies the selected cells.
- Switches between worksheet tabs, from left-to-right. (correct)
What does CTRL+PgDn do?
What does CTRL+PgDn do?
- Switches between worksheet tabs, from right-to-left. (correct)
- Switches between worksheet tabs, from left-to-right.
- Hides the selected rows.
- Copies a formula from above.
What is the function of CTRL+SHIFT+(
What is the function of CTRL+SHIFT+(
- Applies the Currency format.
- Displays the Delete dialog box.
- Applies or removes strikethrough.
- Unhides any hidden rows within the selection. (correct)
What does CTRL+SHIFT+) do?
What does CTRL+SHIFT+) do?
What is the result of using CTRL+SHIFT+&?
What is the result of using CTRL+SHIFT+&?
What does CTRL+SHIFT+_ do?
What does CTRL+SHIFT+_ do?
What format does CTRL+SHIFT+$ apply?
What format does CTRL+SHIFT+$ apply?
What does CTRL+SHIFT+% do?
What does CTRL+SHIFT+% do?
What number format does CTRL+SHIFT+! apply?
What number format does CTRL+SHIFT+! apply?
What does CTRL+SHIFT+: do?
What does CTRL+SHIFT+: do?
What function does CTRL+1 serve?
What function does CTRL+1 serve?
What does CTRL+C do?
What does CTRL+C do?
What is the action of CTRL+D?
What is the action of CTRL+D?
Flashcards are hidden until you start studying
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.