Skip to main content

40 Most Important Short Cut Keys Every Microsoft Excel User Must Know

Today we will discuss 40 Most Important Shortcut Keys in MS Excel Everyone Should Know. Keyboard shortcuts saves a lot of time. Using keyboard shortcuts instead of mouse will make typing easier and faster.
40 Most Important Short Cut Keys Every Microsoft Excel Users Must Know
40 Most Important Short Cut Keys Every Microsoft Excel Users Must Know

Sr.No. Keyboard Shortcut Function of Shortcut Key
1 CTRL + N To Create a new Workbook [New File]
2 CTRL + O To open an existing Workbook in Excel
3 CTRL + S To Save an Excel Workbook.
If workbook is not saved yet, it will ask filename and location
to save the workbook for first time.
If you have saved workbook already with a filename, it will save
any changes occurred since last save.
4 CTRL + W To Close the selected workbook window.
5  F12 To display Save As dialog box,
You can save the workbook with a new name and / or on a different location.
6 CTRL + F2 To show Print Preview
7 CTRL + P To display Print dialog box
you can set different print options like page size, margin size, number of copies etc and print worksheet.
8 ALT + F4  To Exit from Excel
9 CTRL + F1  To collapse or expand Ribbon
10 CTRL + A  Select all, To select entire current worksheet
11 CTRL + C Copy contents of selected cells
12 CTRL + X Cut contents of selected cells
13 CTRL + V Paste copied or cut contents from clipboard
14 CTRL + ALT + V Show paste special dialog box
15 CTRL + F  Find, To display Find dialogbox
16 CTRL + H  Replace, To show Find / Replace dialog box. Replace option selected.
You can replace occurrences of an existing word by a new word easily.
17 SHIFT+SPACE To Select entire current row
18 CTRL + SPACE To Select entire current column
19 CTRL + V Paste copied or cut contents from clipboard
20 SHIFT+F11 To insert new worksheet
21 CTRL + PageDown To go to next worksheet 
22 CTRL + PageUp To go to previous worksheet
23 F7 To show Spelling check dialog box
24 SHIFT+F7 To display Thesaurus dialog box
25 ALT+Enter To insert a line break in a cell
26 CTRL + Z To undo last action
27 CTRL + Y To redo last action
28 F1 To show Help dialog box
29 F10 To activate the menu bar
30 CTRL + G To display go to dialog box
31 CTRL + ; Insert current date in a cell
32 CTRL + Shift + ; Inserts current time in a cell
33 CTRL + B To apply / toggle  bold text on contents of selected cells
34 CTRL + U To apply / toggle  underline text on contents of selected cells
35 CTRL + I To apply / toggle  italic text on contents of selected cells
36 CTRL + KTo show Insert Hyperlink dialog box
37 F2To edit the active cell
38 EscTo cancel
39 CTRL + 5To apply strike through in selected cells
40 CTRL + 1To show Format cells dialog box
MS Excel Formulas and Functions
40 Most Important Short Cut Keys Every Microsoft Excel User Must Know



Microsoft Excel Formulas and Functions Fast and Easy Way -1

Using Simple Formulas in Excel With Arithmetic Operators 2

How Functions are Used in Excel Fast and Easy Way 3

Create Bar Chart in Excel Easily by Example

Employee Pay sheet Formulas in Microsoft Excel 

Students Test Score Grades Result Sheet in Excel

MS Excel House Building Expense Management Formulas Worksheet

Excel Worksheet With Income Tax Calculation Formula on Employee Pay

Microsoft Excel Formulas To Calculate Your Age in Years Months Days and Day of Birth

Create 3D Line Chart in MS EXCEL for 2 Cricket Teams

 Create Save Password Protect Workbook in Excel

 Use of Text Functions Left Right Mid in Excel

 Use of Max Min Functions in Excel

Use of Average Function With Examples

 Uses of Excel in Business and Commerce

 Use of SUM Function With Examples in MS Excel

 Create PIE Chart in MS Excel

40 Most Important Short Cut Keys Every Microsoft Excel User Must Know

40 Most Important Short Cut Keys Every Microsoft Excel User Must Know
40 Most Important Short Cut Keys Every Microsoft Excel User Must Know




Labels:

Comments

Post a Comment

Popular posts from this blog

Explain Advantages Of Networks

Define Network with examples. Give importance of Computer Network. COMPUTER NETWORK We can define a Computer Network as a set of two or more connected computers to share information and other resources (data, files, printers, hard disk, modem, CD-Rom Drive, CD-Writer, DVD-Rom Drive, DVD-Writer etc.). The computers in a network can share: Data, Information, Files Software Hardware (printers, disk, modems)etc. Advantages of Computer Networks EXAMPLES OF COMPUTER NETWORK Computer network can be used in an office. Different people in the office can share common information and printer. Net Cafes use Computer Network for internet sharing. Net Cafe Owners can save money by sharing one DSL Routers / Modem and a single Internet Connection. Computer Network is used in Computer Laboratories of Schools, Colleges and other educational institutes. Internet, is also an example of a computer network. Internet is a network of millions of computers connected through phone lin...
Post a Comment
Read more

Explain different types of storage devices

Topic: Explain different types of storage devices in Computer systems Storage Devices Storage devices are used to store data and instructions permanently. Storage devices are also called secondary storage devices / backing storage devices / external storage devices or auxiliary storage devices. Examples of storage devices include Hard Disk, CD and DVD etc. Why Secondary Storage Devices are Used? Secondary storage devices are used because: Primary memory(RAM) is volatile and temporary. When computer is switched off, all data in ram is erased. Storage devices can store large amounts of data and instructions permanently whereas Primary memory has less capacity of storing data. Types Of Storage Devices There are three main types of storage devices:  Magnetic Tape   Magnetic Disk   Optical Disk   Flash Memory storage devices 1. Magnetic Tape Magnetic tape is the oldest storage device. It is made of plastic coated with m...
3 comments
Read more

Types Of Headings In HTML

HTML Hedings Headings in HTML are used to display Titles, Sub-Titles of Sub-Sub-Titles for your web page text. There are six types of headings in HTML. H1 is the largest heading and H6 is the smallest heading. <H1> is opening tag whereas </H1> is the closing tag for the largest heading. The text between <h1> and </h1> will be displayed as the main Title in your web page. Following are the six tags used for six types of headings in HTML. <H1> ... </H1> <H2> ... </H2> <H3> ... </H3> <H4> ... </H4> <H5> ... </H5> <H6> ... </H6> The H1 heading is used for main titles. Actually H1 heading will show the text in largest font size. H2 headings is used for Sub-Titles. H2 displays text in smaller font size than H1, H3 displays text of font size smaller than H1 and H2, and so on. H1 is for largest heading in a text page and H6 is for smallest heading.   Importance Of Headings in SEO H...
Post a Comment
Read more