Skip to main content

ADS

Shortcuts Microsoft Excel

Shotcuts Excel

Introduction

Microsoft Excel is a program developed by Microsoft that makes the use of a spreadsheet for doing work. It is very widely used especially for office and administrative activities to keep the entire records. It helps in calculations, creating various tables, graphing tools, saving important numerical data, arithmetic operations etc. It uses a structure of cells arranged in rows and columns. The shortcuts in Microsoft Excel will help you a lot to do your work very easily and in a fast manner.

Here is a list of important shortcuts for Microsoft Excel: 

      ·        F2- it helps in editing the selected cell.

      ·        F3- it helps to paste the names after their creation.

      ·        F4- for repeating the last task that you performed.

      ·        F5- for going to a specific cell.

      ·        F7- for spell checking.

      ·        F11- creating the chart by using the selected data.

      ·        Ctrl + Shift +; - for entering the current time.

      ·        Ctrl +; - for entering the current date.

      ·        Alt + Shift + F1- it helps in inserting a new worksheet.

      ·        Alt + Enter- it will move the text to the next line in the cell.

      ·        Shift + F3- it will open the formula window.

      ·        Shift + F5- it will open the search box.

      ·        Ctrl + 1- it will open the window with the option of format cells.

      ·        Ctrl + A- it helps in selecting all the contents of the worksheet.

      ·        Ctrl + B- to bold the selected section.

      ·        Ctrl + I- to make the selected section italic.

      ·        Ctrl + K- to insert the link.

      ·        Ctrl + S- to save the currently opened worksheet.

      ·        Ctrl + U- to underline.

      ·        Ctrl + 5- to strikethrough the highlighted selection.

      ·        Ctrl + P- for printing.

      ·        Ctrl + Z- to undo the last task performed.

      ·        Ctrl + F3- to open the excel name manager.

      ·        Ctrl + F9- help to minimize the current window.

      ·        Ctrl + F10- help to maximize the current window.

      ·        Ctrl + F6- helps in switching between open workbooks.

      ·        Ctrl + Page up- helps in moving between worksheets in the same document.

      ·        Ctrl + Page down- helps in moving between worksheets in the same document.

      ·        Ctrl + Tab- helps in moving between two or more open excel files.

      ·        Alt + = - creates the sum total of all the above cells.

      ·        Ctrl + ' – for inserting the value of the above cell into the current cell.

      ·        Ctrl + Shift + 1 – uses comma format for numbers.

      ·        Ctrl + Shift + 4- uses currency format for numbers.

      ·        Ctrl + Shift + 3- uses date format for numbers.

      ·        Ctrl + Shift + 5- uses percentage format for numbers.

      ·        Ctrl + Shift + 6- uses scientific format for numbers.

      ·        Ctrl + Shift + 2- uses time format for numbers.

      ·        Ctrl + Arrow key- helps in moving to next section of the text.

      ·        Ctrl + Space-helps in selecting an entire column.

      ·        Shift + Space- helps in selecting an entire row.

      ·        Ctrl + - - helps in deleting the selected row or column.

      ·        Ctrl + Shift + = -helps inserting a new row or column.

      ·        Ctrl + Home – helps in moving to the cell A1.

      ·        Ctrl + ~ -helps in switching between showing the values in the cells or the excel formulas.

Conclusion

These shortcuts are very widely used in Microsoft Excel and can surely help anyone who uses them in their daily routine work. It will make the work very easy and you will be able to finish all your tasks without any hassles.

Comments

Popular posts from this blog

KID S GK FOR STANDARD 2 AND 3 [PAGE NO.4]

INDIA QUIZ
SUPERLATIVES OF INDIA भारत में उत्त्कृष्ट 
1. Which is the longest bridge in India?
Ans.Bhupen Hazarika Setu

भारत में सबसे लंबा पुल कौनसा है?
उत्तर:भूपेन हज़ारिका सेतु

2. Which is the tallest minaret in India?
Ans.Fateh Burj

भारत में सबसे ऊँची ईमारत कौनसी है?
उत्तर:फतेह बुर्ज

3. Which is the biggest mosque in India?
Ans.Jama Masjid

भारत में सबसे बड़ी मस्जिद कौनसी है?
उत्तर:जामा मस्जिद

4. Which is the largest temple in India?
Ans.Srirangam

भारत में सबसे बड़ा मंदिर कौनसा है?
उत्तर:श्रीरंगम

5. Which is the largest sand desert in India?
Ans.Thar

भारत में सबसे बड़ा मरुस्थल कौनसा है?
उत्तर:थार

6. Which is the longest river in India?
Ans.Ganga

भारत में सबसे लम्बी नदी कौनसी है?
उत्तर:गंगा

7. Which city of the Uttar Pradesh has the Taj Mahal?
Ans.Agra

ताजमहल उत्तरप्रदेश के कौनसे शहर में है?
उत्तर:आगरा

8. Where is Dalhousie Hill Station located in India?
Ans.Himachal Pradesh

डलहौज़ी हिल स्टेशन भारत में कहाँ स्थित है?
उत्तर:हिमाचल प्रदेश

9. Who was the first Indian to win Gold Medal at the O…

KID S GK FOR STANDARD 2 AND 3 [PAGE NO. 6]

INDIA QUIZ WOMEN FIRSTS IN INDIA भारत में महिला सर्वप्रथम  1.First woman doctor of India? Ans.Anandi Gopal Joshi
भारत की पहली महिला चिकित्सक? उत्तर:आनंदी गोपाल जोशी 
2.First woman Merchant Navy Officer of India? Ans.Sonali Banerjee
भारत की पहली महिला मर्चेंट नेवी अफसर? उत्तर:सोनाली बनर्जी 
3.First woman teacher of India? Ans.Savitribai Phule
भारत की पहली महिला अध्यापिका? उत्तर:सावित्रीबाई फूल 
4.First woman President of India? Ans.Mrs.Pratibha Patil
भारत की पहली महिला राष्ट्रपति? उत्तर:श्रीमती प्रतिभा पाटिल 
5.First woman Prime Minister of India? Ans.Mrs.Indira Gandhi
भारत की पहली महिला प्रधानमंत्री? उत्तर:श्रीमती इंदिरा गाँधी 
6.First Indian World No.1 woman's tennis sportsperson(doubles)? Ans.Sania Mirja
'विश्व नंबर एक' पहली भारतीय महिला टेनिस खिलाडी (डबल्स में)? उत्तर:सानिया मिर्जा
7.First Indian No.1 women's badminton player? Ans.Saina Nehwal
पहली भारतीय महिला नंबर एक बैडमिंटन खिलाडी? उत्तर:साइना नेहवाल 
8.First woman Chief Minister of India? Ans.Sucheta Kriplani(Utt…
INDIA QUIZTHE FIRSTS IN INDIAभारत में सर्वप्रथम  1. Who was the first President of India?
Ans.Dr.Rajendra Prasad

भारत का पहला राष्ट्रपति कौन था?
उत्तर:डॉ राजेंद्र प्रसाद

2. Who was the first Prime Minister of India?
Ans.Pt.Jawaharlal Nehru

भारत का पहला प्रधानमंत्री कौन था?
उत्तर:पं.जवाहरलाल नेहरू

3. Who was the first Woman President of India?
Ans.Mrs.Pratibha Patil

भारत की पहली महिला राष्ट्रपति कौन थी?
उत्तर:श्रीमति प्रतिभा पाटिल

4. Who was the first woman Prime Minister of India?
Ans.Mrs.Indira Gandhi

भारत की पहली महिला प्रधानमंत्री कौन थी?
उत्तर:श्रीमति इंदिरा गाँधी

5. Who was the first Vice President of India?
Ans.Dr.S.Radhakrishanan

भारत का पहला उपराष्ट्रपति कौन था?
उत्तर:डॉ.एस.राधाकृष्णन

6. Who was the first Deputy Prime Minister of India?
Ans.Sardar Vallabh Bhai Patel

भारत का पहला उप-प्रधानमंत्री कौन था?
उत्तर:सरदार वल्लभभाई पटेल

7. Who was the first Indian Bowler to get a Hat-trick in Test Cricket?
Ans.Harbhajan Singh

टेस्ट क्रिकेट में हैट-ट्रिक पाने वाला पहला भारतीय गेंदबाज़ कौ…