Shortcut Keys in Excel

Advertisements

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 Advertisment

Buy This Ad Space @$20 per Month, Ad Size 600X200 Contact on: hitesh.xc@gmail.com or 9999595223

Magenet is best Adsense Alternative here we earn $2 for single link, Here we get links ads. Magenet


For Projects 9999595223

Google Advertisements


Buy Websites 9999595223

Buy College Projects with Documentation Contact on whatsapp 9999595223. Contact on: hitesh.xc@gmail.com or 9999595223 Try this Keyword C++ Programs

Advertisements