Friday, January 15, 2021
No menu items!
Home Tech Microsoft Excel Keyboard Shortcuts List 2019

Microsoft Excel Keyboard Shortcuts List 2019

General Program Shortcuts

First, let’s take a look at some general keyboard shortcuts for manipulating workbooks, getting help, and a few other interface-related actions.

  • Ctrl+N: Create a new workbook
  • Ctrl+O: Open an existing workbook
  • Ctrl+S: Save a workbook
  • F12: Open the Save As dialog box
  • Ctrl+W: Close a workbook
  • Ctrl+F4: Close Excel
  • F4: Repeat the last command or action. For example, if the last thing you typed in a cell is “hello,” or if you change the font color, clicking another cell and pressing F4 repeats that action in the new cell.
  • Shift+F11: Insert a new worksheet
  • Ctrl+Z: Undo an action
  • Ctrl+Y: Redo an action
  • Ctrl+F2: Switch to Print Preview
  • F1: Open the Help pane
  • Alt+Q: Go to the “Tell me what you want to do” box
  • F7: Check spelling
  • F9: Calculate all worksheets in all open workbooks
  • Shift+F9: Calculate active worksheets
  • Alt or F10: Turn key tips on or off
  • Ctrl+F1: Show or hide the ribbon
  • Ctrl+Shift+U: Expand or collapse the formula bar
  • Ctrl+F9: Minimize the workbook window
  • F11: Create a bar chart based on selected data (on a separate sheet)
  • Alt+F1: Create an embedded bar chart based on select data (same sheet)
  • Ctrl+F: Search in a spreadsheet, or use Find and Replace
  • Alt+F: Open the File tab menu
  • Alt+H: Go to the Home tab
  • Alt+N: Open 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
  • Alt+X: Go to the Add-ins tab
  • Alt+Y: Go to the Help tab
  • Ctrl+Tab: Switch between open workbooks
  • Shift+F3: Insert a function
  • Alt+F8: Create, run, edit, or delete a macro
  • Alt+F11: Open the Microsoft Visual Basic For Applications Editor
ALSO READ  The top 10 Best Sites to Buy and Sell Your Car Online 2019

Moving Around in a Worksheet or Cell

You can use keyboard shortcuts to easily navigate throughout your worksheet, within a cell, or throughout your entire workbook.

  • Left/Right Arrow: Move one cell to the left or right
  • Ctrl+Left/Right Arrow: Move to the farthest cell left or right in the row
  • Up/Down Arrow: Move one cell up or down
  • Ctrl+Up/Down Arrow: Move to the top or bottom cell in the column
  • Tab: Go to the next cell
  • Shift+Tab: Go to the previous cell
  • Ctrl+End: Go to the most bottom right used cell
  • F5: Go to any cell by pressing F5 and typing the cell coordinate or cell name.
  • Home: Go to the leftmost cell in the current row (or go to the beginning of the cell if editing a cell)
  • Ctrl+Home: Move to the beginning of a worksheet
  • Page Up/Down: Move one screen up or down in a worksheet
  • Alt+Page Up/Down: Move one screen to the right or left in a worksheet
  • Ctrl+Page Up/Down: Move to the previous or next worksheet
ALSO READ  TOP 10 Best Free WordPress Hosting Services for Startups in 2019 -Comparison & Reviews

Selecting Cells

You may have noticed from the previous section you use the arrow keys to move between cells, and the Ctrl key to modify that movement. Using the Shift key to modify the arrow keys lets you extend your selected cells. There are also a few other combos for speeding up selection, as well.

  • Shift+Left/Right Arrow: Extend the cell selection to the left or right
  • Shift+Space: Select the entire row
  • Ctrl+Space: Select the entire column
  • Ctrl+Shift+Space: Select the entire worksheet

Editing Cells

Excel also provides some keyboard shortcuts for editing cells.

  • F2: Edit a cell
  • Shift+F2: Add or edit a cell comment
  • Ctrl+X: Cut contents of a cell, selected data, or selected cell range
  • Ctrl+C or Ctrl+Insert: Copy contents of a cell, selected data, or selected cell range
  • Ctrl+V or Shift+Insert: Paste contents of a cell, selected data, or selected cell range
  • Ctrl+Alt+V: Open the Paste Special dialog box
  • Delete: Remove the contents of a cell, selected data, or selected cell range
  • Alt+Enter: Insert a hard return within a cell (while editing a cell)
  • F3: Paste a cell name (if cells are named in the worksheet)
  • Alt+H+D+C: Delete column
  • Esc: Cancel an entry in a cell or the formula bar
  • Enter: Complete an entry in a cell or the formula bar
ALSO READ  laptop won't turn on even when plugged in? Try these solutions

Formatting Cells

Ready to format some cells? These keyboard shortcuts make it easier!

  • Ctrl+B: Add or remove bold to the contents of a cell, selected data, or selected cell range
  • Ctrl+I: Add or remove italics to the contents of a cell, selected data, or selected cell range
  • Ctrl+U: Add or remove underline to the contents of a cell, selected data, or selected cell range
  • Alt+H+H: Select a fill color
  • Alt+H+B: Add a border
  • Ctrl+Shift+&: Apply outline border
  • Ctrl+Shift+_ (Underline): Remove outline border
  • Ctrl+9: Hide the selected rows
  • Ctrl+0: Hide the selected columns
  • Ctrl+1: Open the Format Cells dialog box
  • Ctrl+5: Apply or remove strikethrough
  • Ctrl+Shift+$: Apply currency format
  • Ctrl+Shift+%: Apply percent format
ALSO READ  iPhone 11 Pro's 'Toughest Glass in a Smartphone' Claim Put to Test

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Latest News

Watch Series Alternatives and List of Unblocked Watch Series Proxy Mirrors sites 2021

Watch Series is popular name when it comes to downloading torrent files.You can download torrent files of latest movies,...

Best Putlocker Alternatives to Watch Movies Online 2021

Putlocker is very popular website that enables users to stream television shows, movies and many more anywhere without problems. The...

Top 50 Anime Torrents Sites For Download and Watch Free Movies 2021

Words anime– pronounced “ah-knee-may”– is an abbreviation of the word animation. In Japan, the word is used to refer...

Limetorrents Proxy/Mirror Sites and Limetorrents Alternatives 2021

If your favorite best torrent sites are down LimeTorrents is a great alternative.LimeTorrents is easy to use and simple,...

Rarbg Mirror Sites and Rarbg Proxy List 2021

Rarbg is a popular name when it comes to downloading torrent files. You can download torrent files of latest...

How to Download and Install Popcorn Time on MAC/iPhone/iPad [Working 2021 ]

When it involves video streaming, iOS devices have a long manner to go. Due to some restriction from  Apple,...

Torrentz2 Proxy / Mirror List : Top Torrentz2 Alternatives 2021

Torrentz2.eu technically it isn’t really a torrent site.Torrentz2.eu is the meta-search engine search other torrent trackers for you. It’s...