Excel Shortcut Keys 2016: Boost Your Productivity with These Time-Saving Tips

Understanding Excel Shortcut Keys 2016

Excel is a powerful tool that can help you manage and analyze data. To make the most of this software, it’s important to learn Excel shortcut keys. These keyboard shortcuts can help you save time and increase your productivity. Here are some of the most fundamental Excel shortcut keys you need to know:

Fundamental Shortcut Keys

  • Ctrl + C: Copy
  • Ctrl + V: Paste
  • Ctrl + X: Cut
  • Ctrl + Z: Undo
  • Ctrl + Y: Redo
  • Ctrl + A: Select All
  • Ctrl + F: Find
  • Ctrl + H: Replace
  • Ctrl + S: Save
  • Ctrl + P: Print

Command and Function Keys

  • F1: Help
  • F2: Edit
  • F3: Paste Name
  • F4: Repeat Last Action
  • F5: Go To
  • F6: Next Pane
  • F7: Spell Check
  • F8: Extend Mode
  • F9: Recalculate
  • F10: Activate Menu Bar
  • F11: New Chart
  • F12: Save As

Navigation and Formatting Shortcuts

  • Ctrl + Home: Go to the beginning of the worksheet
  • Ctrl + End: Go to the last cell of the worksheet
  • Ctrl + Page Up: Move to the previous sheet
  • Ctrl + Page Down: Move to the next sheet
  • Ctrl + Shift + $: Apply currency format
  • Ctrl + Shift + %: Apply percentage format
  • **Ctrl + Shift + #: Apply date format
  • Ctrl + Shift + @: Apply time format
  • Ctrl + Shift + !: Apply number format

By using these Excel shortcut keys, you can save time and work more efficiently. To make it even easier to remember these shortcuts, you can create a cheat sheet that you can refer to whenever you need to use them.

Applying Excel Shortcut Keys

Excel shortcut keys can save you time and make your work more efficient. Here are some commonly used shortcuts for data manipulation and worksheet and workbook management.

Data Manipulation Shortcuts

  • Ctrl + C – Copy selected cells
  • Ctrl + V – Paste copied cells
  • Ctrl + X – Cut selected cells
  • Ctrl + Z – Undo last action
  • Ctrl + Y – Redo last action
  • Ctrl + B – Bold selected text
  • Ctrl + I – Italicize selected text
  • Ctrl + U – Underline selected text
  • Ctrl + 1 – Open the Format Cells dialog box
  • Ctrl + Shift + $ – Apply the Currency format
  • Ctrl + Shift + % – Apply the Percentage format
  • Ctrl + Shift + # – Apply the Date format
  • Ctrl + Shift + @ – Apply the Time format

Worksheet and Workbook Management

  • Ctrl + N – Create a new workbook
  • Ctrl + O – Open an existing workbook
  • Ctrl + S – Save the current workbook
  • Ctrl + Shift + S – Save the current workbook as a new file
  • Ctrl + W – Close the current workbook
  • Ctrl + F4 – Close the current workbook window
  • Ctrl + Tab – Switch to the next workbook window
  • Ctrl + Shift + Tab – Switch to the previous workbook window
  • Ctrl + Page Up – Move to the previous worksheet
  • Ctrl + Page Down – Move to the next worksheet
  • Ctrl + Shift + Page Up – Select the current and previous worksheet
  • Ctrl + Shift + Page Down – Select the current and next worksheet

By using these shortcut keys, users can manipulate data and manage their workbooks more efficiently.

Advanced Excel Shortcut Keys

Excel is a powerful tool that can help you to perform complex calculations and analysis with ease. However, using the mouse to navigate through the various menus and options can be time-consuming. Fortunately, Excel has a wide range of keyboard shortcuts that can help you to speed up your work and improve your productivity.

Macro and Ribbon Shortcuts

Macros are a powerful feature that allows you to automate repetitive tasks in Excel. Ribbon shortcuts are a set of keyboard shortcuts that allow you to navigate through the various tabs and commands in the ribbon. Here are some of the most useful macro and ribbon shortcuts in Excel 2016:

  • Alt+F8: Open the Macro dialog box
  • Alt+F11: Open the Visual Basic Editor
  • Ctrl+Shift+F3: Create a new macro
  • Ctrl+Shift+L: Toggle filters on and off
  • Ctrl+Shift+O: Select all cells with comments
  • Ctrl+Shift+P: Display the Format Cells dialog box
  • Ctrl+Shift+U: Expand or collapse the formula bar

Special Features and Productivity Shortcuts

In addition to macro and ribbon shortcuts, Excel has a wide range of special features and productivity shortcuts that can help you to work more efficiently. Here are some of the most useful special features and productivity shortcuts in Excel 2016:

  • Ctrl+1: Display the Format Cells dialog box
  • Ctrl+2: Apply or remove bold formatting
  • Ctrl+3: Apply or remove italic formatting
  • Ctrl+4: Apply or remove underline formatting
  • Ctrl+5: Apply or remove strikethrough formatting
  • Ctrl+6: Show or hide objects
  • Ctrl+9: Hide rows
  • Ctrl+0: Hide columns

Using these advanced Excel shortcut keys can help you to work more efficiently and save time. Whether you are a beginner or an advanced user, it is worth taking the time to learn these shortcuts and incorporate them into your daily workflow.


  • Robert Miller

    Meet Robert James Miller, the meticulous editor at CostOfIncome, where precision meets passion. While his editorial skills have consistently elevated the platform's content, it's his profound expertise in Excel that sets him apart. Robert doesn't just know Excel; he commands it, transforming complex data into insightful narratives. His depth of understanding has not only aided in streamlining operations at CostOfIncome but has also positioned him as the go-to guru for all things Excel-related.

  • Collin Bennett

    eagle-eyed fact-checker at the heart of every post's accuracy. In an age where information is abundant and mistakes are costly, Samuel stands as the gatekeeper of truth for all Excel-related content. His meticulous approach ensures that every formula, every function, and every data-driven insight is both precise and verifiable.

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.