Shortcuts are keyboard combinations that can do specific actions in Excel
Here’s a comprehensive list of Excel shortcuts categorized for easy reference, along with examples to illustrate their use.
Basic Shortcuts
| Shortcut | Action | Example |
|---|---|---|
| Ctrl + N | Create a new workbook | Opens a blank Excel file. |
| Ctrl + O | Open an existing workbook | Opens the file selection window. |
| Ctrl + S | Save the workbook | Saves your changes to the file. |
| Ctrl + P | Print the workbook | Opens the print menu. |
| Ctrl + W | Close the workbook | Closes the current workbook. |
| Ctrl + C | Copy | Copies selected text or cell content. |
| Ctrl + X | Cut | Cuts selected text or cell content. |
| Ctrl + V | Paste | Pastes copied/cut data. |
| Ctrl + Z | Undo | Reverses the last action. |
| Ctrl + Y | Redo | Restores an undone action. |
Navigation Shortcuts
| Shortcut | Action | Example |
|---|---|---|
| Arrow Keys | Move between cells | Moves selection in the arrow's direction. |
| Ctrl + Arrow Key | Jump to the last non-empty cell in the direction | If A1 is selected, pressing Ctrl + ↓ moves to the last filled cell in column A. |
| Ctrl + Home | Go to A1 | Jumps to the first cell (A1). |
| Ctrl + End | Go to the last used cell | Moves to the last used row and column. |
| Page Up/Page Down | Scroll one screen up/down | Scrolls through the worksheet. |
| Alt + Page Up/Page Down | Move one screen left/right | Helps navigate large sheets. |
Selection Shortcuts
| Shortcut | Action | Example |
|---|---|---|
| Ctrl + A | Select the entire worksheet | Selects all the data in the sheet. |
| Shift + Arrow Key | Extend selection | Expands the selected range. |
| Ctrl + Shift + Arrow Key | Select a range to the last non-empty cell | Selects from the current cell to the last filled cell in a direction. |
| Shift + Space | Select entire row | Selects the entire row of the active cell. |
| Ctrl + Space | Select entire column | Selects the entire column of the active cell. |
Editing Shortcuts
| Shortcut | Action | Example |
|---|---|---|
| F2 | Edit active cell | Places the cursor inside the cell for editing. |
| Alt + Enter | Insert a new line within a cell | Adds a line break inside a cell. |
| Ctrl + D | Fill down | Copies the content of the topmost cell down. |
| Ctrl + R | Fill right | Copies the leftmost cell’s content to the right. |
| Ctrl + "-" | Delete selected cells/rows/columns | Removes the selection and shifts adjacent data accordingly. |
| Ctrl + "+" | Insert new cells/rows/columns | Adds new space to the sheet. |
Formula Shortcuts
| Shortcut | Action | Example |
|---|---|---|
| = (Equal Sign) | Start a formula | =SUM(A1:A10) sums the values in A1 to A10. |
| Ctrl + ` | Show formulas instead of values | Toggles between formula view and normal view. |
| F4 | Toggle absolute/relative cell reference | Changes A1 → $A$1 → A$1 → $A1 when editing a formula. |
| Alt + = | AutoSum | Quickly sums up a range. |
| Ctrl + Shift + Enter | Enter an array formula (for older versions) | Used to enter legacy array formulas. |
Formatting Shortcuts
| Shortcut | Action | Example |
|---|---|---|
| Ctrl + B | Bold | Makes text bold. |
| Ctrl + I | Italic | Italicizes text. |
| Ctrl + U | Underline | Underlines text. |
| Ctrl + 1 | Open Format Cells dialog | Allows formatting of numbers, alignment, etc. |
| Ctrl + Shift + $ | Apply currency format | Converts numbers to currency format (e.g., $123.45). |
| Ctrl + Shift + % | Apply percentage format | Converts a number into a percentage (e.g., 0.5 → 50%). |
| Ctrl + Shift + # | Apply date format | Formats numbers as a date (e.g., 03/15/2025). |
Worksheet Shortcuts
| Shortcut | Action | Example |
|---|---|---|
| Shift + F11 | Insert a new worksheet | Adds a new worksheet to the workbook. |
| Ctrl + Page Up | Move to the previous worksheet | Switches to the previous sheet. |
| Ctrl + Page Down | Move to the next worksheet | Switches to the next sheet. |
| Alt + H + O + R | Rename a worksheet | Opens the rename option for the current sheet. |
Data Handling Shortcuts
| Shortcut | Action | Example |
|---|---|---|
| Ctrl + T | Create a table | Converts a range into a table. |
| Ctrl + Shift + L | Apply/Remove filters | Adds or removes filters on column headers. |
| Alt + Down Arrow | Open drop-down list in filtered column | Displays available filter options. |
| Ctrl + Shift + U | Expand or collapse formula bar | Adjusts formula bar visibility. |
Pivot Table Shortcuts
| Shortcut | Action | Example |
|---|---|---|
| Alt + N + V | Insert a PivotTable | Opens the Create PivotTable dialog. |
| Alt + J + T + R | Refresh PivotTable | Updates PivotTable data. |
| Alt + J + T + I | Insert PivotChart | Adds a chart to PivotTable. |
Miscellaneous Shortcuts
| Shortcut | Action | Example |
|---|---|---|
| F7 | Spell check | Runs spell check on selected text. |
| F12 | Save As | Opens the Save As dialog. |
| Ctrl + Shift + " (Quotation) | Copy value from the cell above | Copies the above cell's value into the active cell. |
| Ctrl + Shift + : | Insert current time | Inserts the system's current time in the selected cell. |
| Ctrl + ; | Insert current date | Inserts today's date. |
This list covers most Excel shortcuts that boost productivity.
Excel is used extensively for
Data collection, analysis and presentation of information in a user
understandable format which can be easily understood by the normal user.
It is the most commonly used application as it is easily accessible and
available for all users.
Get the Palium Advantage
Regular & Fast Track Classes: Choose between weekday or weekend sessions to suit your schedule.
Expert Faculty: Learn from experienced industry professionals with real-world expertise.
Hands-On Learning: Practical training with real-time case studies and projects.
Flexible Learning Modes: Available in offline (classroom) and live online formats.
Placement Assistance: Get career support and job placement guidance.
Why Learn Advanced Excel?
Advanced Excel is a crucial tool for data analysis, financial modeling, reporting, and business decision-making. Mastering Excel can open opportunities in roles such as data analyst, business analyst, financial analyst, and MIS reporting.
Course Coverage
The course covers the following topics comprehensively -
- Conditional Formatting
- Visualizations
- Pivot Tables
- Formulas for Date, Text, Financial Calculations etc.
- Advanced Functions like Vlookup, XLookup, Match, Sumif, Sumifs etc.
Enroll Today!
Join Advanced Excel training at Palium Skills and gain the expertise to excel in your professional journey with comprehensive, practical, and job-oriented learning.
Take the next step in your professional journey with Palium Skills career building courses. Experience high-quality language training that ensures fluency and career growth.
📍 Location: Kolkata, India
📞 Phone: +919903130500
📧 Email: info@paliumskills.com
🌐 Website: https://paliumskills.com
Start learning Excel today and unlock global opportunities!
No comments:
Post a Comment