RAMAKAYAL COMPUTER EDUCATION

Author: Saravana Kumar

  • Microsoft Word – Shortcut Keys

    Microsoft Word has a variety of shortcut keys to help streamline your workflow. Here are some of the most commonly used ones:

    Basic Shortcuts

    • Ctrl + N: New document
    • Ctrl + O: Open document
    • Ctrl + S: Save document
    • Ctrl + P: Print document
    • Ctrl + Z: Undo
    • Ctrl + Y: Redo

    Text Formatting

    • Ctrl + B: Bold
    • Ctrl + I: Italic
    • Ctrl + U: Underline
    • Ctrl + E: Center alignment
    • Ctrl + L: Left alignment
    • Ctrl + R: Right alignment
    • Ctrl + J: Justify alignment
    • Ctrl + Shift + D: Double underline

    Text Navigation and Selection

    • Ctrl + A: Select all
    • Ctrl + C: Copy
    • Ctrl + X: Cut
    • Ctrl + V: Paste
    • Ctrl + F: Find
    • Ctrl + H: Replace
    • Ctrl + Left/Right Arrow: Move cursor one word to the left/right
    • Ctrl + Up/Down Arrow: Move cursor one paragraph up/down
    • Shift + Left/Right Arrow: Select one character to the left/right
    • Shift + Up/Down Arrow: Select one line up/down
    • Ctrl + Shift + Left/Right Arrow: Select one word to the left/right
    • Ctrl + Shift + Up/Down Arrow: Select one paragraph up/down
    • Ctrl + [ : To Increase Font Size
    • Ctrl + ] : To Decrease Font Size

    Advanced Formatting

    • Ctrl + 1: Single line spacing
    • Ctrl + 2: Double line spacing
    • Ctrl + 5: 1.5 line spacing
    • Ctrl + M: Increase indent
    • Ctrl + Shift + M: Decrease indent
    • Ctrl + T: Hanging indent
    • Ctrl + Shift + T: Reduce hanging indent

    Working with Documents

    • Ctrl + F2: Print Preview
    • F12: Save As
    • Ctrl + Shift + F12: Print
    • Ctrl + F4: Close document
    • Alt + Ctrl + F2: Open document
    • Alt + F4: Exit Word

    Miscellaneous

    • Ctrl + K: Insert hyperlink
    • Ctrl + Shift + A: All caps
    • Ctrl + Shift + F: Change font
    • Ctrl + Enter: Insert page break

    Ribbon Shortcuts

    • Alt: Activates ribbon commands

    These shortcuts can help you work more efficiently in Microsoft Word by reducing the need to navigate through menus and options manually.

  • Microsoft Excel – Shortcut Keys

    Microsoft Excel offers a wide range of keyboard shortcuts to help you work more efficiently. Here are some of the most commonly used shortcut keys in Excel:

    Navigation Shortcuts

    • Arrow Keys: Move one cell up, down, left, or right.
    • Ctrl + Arrow Keys: Move to the edge of data region.
    • Tab: Move one cell to the right.
    • Shift + Tab: Move one cell to the left.
    • Page Down: Move one screen down.
    • Page Up: Move one screen up.
    • Alt + Page Down: Move one screen to the right.
    • Alt + Page Up: Move one screen to the left.
    • Ctrl + Home: Move to the beginning of a worksheet.
    • Ctrl + End: Move to the last cell with content.

    Cell Selection Shortcuts

    • Ctrl + Space: Select the entire column.
    • Shift + Space: Select the entire row.
    • Ctrl + A: Select the entire worksheet.
    • Shift + Arrow Keys: Extend the selection by one cell.

    Data Entry Shortcuts

    • Enter: Complete a cell entry and move down.
    • Tab: Complete a cell entry and move to the right.
    • Shift + Tab: Complete a cell entry and move to the left.
    • Ctrl + Enter: Fill the selected cells with the current entry.
    • Alt + Enter: Start a new line in the same cell.

    Formatting Shortcuts

    • Ctrl + B: Bold.
    • Ctrl + I: Italic.
    • Ctrl + U: Underline.
    • Ctrl + 1: Format cells dialog box.
    • Ctrl + Shift + $: Apply currency format.
    • Ctrl + Shift + %: Apply percentage format.
    • Ctrl + Shift + ^: Apply exponential format.
    • Ctrl + Shift + #: Apply date format.
    • Ctrl + Shift + @: Apply time format.
    • Ctrl + Shift + !: Apply number format with two decimal places.

    Editing Shortcuts

    • F2: Edit the active cell.
    • Ctrl + X: Cut.
    • Ctrl + C: Copy.
    • Ctrl + V: Paste.
    • Ctrl + Z: Undo.
    • Ctrl + Y: Redo.
    • Delete: Clear cell contents.
    • Ctrl + “-” (minus): Delete selected cells.
    • Ctrl + “+” (plus): Insert cells.

    Function and Formula Shortcuts

    • =: Start a formula.
    • Alt + =: Insert the AutoSum formula.
    • F4: Repeat the last action or toggle absolute/relative references in a formula.
    • Ctrl + Shift + Enter: Enter an array formula.

    Worksheet Management Shortcuts

    • Ctrl + N: New workbook.
    • Ctrl + O: Open workbook.
    • Ctrl + S: Save workbook.
    • F12: Save As.
    • Ctrl + P: Print.
    • Ctrl + F4: Close workbook.
    • Ctrl + Tab: Switch between open workbooks.
    • Shift + F11: Insert a new worksheet.
    • Ctrl + Page Down: Move to the next worksheet.
    • Ctrl + Page Up: Move to the previous worksheet.

    Miscellaneous Shortcuts

    • F1: Open Help.
    • F7: Spell check.
    • Alt + F8: Open the Macro dialog box.
    • Ctrl + F: Find.
    • Ctrl + H: Replace.
    • Alt + F11: Open the Visual Basic for Applications editor.

    These shortcuts can significantly enhance your productivity by allowing you to perform tasks quickly without needing to navigate through menus.