Shortcut Keys in Excel

Google 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 Advertisements

We have more than 5 Groups which have 500000+ Members and some Pages have more than 100000+ members. If you want to post your article on our website/FB Group/FB Page please contact on hitesh.xc@gmail.com or 8076671483

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

Path variable is set for providing path for all Java tools like java, javac, javap, javah, jar, appletviewer which are used in java programming. All these tools are available in bin folders so we set path upto bin folders. Difference between path and classpath in Java

Classpath variable is set for providing a path for predefined Java classes which is used in our application. All classes are available in lib/rt.jar so we set classpath upto lib/rt.jar. Difference between path and classpath in Java

Cloud computing is the on demand availability of computer system resources, especially data storage and computing power, without direct active management by the user. Cloud Computing Tutorial

College Projects Related to Java, AWT, C Projects for College, C++ Projects for College, Android Projects. Download Java C C++ Projects


Download Projects

Adsense Advertisements


Buy This ads Space 8076671483

Buy This Ad Space @$120 per Month, Ad Size 300X600 Contact on: hitesh.xc@gmail.com or 8076671483 Try this Keyword C++ Programs