Excel is a powerful spreadsheet software developed by Microsoft.

It is widely used by
businesses and individuals to manage, analyze, and visualize data. Here are some key
features and functions of Excel:

shortcuts:

1. General
• Ctrl + N: Create a new workbook
• Ctrl + O: Open an existing workbook
• Ctrl + S: Save the current workbook
• Ctrl + W: Close the current workbook
• Ctrl + F4: Close the Excel program
2. Navigation
• Ctrl + Home: Go to the first cell in the worksheet
• Ctrl + End: Go to the last cell in the worksheet
• Ctrl + Page Up: Switch to the previous worksheet
• Ctrl + Page Down: Switch to the next worksheet
• Ctrl + Arrow keys: Move to the edge of the current data region
• Ctrl + G: Go to a specific cell
• Ctrl + F: Find data within the worksheet
• Ctrl + H: Replace data within the worksheet
3. Selection
• Ctrl + A: Select all cells within the worksheet
• Shift + Arrow keys: Extend the current selection
• Ctrl + Shift + Arrow keys: Extend the current selection to the last non-
blank cell
• Shift + F8: Add to the current selection
• Ctrl + Shift + F8: Remove from the current selection
4. Editing
• F2: Edit the active cell
• Ctrl + Z: Undo last action
• Ctrl + Y: Redo last action
• Ctrl + X: Cut selected cells
• Ctrl + C: Copy selected cells
• Ctrl + V: Paste copied cells
• Ctrl + Shift + V: Paste special
• Ctrl + D: Fill down
• Ctrl + R: Fill right
• F4: Repeat the last action
• Alt + Enter: Start a new line within a cell
5. Formatting
• Ctrl + B: Apply bold formatting to selected cells
• Ctrl + I: Apply italic formatting to selected cells
 • Ctrl + U: Apply underline formatting to selected cells
• Ctrl + 1: Open the Format Cells dialog box
• Ctrl + Shift + $: Apply currency formatting
• Ctrl + Shift + %: Apply percentage formatting
• Ctrl + Shift + #: Apply date formatting
• Ctrl + Shift + @: Apply time formatting
6. Formulas and functions
• F9: Recalculate all formulas within the worksheet
• Shift + F9: Calculate the active worksheet
• Ctrl + Shift + U: Expand or collapse the formula bar
• Ctrl + Shift + Enter: Enter a formula as an array formula
• F3: Open the Paste Name dialog box
• Alt + =: AutoSum
• Ctrl + Shift + A: Insert function arguments
• Ctrl + Shift + F3: Create a name for the selected cells
• F4: Change the reference style
7. Tables and PivotTables
• Ctrl + L: Create a table
• Ctrl + T: Insert a table
• Ctrl + Shift + T: Convert a range to a table
• Ctrl + Shift + F: Open the Filter dropdown menu
• Alt + Down arrow: Open the Filter dropdown menu
• Alt + ;: Select visible cells
• Ctrl + Shift + L: Toggle AutoFilter
• Alt + J + T: Create a PivotTable
1. Navigation Shortcuts
• Ctrl + A: Select all cells in the current worksheet
• Ctrl + B: Bold highlighted text
• Ctrl + C: Copy selected cells
• Ctrl + D: Fill down selected cells
• Ctrl + F: Open the Find and Replace dialog box
• Ctrl + G: Go to a specific cell
• Ctrl + H: Open the Find and Replace dialog box with the Replace tab selected
• Ctrl + I: Italicize highlighted text
• Ctrl + K: Insert a hyperlink
• Ctrl + N: Create a new workbook
• Ctrl + O: Open an existing workbook
• Ctrl + P: Open the Print dialog box
• Ctrl + R: Fill right selected cells
• Ctrl + S: Save the current workbook
• Ctrl + U: Underline highlighted text
• Ctrl + V: Paste copied cells
• Ctrl + W: Close the current workbook
• Ctrl + X: Cut selected cells
• Ctrl + Y: Redo last action
• Ctrl + Z: Undo last action
• Ctrl + F1: Hide or unhide the ribbon
• Ctrl + F2: Open the Print Preview window
• Ctrl + F4: Close the active workbook
• Ctrl + F6: Switch between open workbooks
• Ctrl + F9: Minimize the current workbook
• Ctrl + F10: Maximize or restore the current workbook window
• Ctrl + F11: Create a new worksheet in the current workbook
• Ctrl + Tab: Switch to the next open workbook
• Ctrl + Shift + Tab: Switch to the previous open workbook
• Ctrl + Page Up: Move to the previous worksheet
• Ctrl + Page Down: Move to the next worksheet
• Alt + =: Insert the SUM function
2. Editing Shortcuts
• F2: Edit the active cell
• F3: Paste a defined name into a formula
• F4: Repeat the last action
• F5: Open the Go To dialog box
• F6: Switch between the worksheet, ribbon, task pane, and Zoom controls
• F7: Open the Spelling dialog box
• F8: Turn on Extend mode
• F9: Recalculate all formulas in the worksheet
• F10: Activate the menu bar
• F11: Create a chart of the current data in a separate sheet
• F12: Open the Save As dialog box
3. Formula Shortcuts
• Alt + =: Insert the SUM function
• Alt + Enter: Start a new line within a cell
• Ctrl + Shift + Enter: Enter an array formula
• Ctrl + `: Show or hide formulas
• Ctrl + ;: Insert the current date
• Ctrl + Shift + ;: Insert the current time
• Ctrl + Shift + #: Format cells as date
• Ctrl + Shift + $: Format cells as currency
• Ctrl + Shift + %: Format cells as percentage
• Ctrl + Shift + ^: Format cells as scientific notation
• Ctrl + Shift + ~: Format cells as general
• Ctrl + Shift + @: Format cells as time