20 Excel Keyboard shortcuts for Beginners

by | April 12th, 2017

When starting with Microsoft Excel, knowing a few shortcuts will reduce your work time and make it easier to work on Excel. Using the mouse to do all the task reduces your productivity. Here are a few shortcuts to use when you just begin working with Microsoft Excel. These Excel Keyboard shortcuts for beginner works with all versions of Excel 2003, Excel 2007, Excel 2010, Excel 2013.

Get advanced excel training program on more than 200+ shortcut keys and formulas


Below are 20 Excel Keyboard shortcut for Excel beginners:

Excel Keyboard  Shortcut What does it do?
Ctrl+N Create a new workbook.
Ctrl+O Open an existing workbook.
Ctrl+S Save the active workbook.
CTRL+W Close the active workbook.
Ctrl+C Copy the contents of the selected cells to Clipboard.
Ctrl+X Cut the contents of the selected cells to Clipboard.
Ctrl+V Insert the contents of the Clipboard into the selected cell(s).
Ctrl+Z Undo your last action.
Ctrl+P Open the “Print” dialog.
Ctrl+1 Open the “Format Cells” dialog.
Ctrl+G Go to any special cell.
F2 Edit the current cell.
Alt+Enter In cell editing mode, enter a new line (carriage return) into a cell.
CTRL+; Enter the current date. Press CTRL+Shift+; to enter the current time.
CTRL+ENTER Fill the selected cells with the contents of the current cell.
Ctrl+B Bold.
Home Return to the 1st cell of the current row in a worksheet.
Ctrl+Home Move to the beginning of a worksheet (A1 cell).
Ctrl+R Fill Right.
Ctrl+Space Select the entire column.
Shift+Space Select the entire row.

We would love to hear from you which were the Excel Keyboard shortcuts you learned when you started using Microsoft Excel. You can write in comments below.

Do enrol for our free online excel course on shortcuts and formulas

Tags: