Keyboard Shortcuts Every Excel User Should Know

female hands touching keyboardWhen you are dealing with a spreadsheet all day, you have to deal with hundreds of calculations, thousands of cells and dozens of pages. Throughout the day clicking through a series of menus and finding the right buttons can add up to a lot of extra time.

Luckily all of your common productivity programs have built in shortcuts to make quick work of your work. Here are just a few Microsoft Excel 2013 keyboard shortcuts that can boost productivity in your workforce.

  1. [ALT] + ENTER. Insert a new line in a cell. As any introductory student to Excel knows, pressing Enter will take you directly to the next cell, but ALT+ENTER will create a new line within the same same cell.
  • [CTRL] + [ ; ] and  [CTRL] + [ : ]. Insert the current date and/or time. When you hit the CTRL + Semi-colon and/or CTRL + Colon, the current date and time will appear, respectively. This is significantly faster than alternative formatting methods.
  • [F11]. Create a chart. If you want to create a chart from a range of data, simply select the data and hit your F11 key. It’s like magic.
  • [SHIFT+F2]. Add a comment to a cell. Wish you could add a comment to a cell quickly? You can when you press the SHIFT, and then the F2 key.
  • [CTRL+F2]. Print Preview. This keyboard shortcut works in both Microsoft Excel 2013 and Word, and gives you an instant view of what your sheet will look like if you need to print it out.

Labyrinth Learning offers multiple levels of Excel course materials so your students can utilize efficient, time-saving keyboard shortcuts.

Image: shutterstock.com

Speak Your Mind

*


four + = 13