How Many Shortcuts Do You Know?

We have found that having a good working knowledge of how to navigate within your spreadsheets, like using Excel shortcut keys, can make work easier and faster. Even though everyone should know these shortcuts, we are always surprised when an experienced user tells us excitedly, “Hey! I didn’t know that one!” Here are a few, easy keystrokes that you may already know – or maybe you don’t. Open a spreadsheet and try the following shortcut keys and let us know in the comments if you picked up anything new. Happy Learning!

Excel Shortcut Keys – Using the Fill Feature

The Fill Feature allows you to enter text and values into a block of adjacent cells, instead of typing them individually. You probably already know how to use the mouse and grab the Fill Handle located in the lower-right corner of your selected cell and drag it to fill in the adjacent cells. But for those of us who find it faster to use keyboard shortcuts – here are a few:

In the video below, see an example of selecting cells in a column, cells in a row, and a range of cells. Remember to select first, then press the keystroke listed.

  • To fill down = Ctrl+D
  • Fill to the right = Ctrl+R
  • Fill into selected cells = Ctrl+Enter

Excel Shortcut Keys – Selecting  and Working with Cells

  • Select entire sheet = Ctrl+A
  • Turn Filter feature on and off = Ctrl+Shift+L
  • Go to a specific cell = F5 or Ctrl+G, then type in the cell name (i.e. A5)

Excel Shortcut Keys – Working with Formulas

Absolute Reference = F4 (click into the formula using the Formula Bar & press F4)

Excel Shortcut Keys – Working with Sheets

  • Insert a new worksheet = Shift+F11
  • To rename a worksheet = Alt+O+H,R (type the name of the sheet, then press Enter)
  • Delete current worksheet = Alt+E,L
  • Select current & previous sheet = Ctrl+Shift+Page Up (this will Group the two sheets)

Online Webinars

Would you like to enhance your skills on a specific topic from the comfort of your home or desk? Our 60 minute webinars deliver quick, high quality training, helping you make the most of your valuable time. Some of our webinar classes are: MSWord Essentials, MSWord Styles, MSWord Outline Numbering, MSWord Headers & Footers, MSWord Table of Contents & Table of Authorities, MSExcel Essentials, MSPowerPoint Essentials, and many more! What topic, feature, or skill would you like to know more about? Drop us your wish list in the comments!

Check out our Training Programs or contact us for more information. Visit our Facebook for daily up dates!