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

Introduction to Algorithms and Algorithmic Notation With Examples

Topic: Introduction to Algorithm and Algorithmic Notation With Examples What is an Algorithm? The step by step procedure to solve a particular problem is called an Algorithm .  A Good Programmer always writes algorithms before developing programs. Algorithmic Notation with example algorithms  Advantages of  writing an Algorithm The process of solving a problem becomes simpler and easier with the help of  algorithm. There are less chance of errors in the program, if we design algorithms before writing our programs in any programming language. We can convert an algorithm into a program of any programming language. It is not dependent on any programming language. Therefore it is easy to understand for anyone even without programming knowledge. What is the Relationship between an Algorithm and a Program Sponsored Links An algorithm is the sequenc of steps to perform a task, whereas a program is the set of statements to perfor...
Post a Comment
Read more

Define Data and Information With Examples

DATA Data is the collection of raw facts and figures. Actually data is unprocessed, that is why data is called collection of raw facts and figures. Define Data and Information with Examples We collect data from different resources. After collection, data is entered into computer for processing. Data may be collection of words, numbers, pictures,  or sounds etc. Examples of Data 1) Student Data on Admission Forms When students get admission in a college. They fill admission form. This form  contains raw facts (data of student) like name, father’s name, address of student, obtained marks, photo graph etc. 2)    Data of Citizens During census, data of all citizens is collected. The staff will go house to house and collect data about citizens like number of persons living in a home, either they are literate or illiterate, number of children, data of each child, cast, religion, Computerized national Identity Card number, address, how many rooms and...
4 comments
Read more

What are Dual Devices or Both Input/ Output Devices

The devices that can be used to perform both functions -input and output- are called Dual Devices. These devices are also called Dual Purpose Devices or Both Input/Output Devices. With the help of a dual purpose device, we can enter data into computer as well as we can output data from the computer to outside world.  For example, Dual devices include:  Touch Screen Monitor, Modem, Network Interface Card, Sound card, Hard disk drive, Floppy disk Drive, Magnetic Tape Drive CD-Writer and DVD-Writer etc. These are also called Input/output devices, because they perform both functions. Touch Screen Monitor Dual Devices or Both Input / Output Devices - Touch screens Touch Screen Monitor is an input/output device. It uses a special touch sensitive screen. The User can enter data by touching icons or menus on the screen. As soon as the user selects a command from menu, output is displayed on screen. Commonly touch screen monitors use sensors to detect touch of finger. ...
1 comment
Read more