Microsoft Excel Keyboard Shortcuts: A Comprehensive Guide

Explore the Excel file menu and master 11 keyboard shortcuts to create, open, save, print, print preview, and manage windows, boosting workbook efficiency.

Learn how to create a new workbook in Excel with ctrl+n, and navigate the file menu and ribbon to open a blank or other workbook.

Learn how to open a workbook in Excel using Ctrl+O, the File menu, and access keys, including recent documents, OneDrive, and computer options.

Learn three methods to save in Excel: use Ctrl+S, use the File menu Save, or use the access keys including the Save As dialog with F12.

Open Excel's save as dialog with F12 to rename, relocate, or change the file type, and manage multiple versions for easy comparison.

Learn how to print an Excel worksheet efficiently using Ctrl+P, the print dialog, and quick file menu methods, including print preview, copies, printer selection, and saving as pdf.

Explore how to open the print preview window in Excel using Ctrl+F2, Ctrl+P, or the file menu, and navigate multi-page print previews.

Learn to restore down a maximized Excel window using the Windows key with the down arrow, the control key with function keys, or right-click restore in other apps.

Explore how to minimize an Excel window using four methods: Windows key plus down arrow, Ctrl+F9, the system button, or right-clicking to choose minimize.

Maximize an Excel window with Windows key plus up arrow, or Ctrl plus F10. Use the system button or top-bar maximize, and these shortcuts work in Chrome and Word.

Close the current workbook without exiting Excel using Ctrl+F4, or use the File menu close, or use access keys F then C to perform the same action.

Learn how to close both the Excel application and the open Excel document with Alt+F4, and compare it to closing the window with the X button.

Master the Excel ribbon and navigate it with keyboard shortcuts to boost efficiency. Learn how to customize the ribbon and the quick access toolbar to fit your workflow.

Learn to expand or collapse the Excel ribbon with Ctrl+F1, manage Quick Access Toolbar visibility, and choose ribbon display options to maximize worksheet space.

Master excel ribbon control with the ctrl+shift+f1 shortcut to expand or collapse ribbon commands and tabs, and learn auto-hide techniques for maximizing screen space.

Learn to activate excel access keys using Alt and Shift shortcuts, access ribbon tabs and the Quick Access Toolbar, and perform actions like bold, underline, and insert logos.

Use tab key to move to next ribbon control on a tab in Excel, explore access keys, and insert a table; then use shift+tab to move backward between items.

Discover how to use shift+tab to move from right to left across ribbon controls and dialog boxes, navigating items efficiently and saving time compared to tabbing forward.

Use the escape key to move up one level in Excel's ribbon hierarchy, activate access keys, and navigate tabs like home and data to reach sort and filter options.

Activate or open a selected control in Excel using the spacebar and keyboard shortcuts within the Windows ribbon, and compare spacebar navigation with mouse edits for borders and font color.

Learn to confirm a control change in the Excel ribbon using the enter key and spacebar, with guidance on dialog boxes, text color, and font adjustments.

Open the Excel help dialog with F1 or the question mark, search terms, and navigate results; also use the Windows Start menu to browse for help.

Customize the Excel user interface by tailoring the ribbon and quick access toolbar, using file options to add, remove, reorder tabs and commands to fit your workflow.

Discover how to customize the quick access toolbar in Excel: move its location, add or remove commands, reorder items, and use keyboard shortcuts for faster access.

Explore how dialog boxes and menus in Microsoft Excel use keyboard shortcuts to boost efficiency, including 10 practical keys like control+1, shift, spacebar, tab, and enter.

Discover how to display Excel's shortcut menu with shift + f10 or the menu key, then quickly edit by cutting, pasting, or applying bold, and insert or delete comments.

Learn how to instantly display the control menu with alt + spacebar and use the spacebar to select minimize, restore, move, or close in Excel and other apps.

Master how to navigate dialog boxes in Excel with tab to move to the next control, and arrow keys to move between items, confirming choices with okay, including shift tab.

Learn how shift+tab moves to the previous control in a dialog box, reversing the tab order, unlike the tab key in Excel's font and alignment dialogs.

Discover how to move between dialog box tabs in Excel using ctrl+tab to advance right, and ctrl+shift+tab to move left, including navigating font, border, and fill groups.

move between dialog tabs with ctrl+tab or ctrl+shift+tab, one tab at a time from right to left, and use arrow keys, clicks, or the spacebar to toggle strikethrough or superscript.

Learn how to check or uncheck a checkbox in a dialog box using the spacebar, navigate with tab, and preview formatting like strikethrough, superscript, and wrap text.

Master how the enter key accepts and applies changes in Excel dialog boxes, applying font and color edits, using the tab key to reach the button, and closing without saving.

Use the escape key to cancel changes and close a dialog box in Excel, with three options: escape, tab to cancel, or click cancel.

Master displaying the modified cell style dialog box with Alt + apostrophe, then modify formats, fonts, and colors across cells via dialog or right-click in Excel.

Explore how workbooks and worksheets organize Excel files, and learn 16 keyboard formats to create, rename, move, copy, hide, and delete worksheets for faster navigation.

Learn how to insert a new worksheet in Excel via Shift+F11 and Ctrl+F11, and explore additional methods like the insert sheet button and the Home tab insert option.

Learn to go to the next worksheet on the right in Excel using Ctrl + Page Down, and navigate between sheets via clicking or right-click menus.

Learn to navigate Excel worksheets with Ctrl+Page Up to go left and Ctrl+Page Down to go right, or use sheet tabs via click or right-click.

Learn how to move between panes in Excel using the F6 key, cycle between views, and split windows to compare data across multiple panes.

Master shift+tab to move from right to left across items in the Excel Windows ribbon, menus, and dialogs, saving time with keyboard navigation.

Master the Ctrl+Tab shortcut to cycle through active Excel workbooks. Learn alternative methods—tab navigation and hovering the Excel icon—to switch windows efficiently, with minimized workbooks excluded from the cycle.

Master switching between workbooks with control tab and control shift tab, cycling to the most recent or oldest workbook and improving navigation between open files.

Learn to minimize, restore down, and maximize individual Excel workbooks using Ctrl+F9, Ctrl+F10, and Windows key plus down arrow; right-click offers quick restore or maximize.

Learn to select adjacent worksheets in Excel by holding shift and clicking the rightmost sheet, then apply changes across all selected sheets such as font or text.

Learn to select non-adjacent worksheets in a Microsoft Excel workbook by holding the control key and clicking sheets, and use the shift key for range selections.

Learn how to hide and unhide worksheets in Excel and customize the Quick Access Toolbar to quickly access the hide sheet command.

Learn to customize the quick access toolbar to quickly unhide worksheets in Excel, add the unhide sheets command for one-click access, and use the format menu to manage hidden sheets.

Learn how to rename worksheets in Excel using the keyboard shortcut Alt O H R or by double-clicking, with tips on naming rules and avoiding duplicates.

Discover three methods to move a worksheet within a workbook, to a new or existing workbook, using keyboard shortcuts (Alt+E M), drag-and-drop, or right-click move.

Learn to copy a worksheet using keyboard shortcuts (Alt E M) and a control-key drag, creating duplicates in the same or a different workbook.

Discover how to delete a worksheet in Excel using the keyboard shortcut Alt E L, plus alternate methods like right-click delete and multi-sheet selection.

Master modifying columns and rows in Excel with 17 keyboard shortcuts, learning how to insert, delete, hide, and group cells to work faster and more efficiently.

Learn to display the insert dialog box in Microsoft Excel using the Ctrl+Shift+= shortcut and alternative methods from the home tab to insert rows or columns and shift cells.

Learn how to use the Ctrl + Shift + = shortcut to automatically insert a row in Excel, by selecting the target row and applying the insert action.

Master inserting columns in Excel using keyboard shortcuts such as Ctrl+Shift+= and Ctrl+Shift+Plus, select a column by its letter, and use alternative menu options while modeling revenue, costs, and profit.

Learn how to display the delete dialog box in Excel with Ctrl + - and manage deleting or adding cells, rows, and columns using shortcuts like Ctrl+Shift++.

Learn to delete rows in Excel using keyboard shortcuts like Ctrl + -, and other methods such as right-click delete or the delete button for single or multiple rows.

Master methods to delete columns in Excel using keyboard shortcuts, such as Ctrl minus, and learn to select columns, use delete options, and right-click delete for efficient editing.

Learn how to delete the contents of specific cells in Excel using the Ctrl + minus shortcut, choosing to move cells up or to the left, and undo actions.

Learn how to delete the contents of selected cells with the delete key, how it differs from backspace, and how to clear data in a range while leaving cell positions intact.

Master excel column visibility by using ctrl+shift+0 to unhide selected columns and ctrl+a to reveal all hidden columns, with practical steps for selecting surrounding columns.

Learn how to unhide columns in Excel with Ctrl+Shift+0, including when columns are hidden between others. Use Ctrl+A to select all, and access hide/unhide commands to restore visibility.

Demonstrate how to hide and unhide rows in Microsoft Excel using ctrl+9, selecting rows, double-clicking between row numbers, and using the format dialog box to manage hidden rows.

Learn to unhide one or more rows currently hidden in Excel using the Ctrl+Shift+9 keyboard shortcut, and reveal hidden rows in a spreadsheet efficiently.

Learn to group rows or columns in excel using keyboard shortcuts and the data tab, illustrated with West region and East region examples, and three grouping methods.

Learn how to ungroup rows or columns in Excel with the shift + left arrow keyboard shortcut, and compare it to mouse-based ungroup methods.

Learn to open the group dialog box with Alt+Shift+Right Arrow, group selected rows or columns, and choose grouping options in the dialog, with alternative keyboard and ribbon methods.

Open the ungroup dialog box in Excel with Alt+Shift+Left Arrow, then ungroup selected rows or columns by choosing rows or columns in the dialog, using alternative methods.

Toggle the outline symbols for groups in Microsoft Excel using Ctrl+8 to hide or show, helping you manage screen real estate when working with large datasets.

Learn to navigate Microsoft Excel efficiently with 16 keyboard shortcuts, mastering arrows, page up/down, control right and left arrows, and end mode to move quickly across cells and data edges.

Move one cell to the right in Excel using the right arrow key, tab, or the mouse, and exit edits with escape or commit with enter.

Move one cell to the left in Excel with the left arrow or cursor, and manage edits depending on an active cell or its contents using Escape, Ctrl+Enter, Tab.

Learn to move cell up in Excel using the up arrow and cursor, cancel changes with Escape, and use Shift+Enter or Ctrl+Enter to enter data and move up.

Learn to move to the cell directly below in Excel with the down arrow or by clicking, and manage entering or canceling changes using enter, escape, or control enter.

Use the alt + page down shortcut to move one screen to the right in Excel, offering a fast alternative to the scroll bar.

Learn how to move one screen to the left in Excel using Alt + Page Up, an efficient shortcut for navigating visible columns within a worksheet.

Learn how to move one screen down in Excel using the page down key, the scroll bar, or a mouse wheel, and compare methods for navigating data efficiently.

Discover how to move one screen up in Excel with page up, page down, and scroll methods, use the quick access toolbar, and note Mac vs PC differences.

Learn to move to the right edge of a data region in Excel using ctrl + right arrow, exploring continuous data blocks, breaks, and keyboard versus mouse navigation.

Master the Ctrl + left arrow shortcut to jump to the left edge of a data region and seamlessly navigate between multiple regions, boosting efficiency in large Excel datasets.

Navigate to the top edge of a data region in Excel with Ctrl+Up Arrow, then jump between multiple data regions for faster navigation, instead of manual scrolling.

Master moving to the bottom edge of a data region in Excel using ctrl + down, and navigate to the top, next region, and left or right edges.

Use the home key in Excel to jump to the beginning of the current row, speeding navigation over Ctrl+Left arrows, even with hidden cells.

Master end mode in Excel to jump to the end of a data region using the end key and arrows, and highlight ranges with shift.

Learn how to use ctrl + end to jump to the last cell with data in your worksheet, and understand how it interacts with data regions and recently modified cells.

Discover how to move to the first cell currently visible on a worksheet using Ctrl+Home, and learn how hidden columns affect navigation with keyboard shortcuts.

Explore making a selection in Microsoft Excel and use nine keyboard shortcuts to select contiguous and noncontiguous cells, entire columns, and navigate data efficiently.

Use the shift key and spacebar to instantly select a row in Excel. Extend or de-select with the arrow keys and group items for quick data management.

Learn to instantly select an entire column in Excel with Ctrl + Spacebar, click the column letter for a single column, and extend multiple columns using Shift and arrow keys.

Learn how to use ctrl + a in Excel to select data: first press selects the current region, second press selects the entire worksheet, with a corner-click alternative.

Learn to add adjacent cells to a selection in Excel by holding shift and clicking to highlight the continuous range from the active cell to the target cell.

Learn how to use Ctrl + left click to add non-adjacent cells to an Excel selection, and combine it with Shift-click to extend a large range before finalizing the selection.

Learn how to cancel a selection in Excel: press escape to exit a single cell, or use shift+backspace to de-select a range and leave only the active cell.

Learn how to toggle add to selection mode in Excel using the Shift+F8 keyboard shortcut to add non-adjacent cells to your selection and apply changes quickly.

Learn to navigate non-adjacent selections in Microsoft Excel by combining shift f8 add to selection mode with ctrl right arrow to jump between ranges, streamlining data editing.

Use the Ctrl + left arrow shortcut in Excel to jump between non-adjacent selections, and add to selection by pressing Shift and clicking for faster navigation.

Master how to work with the active cell in Excel and use seven keyboard shortcuts—such as shift+backspace, ctrl+backspace, backspace, ctrl+period, and shift+enter—to navigate and refine your selection.

Learn how to use shift + backspace to select only the active cell in Microsoft Excel, using the green box indicator and active vs. multi-cell selection concepts.

Learn how to reveal the active cell in Excel without deselecting other cells by using Ctrl+Backspace, while managing selection with Shift+Backspace and navigation with tab, enter, and arrows.

Learn to cycle the active cell clockwise around a selection in Excel using Ctrl + ., hopping to the four corners (top left, top right, bottom right, bottom left).

Press the enter key to move the active cell one row down within a selection, and use shift-click to create selections for efficient navigation in Excel.

Use Shift + Enter to move the active cell upward within a selection in Microsoft Excel, then navigate to the next column or left adjacent cells as needed.

Explore how the tab key moves the active cell to the right within a selection in Excel, detailing behavior with and without a selection and end-of-range behavior.

Master moving the active cell left within a selection using shift tab in Excel, and navigate a multi-cell range with enter, shift enter, and tab for efficient editing.

Extend your selection in Excel with 14 keyboard shortcuts, from shift-driven moves to control-shift and the selection dialog box, enabling efficient range selection.

Extend selection in Excel one cell to the right with shift plus the right arrow, moving the active cell; alternatively, shift plus left-click selects cells one by one.

Extend your selection one cell at a time in Excel with shift plus the left or right arrow; de-select by holding shift and pressing the opposite arrow.

Learn to extend the selection in Excel by one cell up with shift plus the up arrow, and deselect with shift plus down as you navigate using keyboard shortcuts.

Use shift with down arrow to extend selection one cell at a time, combine with other arrows for larger ranges, and use control-shift-right to reach last cell on the right.

Use ctrl shift right arrow to extend selection to the last cell on the right, selecting all cells in the current data region for quick formatting.

Learn to extend a selection in Excel with Ctrl+Shift+Left Arrow to the last left cell, and deselect the edge to apply formatting like bold or color.

Master the control shift down shortcut to extend selection to the bottom of a data region in Excel, building on left and right extension techniques and formatting basics.

Extend your selection to the last cell up with ctrl+shift+up in Excel, while maintaining bold titles and regular numbers as you adjust formatting.

Learn to extend selection up one screen in Excel with shift+page up. The lecture covers range expansion and related shortcuts, including control+shift+left arrow and control+shift+page up.

Learn to extend selections in Excel using shift + page down to move down a screen and shift + page up to extend upward, including across columns.

Extend your selection in Excel from active cell to the start of the row with Shift + Home, and compare it to using control left arrows to reach region edges.

Use the Ctrl + Shift + Home shortcut to extend your selection to the first visible cell from the active cell, and learn to select everything to AC15.

Master extending selections to the last data cell with Ctrl+Shift+End, or to the upper-left cell with Ctrl+Shift+Home, and understand how data presence can influence the selection in Excel.

Use F8 to toggle extended selection mode in Excel, extending or reducing the active selection from the current cell, with alternatives like shift+F8 or shift-click.

Explore Microsoft Excel keyboard shortcuts for precise selections, including go to and go to special, selecting comments, current region, entire worksheet, and table differences.

Learn to open the go-to dialog in Excel with Ctrl+G, jump to specific cells, and use go-to special to spot formulas, constants, and blanks.

Learn to quickly select all cells with comments in Excel using Ctrl+Shift+O, go to special with comments, and the select comments option, then manage or delete them.

Learn how to select the current region around the active cell in Excel using Ctrl+Shift+8, and how this differs from Ctrl+8 by shifting the active cell to the region's top-left.

Learn how ctrl + a selects the region in Excel, and how a second press highlights all your work, with ctrl inside region selecting the region and outside selecting all.

Learn to quickly identify row differences in Excel by selecting cells and using Ctrl + backslash to highlight mismatches, with Go to > Special as an alternative.

Learn to quickly identify column differences in Excel using the ctrl+shift+backslash shortcut, compare across quarters, and locate differences via go to special or the column differences option.

Identify and highlight direct precedents in Excel using Ctrl + [, tracing which inputs feed a formula such as revenue minus costs, and explore alternatives like go to special precedents.

Use ctrl+shift+{ to select all precedents across all levels, revealing every value that contributes to a cell's final result and how changes ripple through the model.

Use ctrl + ] to select direct dependents of the active cell. These relate to figures like year-end profit and retirement fund; compare with ctrl + [ for direct precedents.

Master excel keyboard shortcuts to find all dependents of a cell, using ctrl+shift+}, ctrl+shift+right bracket, and go to special; quickly identify all related cells for analysis.

Use the Alt + ; shortcut to select only the visible cells in Excel, excluding hidden ones. See how hiding and unhiding columns affects selection and formatting.

Learn to use shift+spacebar to quickly select a table row in an Excel table, keeping the selection within the table and avoiding the entire column outside the table.

Learn how to quickly select an entire column in an Excel table using Ctrl+Spacebar, and observe how the spacebar selects rows within the table.

Master the ctrl + a shortcut to select a table's contents, then its labels, and finally the entire worksheet, highlighting how table versus normal ranges behave.