MS Excel

Excel shortcuts

Mastering Excel shortcut keys can significantly boost your productivity. Here's a comprehensive list of some essential Excel shortcuts:

Navigation and Selection Shortcuts:

• Ctrl + Arrow keys: Move to the edge of the current data region in a worksheet.
• Ctrl + Space: Select entire column.
• Shift + Space: Select entire row.
• Ctrl + A: Select entire worksheet.
• Ctrl + Shift + Arrow keys: Extend the selection to the last nonblank cell in the same column or row.

Editing Shortcuts:

• F2: Edit the active cell.
• Ctrl + C: Copy selected cells.
• Ctrl + X: Cut selected cells.
• Ctrl + V: Paste copied or cut cells.
• Ctrl + Z: Undo last action.
• Ctrl + Y: Redo last action.
• Ctrl + D: Fill down.
• Ctrl + R: Fill right.
• Ctrl + - (minus): Delete selected cells.

Formatting Shortcuts:

• Ctrl + 1: Open the Format Cells dialog box.
• Ctrl + B: Apply or remove bold formatting.
• Ctrl + I: Apply or remove italic formatting.
• Ctrl + U: Apply or remove underline.
• Ctrl + E: Center align.
• Ctrl + L: Left align.
• Ctrl + R: Right align.
• Ctrl + 5: Apply or remove strikethrough formatting.

Function Shortcuts:

• Alt + =: AutoSum.
• Ctrl + Shift + $: Apply currency format.
• Ctrl + Shift + %: Apply percentage format.
• Ctrl + Shift + #: Apply date format.
• Ctrl + Shift + @: Apply time format.

Workbook Shortcuts:

• Ctrl + N: Create a new workbook.
• Ctrl + O: Open an existing workbook.
• Ctrl + S: Save workbook.
• F12: Open "Save As" dialog box.

Other Useful Shortcuts:

• Ctrl + Tab: Switch between open workbooks.
• Ctrl + Page Up/Page Down: Move to previous or next sheet.
• Ctrl + F: Open Find dialog box.
• Ctrl + H: Open Replace dialog box.
• Ctrl + G: Open Go To dialog box.
• Ctrl + W: Close workbook.
• Alt: Activate Key Tips (useful for accessing Ribbon commands with keyboard).

These are just some of the many shortcuts available in Excel. Mastering them can save you a lot of time and make your work more efficient.

Certainly! Here are more Excel shortcuts categorized for different tasks:

Formula Shortcuts:

• Ctrl + Shift + U: Expand or collapse the formula bar.
• Ctrl + ;: Enter the current date.
• Ctrl + Shift + " (double quotation mark): Copy value from cell above.
• Ctrl + ' (apostrophe): Copy formula from cell above.

Row and Column Shortcuts:

• Ctrl + + (plus): Insert new cells, rows, or columns.
• Ctrl + - (minus): Delete selected cells, rows, or columns.
• Ctrl + Shift + + (plus): Insert new cells, rows, or columns with dialog box.

Window Shortcuts:

• Alt + F4: Close Excel.
• Alt + Space: Access window menu (to move, size, minimize, maximize, or close the workbook window).

Ribbon Shortcuts:

• Alt: Activate Key Tips (useful for accessing Ribbon commands with keyboard).
• Alt + H: Home tab.
• Alt + N: Insert tab.
• Alt + P: Page Layout tab.
• Alt + M: Formulas tab.
• Alt + A: Data tab.
• Alt + R: Review tab.
• Alt + W: View tab.

Function Key Shortcuts:

• F1: Open Excel Help.
• F4: Repeat last action.
• F7: Spell check selected text or document.
• F11: Create a chart from selected data.

Miscellaneous Shortcuts:

• Ctrl + Alt + V: Paste Special dialog box.
• Ctrl + Shift + F: Insert a new worksheet.
• Ctrl + Shift + L: Turn on or off the Filter.
• Ctrl + K: Insert hyperlink.
• Ctrl + J: Fill handle down.

Multi-cell Selection Shortcuts:

• Shift + Arrow keys: Extend the selection by one cell.
• Shift + Click: Extend the selection to a specific cell.
• Ctrl + Shift + Arrow keys: Extend the selection to the last nonblank cell in the same column or row.

Customizing Shortcuts:

• Alt + F + T: Open Excel Options dialog box (for customizing keyboard shortcuts, among other settings).

Excel Online Shortcuts (Web version):

• Alt: Activate access keys.
• Alt + H: Go to the Home tab.
• Alt + N: Go to the Insert tab.
• Alt + P: Go to the Page Layout tab.
• Alt + M: Go to the Formulas tab.
• Alt + A: Go to the Data tab.
• Alt + R: Go to the Review tab.
• Alt + W: Go to the View tab.

These shortcuts cover a wide range of tasks and functionalities in Excel, helping you navigate, format, edit, and analyze data more efficiently. Practice them regularly to become proficient and speed up your workflow.

Certainly! Here are even more Excel shortcuts covering various functionalities:

PivotTable Shortcuts:

• Alt + J + T + I: Insert a PivotTable.
• Alt + JT: Refresh PivotTable data.
• Alt + JT + U: Update PivotTable.

Chart Shortcuts:

• Alt + F1: Create an embedded chart with data in the current range.
• Alt + F11: Insert a new worksheet with a chart based on the current range.

Cell Formatting Shortcuts:

• Ctrl + Shift + $: Apply currency format with two decimal places (similarly, use % for percentage format, # for date format, @ for time format).
• Ctrl + Shift + !: Apply comma format.

Editing Shortcuts:

• Alt + E + S: Paste Special dialog box.
• Alt + E + I + S: Insert a cell in Excel.
• Alt + E + I + R: Insert rows.

Formula Shortcuts:

• Alt + M + M: Insert function.
• Alt + M + M + F: Financial functions.

Navigation and Selection Shortcuts:

• Ctrl + G: Go To.
• Ctrl + Arrow: Move to the edge of data region.
• Ctrl + Home: Go to cell A1.

Certainly! Here are some more useful Excel shortcuts across different categories:

Editing Shortcuts:

• Ctrl + F3: Define a name.
• Ctrl + F5: Restore the window size of the selected workbook window.
• Ctrl + F6: Switch to the next workbook window when multiple windows are open.

Worksheet Shortcuts:

• Ctrl + Page Down: Move to the next sheet in a workbook.
• Ctrl + Page Up: Move to the previous sheet in a workbook.

Data Entry Shortcuts:

• Ctrl + Enter: Fill the selected cell range with the current entry.
• Alt + Enter: Start a new line in the same cell.

Selection Shortcuts:

• Shift + Spacebar: Select the entire row.
• Ctrl + Spacebar: Select the entire column.

Ribbon and Menu Shortcuts:

• Alt + (Number): Activate the Ribbon tab that corresponds to the number.
  • For example, Alt + 1 activates the File tab in Excel 2010 and later versions.

Miscellaneous Shortcuts:

• F4: Repeat the last command or action, such as applying the same cell formatting again.
• Shift + F2: Insert or edit a comment.

Function Key Shortcuts:

• F5: Open the Go To dialog box.
• F6: Switch between the worksheet, ribbon, task pane, and Zoom controls. In a worksheet that has been split (View menu, Manage This Window, Freeze Panes, Split Window command), F6 includes the split panes when switching between panes and the ribbon area.
• F7: Spell check selected text or document.

These shortcuts should cover a wide range of tasks and functionalities in Excel, helping you navigate, format, edit, and analyze data efficiently. Practice using them regularly to enhance your Excel skills and workflow.

Certainly! Here are more Excel shortcuts categorized across different functionalities and tasks:

Cell and Range Shortcuts:

• Ctrl + Shift + Space: Select the entire worksheet.
• Ctrl + Shift + Home: Extend the selection to the beginning of the worksheet.
• Ctrl + Shift + End: Extend the selection to the last used cell on the worksheet (lower-right corner).

Formula Shortcuts:

• Ctrl + [: Trace precedents to show which cells are supplying data to the active cell.
• Ctrl + ]: Trace dependents to show which cells are dependent on the active cell.
• Ctrl + Shift + {: Select all cells directly referenced by formulas in the selection.
• Ctrl + Shift + }: Select all cells that directly or indirectly reference the active cell.

Workbook and Window Shortcuts:

• Ctrl + F7: Perform the Move command on the workbook window when it is not maximized.
• Alt + F8: Display the Macro dialog box to create, run, edit, or delete a macro.

Data Entry Shortcuts:

• Ctrl + ; (semicolon): Enter the current date.
• Ctrl + Shift + : (colon): Enter the current time.

Formatting Shortcuts:

• Alt + H + FC: Format cells dialog box.
• Ctrl + Shift + $: Apply the Currency format with two decimal places.

Navigation Shortcuts:

• Ctrl + F: Open the Find and Replace dialog box, with the Find tab selected.
• Ctrl + H: Open the Find and Replace dialog box, with the Replace tab selected.

Review Shortcuts:

• Alt + R + G: Group and outline, display the Group dialog box.

PivotTable Shortcuts:

• Alt + P + O + S: PivotTable Options.

Chart Shortcuts:

• Alt + J + T + C: Chart Tools, add or remove chart elements.

Function Key Shortcuts:

• F1: Open the Excel Help task pane.
• F3: Paste a name from the Paste Name dialog box into a formula.
• F8: Extend the selection.

These shortcuts provide additional functionality and efficiency in Excel for tasks ranging from data entry and navigation to formatting and formula management. Incorporating these into your workflow can greatly enhance your productivity and proficiency with Excel.

Certainly! Here are more Excel shortcuts covering various functionalities and tasks:

Editing Shortcuts:

• Ctrl + Shift + L: Toggle filters on or off for the selected range.
• Ctrl + Shift + F5: Edit a cell comment.
• Alt + E + S + V: Paste Values.
• Alt + E + S + T: Paste Formatting.

Navigation and Selection Shortcuts:

• Ctrl + ' (apostrophe): Copy the value from the cell above the active cell into the cell or the Formula Bar.
• Ctrl + Shift + (Arrow keys): Extend the selection to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, to the next nonblank cell.
• Ctrl + F9: Minimize the active workbook window to an icon.
• Ctrl + Shift + F6: Switch to the previous workbook window when more than one workbook window is open.
• Ctrl + Alt + V: Open the Paste Special dialog box.

Ribbon and Menu Shortcuts:

• Alt + N + V: View tab.
• Alt + N + I: Insert tab.
• Alt + N + P: Page Layout tab.
• Alt + N + M: Formulas tab.

Function Key Shortcuts:

• F2: Edit the active cell and position the insertion point at the end of the line.
• F3: Paste a defined name into a formula.
• F9: Calculate all worksheets in all open workbooks.
• F10: Turn key tips on or off.

Worksheet Shortcuts:

• Ctrl + Home: Move to the beginning of a worksheet.
• Ctrl + End: Move to the last cell on a worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or to the next data region.

Workbook and Window Shortcuts:

• Ctrl + F4: Close the selected workbook window.
• Alt + F11: Create, run, edit, or delete a macro.

Data Entry Shortcuts:

• Ctrl + Tab: Move to the next sheet in a workbook.
• Ctrl + Shift + Tab: Move to the previous sheet in a workbook.

Miscellaneous Shortcuts:

• Ctrl + Z: Undo the last action.
• Ctrl + Y: Redo the last action, or repeat the last command.

These additional shortcuts cover a wide range of tasks and functionalities in Excel, helping you navigate, format, edit, and analyze data efficiently. Practice using them regularly to improve your productivity and proficiency with Excel.

Certainly! Here are more Excel shortcuts to further enhance your productivity:

Editing Shortcuts:

• Ctrl + D: Fill down (copy the contents and format of the topmost cell in a selected range into the cells below).
• Ctrl + R: Fill right (copy the contents and format of the leftmost cell in a selected range into the cells to the right).
• Ctrl + Spacebar: Select the entire column of the active cell.
• Shift + Spacebar: Select the entire row of the active cell.
• Ctrl + Shift + F3: Create names from selection.

Navigation and Selection Shortcuts:

• Ctrl + Page Up: Move to the previous sheet in a workbook.
• Ctrl + Page Down: Move to the next sheet in a workbook.
• Ctrl + Shift + L: Toggle the filter on or off for the selected column headings.

Formatting Shortcuts:

• Ctrl + Shift + $: Apply the currency format with two decimal places (negative numbers in parentheses).
• Ctrl + Shift + %: Apply the percentage format with no decimal places.
• Ctrl + Shift + #: Apply the date format with the day, month, and year.

Function Key Shortcuts:

• F1: Open the Help task pane.
• F4: Repeat the last action (for example, formatting a cell or entering a formula).
• F9: Calculate all worksheets in all open workbooks.
• F10: Activate the Menu Bar in the Ribbon.

Ribbon and Menu Shortcuts:

• Alt + F: Open the File tab to Backstage view.
• Alt + H: Open the Home tab.
• Alt + N: Open the Insert tab.
• Alt + P: Open the Page Layout tab.
• Alt + M: Open the Formulas tab.

PivotTable Shortcuts:

• Alt + N + V: PivotTable Styles.

Chart Shortcuts:

• Alt + JT + H: Move the selected chart to a new chart sheet.

Miscellaneous Shortcuts:

• Ctrl + G: Open the Go To dialog box.
• Ctrl + K: Insert a hyperlink.

These shortcuts cover various aspects of working with Excel, from navigation and selection to editing, formatting, and using advanced features like PivotTables and charts. They are designed to streamline your workflow and improve efficiency when working with spreadsheets.

--------------------------------

some of by list below

Shortcut key Action

Ctrl+A Select All

Ctrl+B Bold

Ctrl+C Copy

Ctrl+D Fill Down

Ctrl+E Flash Fill

Ctrl+F Find

Ctrl+G Goto

Ctrl+H Replace

Ctrl+I Italic

Ctrl+K Insert Hyperlink

Ctrl+N New Workbook

Ctrl+O Open

Ctrl+P Print

Ctrl+R Fill Right

Ctrl+S Save

Ctrl+U Underline

Ctrl+V Paste

Ctrl W Close

Ctrl+X Cut

Ctrl+Y Repeat

Ctrl+Z Undo

F1 Help

F2 Edit

F3 Paste Name

F4 Repeat last action

F4 While typing a formula, switch between absolute/relative refs

F5 Goto

F6 Next Pane

F7 Spell check

F8 Extend mode

F9 Recalculate all workbooks

F10 Activate Menubar

F11 New Chart

F12 Save As

Ctrl+: Insert Current Time

Ctrl+; Insert Current Date

Ctrl+" Copy Value from Cell Above

Ctrl+’ Copy Formula from Cell Above

Shift Hold down shift for additional functions in Excel’s menu

Shift+F1 What’s This?

Shift+F2 Edit cell comment

Shift+F3 Paste function into formula

Shift+F4 Find Next

Shift+F5 Find

Shift+F6 Previous Pane

Shift+F8 Add to selection

Shift+F9 Calculate active worksheet

Ctrl+Alt+F9 Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.

Ctrl+Alt+Shift+F9 Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.

Shift+F10 Display shortcut menu

Shift+F11 New worksheet

Shift+F12 Save

Ctrl+F3 Define name

Ctrl+F4 Close

Ctrl+F5 XL, Restore window size

Ctrl+F6 Next workbook window

Shift+Ctrl+F6 Previous workbook window

Ctrl+F7 Move window

Ctrl+F8 Resize window

Ctrl+F9 Minimize workbook

Ctrl+F10 Maximize or restore window

Ctrl+F11 Inset 4.0 Macro sheet

Ctrl+F12 File Open

Alt+F1 Insert Chart

Alt+F2 Save As

Alt+F4 Exit

Alt+F8 Macro dialog box

Alt+F11 Visual Basic Editor

Ctrl+Shift+F3 Create name by using names of row and column labels

Ctrl+Shift+F6 Previous Window

Ctrl+Shift+F12 Print

Alt+Shift+F1 New worksheet

Alt+Shift+F2 Save

Alt+= AutoSum

Ctrl+` Toggle Value/Formula display

Ctrl+Shift+A Insert argument names into formula

Alt+Down arrow Display AutoComplete list

Alt+’ Format Style dialog box

Ctrl+Shift+~ General format

Ctrl+Shift+! Comma format

Ctrl+Shift+@ Time format

Ctrl+Shift+# Date format

Ctrl+Shift+$ Currency format

Ctrl+Shift+% Percent format

Ctrl+Shift+^ Exponential format

Ctrl+Shift+& Place outline border around selected cells

Ctrl+Shift+_ Remove outline border

Ctrl+Shift+* Select the current region around the active cell. In a PivotTable report, select the entire PivotTable report.

Ctrl+Shift++ Insert

Ctrl+- Delete

Ctrl+1 Format cells dialog box

Ctrl+2 Bold

Ctrl+3 Italic

Ctrl+4 Underline

Ctrl+5 Strikethrough

Ctrl+6 Show/Hide objects

Ctrl+7 Show/Hide Standard toolbar

Ctrl+8 Toggle Outline symbols

Ctrl+9 Hide rows

Ctrl+0 Hide columns

Ctrl+Shift+( Unhide rows

Ctrl+Shift+) Unhide columns

Alt or F10 Activate the menu

Ctrl+Tab In toolbar: next toolbar

In a workbook: activate next workbook

Shift+Ctrl+Tab In toolbar: previous toolbar

In a workbook: activate previous workbook

Tab Next tool

Shift+Tab Previous tool

Enter Do the command

Alt+Enter Start a new line in the same cell.

Ctrl+Enter Fill the selected cell range with the current entry.

Shift+Ctrl+F Font Drop Down List

Shift+Ctrl+F+F Font tab of Format Cell Dialog box

Shift+Ctrl+P Point size Drop Down List

Ctrl+Spacebar Select the entire column

Shift+Spacebar Select the entire row

CTRL+Backspace Jump back to the active cell and bring it into view

CTRL+/ Select the array containing the active cell.

CTRL+SHIFT+O Select all cells that contain comments.

CTRL+\ In a selected row, select the cells that don’t match the formula or static value in the active cell.

CTRL+SHIFT+| In a selected column, select the cells that don’t match the formula or static value in the active cell.

CTRL+[ Select all cells directly referenced by formulas in the selection.

CTRL+SHIFT+{ Select all cells directly or indirectly referenced by formulas in the selection.

CTRL+] Select cells that contain formulas that directly reference the active cell.

CTRL+SHIFT+} Select cells that contain formulas that directly or indirectly reference the active cell.

ALT+; Select the visible cells in the current selection.

SHIFT+BACKSPACE With multiple cells selected, select only the active cell.

CTRL+SHIFT+SPACEBAR Selects the entire worksheet.

If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. CTRL+SHIFT+SPACEBAR a second time selects the entire worksheet.

When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet

Ctrl+Alt+L Reapply the filter and sort on the current range so that changes you've made are included

Ctrl+Alt+V Displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.

Microsoft Office: Excel shortcut and function keys

Shortcuts for the Visual Basic Editor

Shortcut key Action

F1 Help

F2 View Object Browser

F3 Find Next

F4 Properies Window

F5 Run Sub/Form or Run Macro

F6 Switch Split Windows

F7 View Code Window

F8 Step Into

F9 Toggle Breakpoint

F10 Activate Menu Bar

Shift+F2 View definition

Shift+F3 Find Previous

Shift+F7 View Object

Shift+F8 Step Over

Shift+F9 Quick Watch

Shift+F10 Show Right Click Menu

Ctrl+F2 Focus To Object Box

Ctrl+F4 Close Window

Ctrl+F8 Run To Cursor

Ctrl+F10 Activate Menu Bar

Alt+F4 Close VBE

Alt+F6 Switch Between Last 2 Windows

Alt+F11 Return To Application

Ctrl+Shift+F2 Go to last position

Ctrl+Shift+F8 Step Out

Ctrl+Shift+F9 Clear All Breakpoints

Insert Toggle Insert Mode

Delete Delete

Home Move to beginning of line

End Move to end of line

Page Up Page Up

Page Down Page Down

Left Arrow Left

Right Arrow Right

Up Arrow Up

Down Arrow Down

Tab Indent

Enter New Line

BackSpace Delete Prev Char

Shift+Insert Paste

Shift+Home Select To Start Of Line

Shift+End Select To End Of Line

Shift+Page Up Select To Top Of Module

Shift+Page Down Select To End Of Module

Shift+Left Arrow Extend Selection Left 1 Char

Shift+Right Arrow Extend Selection Right 1 Char

Shift+Up Arrow Extend Selection Up

Shift+Down Arrow Extend Selection Down

Shift+Tab Outdent

Alt+Spacebar System Menu

Alt+Tab Cycle Applications

Alt+BackSpace Undo

Ctrl+A Select All

Ctrl+C Copy

Ctrl+E Export Module

Ctrl+F Find

Ctrl+G Immediate Window

Ctrl+H Replace

Ctrl+I Turn On Quick Info

Ctrl+J List Properties/Methods

Ctrl+L Show Call Stack

Ctrl+M Import File

Ctrl+N New Line

Ctrl+P Print

Ctrl+R Project Explorer

Ctrl+S Save

Ctrl+T Show Available Components

Ctrl+V Paste

Ctrl+X Cut

Ctrl+Y Cut Entire Line

Ctrl+Z Undo

Ctrl+Insert Copy

Ctrl+Delete Delete To End Of Word

Ctrl+Home Top Of Module

Ctrl+End End Of Module

Ctrl+Page Up Top Of Current Procedure

Ctrl+Page Down End Of Current Procedure

Ctrl+Left Arrow Move one word to left

Ctrl+Right Arrow Move one word to right

Ctrl+Up Arrow Previous Procedure

Ctrl+Down Arrow Next Procedure

Ctrl+Spacebar Complete Word

Ctrl+Tab Cycle Windows

Ctrl+BackSpace Delete To Start Of Word

Ctrl+Break/Pause Break

Ctrl+Shift+I Parameter Info

Ctrl+Shift+J List Constants