Keyboard Shortcuts For

Microsoft Excel

10 Shortcuts for Excel (Plus: Free Cheat Sheet)

Worksheet calculations by Microsoft Excel enable plenty of arithmetical operations with formulas and other features, no matter whether you need to produce a cost summary or statistics. There is a detailed overview of keyboard shortcuts for Microsoft Excel intended to help users tap into the full potential of this effective worksheet calculation program. We have picked ten handy and easy-to-learn keyboard shortcuts for Microsoft Excel. And to help anyone unfamiliar with transitioning from ‘mouse to keyboard’ we’ve also compiled a cheat sheet (coming soon) to print out and stick to the monitor.

Top 10 Shortcuts for Microsoft Excel

#1 - Open a spreadsheet

You want to continue working on yesterday’s cost summary? Use the keyboard combination "Ctrl" + "O" to access the workbooks or saved files you most recently used.

#2 - Select an entire column or row in a worksheet

The correct column or row needs to be marked before performing an action. You can skip through two of the most frequent work steps almost for nothing by using the keyboard combination "Ctrl" + spacebar (select a column) and "Shift" + spacebar (select a row).

#3 - Delete a column

Oops, there’s one column too many. Press "Ctrl" + "-" (minus) to delete the unnecessary column without taking your hands off the keyboard.

#4 - Format a cell by using the dialog box 'Format Cells'

The keyboard combination "Ctrl" + "1" lets you format your cells that bit quicker, no matter whether it’s the font, the fill color, the border or the orientation.

#5 - Open the tab 'Insert' and insert PivotTables, charts, add-ins, sparklines, pictures, shapes, headers, or text boxes

Plain excel tables look boring? The keyboard combination "Alt" + "N" (then choose a letter) opens the Insert tab, and each option on the task bar is assigned a letter. Pick your preferred letter to add images, formulas or text boxes to each table at the flick of a wrist.

#6 - Move to the next sheet in a workbook

What is the value on page three again? Use the keyboard combination "Ctrl" + "↓" (Page Down) to navigate easily through the sheets of a workbook.

#7 - Insert a function

Our favorite! No matter whether it’s 'SUM', 'IF' or 'DATE', the keyboard combination "Shift" + "F3" lets you add functions without that laborious switch between keyboard and mouse.

#8  - Copy the formula of the cell above

Press "Ctrl" + "U" to calculate the value of a cell with the formula in the one above. This keyboard combination saves you having to type in formulas again by hand.

#9 - Create an embedded chart of the data in the current range

Endless tables full of numbers can quickly become confusing. Diagrams are far more illustrative and help to demonstrate contexts and relations at a glance. Press "Alt" + "F1" or "Ctrl" + "Q" to produce an immediately accessible diagram in no time at all.

#10 - Save a spreadsheet

All done? Use the classic keyboard combination "Ctrl" + "S" to save your Excel calculations, tables and diagrams that little bit faster.

To Many Shortcuts at Once?

Our compact cheat sheet, is always on hand to help refresh your memory. Simply print it out and stick it to your keyboard or display.

Download our Cheat Sheet

Comment on this article

Leave a comment to let us know what you think about this topic!

Leave a comment

Author

Blog Editorial Team

Trend Scouts

IT Trends and industry-relevant novelties

Related Articles

Office 365 AI & You - Teams Customized Background
  • 16 July 2020
  • Erik Moll
  • User Productivity, Publisher Advisory
  • AI, Microsoft, Artificial Intelligence, Teams

Microsoft 365 AI & You - Teams Customized Background

An update to Microsoft Teams AI is making your videoconferencing more professional. It ensures that you remain the center of attention – and not the cluttered background.

  • 15 April 2020
  • Erik Moll
  • User Productivity, Unified Communications
  • Teams, Office 365, Collaboration

Knockout in the First Round: Microsoft Teams Beats WhatsApp

Using a private messenger to discuss professional details with colleagues is a tricky topic if one considers the data protection and security aspects! We’ll show you how Microsoft Teams easily knocks the socks off of WhatsApp in the…

windows-7-extended-support

Windows 7 Extended Support: Now Is the Time to Take Action!

Microsoft ended support for Windows 7. Find out which far-reaching impact this will have on your environment.