Shortcut Keys in Excel


Prev Tutorial Next Tutorial

Shortcut Keys in Excel

In this tutorial I will give you all the major shortcut keys usable in Microsoft Excel.

shortcut keys in excel
ShortcutDescription
F2Edit the selected cell.
F3After a name has been created, F3 will paste names.
F4Repeat last action. For example, if you changed the color of text in another cell, pressing F4 will change the text in cell to the same color.
F5Go to a specific cell. For example, C6.
F7Spell check selected text or document.
F11Create chart from selected data.
EscCancel an entry in the cell or Formula Bar.
Create chart from selected data.Enter the current time.
Ctrl+;Enter the current date.
Alt+Shift+F1Insert New Worksheet.
Alt+EnterWhile typing text in a cell, pressing Alt+Enter will move to the next line, allowing for multiple lines of text in one cell.
Shift+F3Open the Excel formula window.
Shift+F5Bring up search box.
Ctrl+1Open the Format Cells window.
Ctrl+ASelect all contents of the worksheet.
Ctrl+BBold highlighted selection.
Ctrl+IItalic highlighted selection.
Ctrl+KInsert link.
Ctrl+SSave the open worksheet.
Ctrl+UUnderline highlighted selection.
Shift+SpaceSelect entire row.
Ctrl+Shift+=Insert a new column or row.
Ctrl+HomeMove to cell A1.
Ctrl+EndMove to last cell
Ctrl+Arrow keyMove to next section of text.
Ctrl+TabMove between Two or more open Excel files.
Ctrl+F4Close Window
Shift+Page UpSelect To Top Of Module
Shift+Page DownSelect To End Of Module
Shift+Left ArrowExtend Selection Left 1 Char
Shift+Right ArrowExtend Selection Right 1 Char
Shift+Up ArrowExtend Selection Up
Shift+DownArrow Extend Selection Down

Prev Tutorial Next Tutorial

Google Advertisements

Download Projects

Google Adsense Advertisements

Buy 3 Year Old Domain, Tutorialday.com, SeosmoTools.com @$200

Buy This Ad Space @$50 per Month, Ad Size 300X250 Contact on: hitesh.xc@gmail.com WhatsApp no. 8882538826

Yahoo Advertisements