Skip to main content

all short cut key excel

Here is a list of **Excel keyboard shortcuts** for both **Windows** and **Mac** to help speed up your work: ### **Common Excel Shortcuts (Windows)** 1. **Ctrl + N**: New Workbook 2. **Ctrl + O**: Open Workbook 3. **Ctrl + S**: Save Workbook 4. **Ctrl + P**: Print Workbook 5. **Ctrl + C**: Copy 6. **Ctrl + X**: Cut 7. **Ctrl + V**: Paste 8. **Ctrl + Z**: Undo 9. **Ctrl + Y**: Redo 10. **Ctrl + F**: Find 11. **Ctrl + H**: Replace 12. **Ctrl + A**: Select all 13. **Ctrl + Shift + L**: Toggle Filters 14. **Ctrl + Arrow Key**: Move to the edge of data (up, down, left, right) 15. **Ctrl + Shift + Arrow Key**: Select data to the edge (up, down, left, right) 16. **Ctrl + Space**: Select entire column 17. **Shift + Space**: Select entire row 18. **Alt + E, S, V**: Paste Special 19. **Ctrl + T**: Create Table 20. **Ctrl + 1**: Format Cells 21. **Ctrl + Shift + "$"**: Apply Currency format 22. **Ctrl + Shift + "%"**: Apply Percentage format 23. **Ctrl + Shift + "#"**: Apply Date format 24. **Ctrl + Shift + "!"**: Apply Number format with two decimals 25. **F2**: Edit active cell 26. **F4**: Repeat last action 27. **F7**: Spell Check 28. **Alt + E, S, F**: Fill down 29. **Ctrl + D**: Fill down 30. **Ctrl + R**: Fill right 31. **Ctrl + Shift + "+"**: Insert new cell/row/column 32. **Ctrl + "-"**: Delete selected cell/row/column ### **Advanced Excel Shortcuts (Windows)** 1. **Alt + E, A, A**: Clear contents 2. **Ctrl + Shift + K**: Insert hyperlink 3. **Ctrl + Shift + U**: Expand formula bar 4. **Ctrl + Shift + N**: Create new worksheet 5. **Ctrl + F3**: Name Manager 6. **Ctrl + Shift + Alt + T**: Insert current time 7. **Ctrl + Shift + Alt + D**: Insert current date 8. **Ctrl + Q**: Quick Analysis tool 9. **Ctrl + Shift + P**: Open print preview 10. **Alt + I, R**: Insert a row 11. **Alt + I, C**: Insert a column 12. **Ctrl + Shift + O**: Select all cells with comments --- ### **Common Excel Shortcuts (Mac)** 1. **Command + N**: New Workbook 2. **Command + O**: Open Workbook 3. **Command + S**: Save Workbook 4. **Command + P**: Print Workbook 5. **Command + C**: Copy 6. **Command + X**: Cut 7. **Command + V**: Paste 8. **Command + Z**: Undo 9. **Command + Y**: Redo 10. **Command + F**: Find 11. **Command + H**: Replace 12. **Command + A**: Select all 13. **Command + Shift + L**: Toggle Filters 14. **Command + Arrow Key**: Move to the edge of data (up, down, left, right) 15. **Command + Shift + Arrow Key**: Select data to the edge (up, down, left, right) 16. **Command + Space**: Select entire column 17. **Shift + Space**: Select entire row 18. **Command + 1**: Format Cells 19. **Command + T**: Create Table 20. **Command + Shift + "$"**: Apply Currency format 21. **Command + Shift + "%"**: Apply Percentage format 22. **Command + Shift + "#"**: Apply Date format 23. **Command + F2**: Edit active cell 24. **Command + D**: Fill down 25. **Command + R**: Fill right 26. **Command + Shift + "+"**: Insert new cell/row/column 27. **Command + "-"**: Delete selected cell/row/column 28. **F2**: Edit cell content 29. **Command + Shift + K**: Insert hyperlink ### **Advanced Excel Shortcuts (Mac)** 1. **Command + E**: Open Quick Analysis tool 2. **Command + T**: Create a new table 3. **Command + Shift + U**: Expand or collapse the formula bar 4. **Command + Shift + P**: Print preview 5. **Command + Option + R**: Show the Ribbon 6. **Command + Option + T**: Show/Hide the Toolbar 7. **Control + Option + Shift + T**: Open Date Picker These shortcuts will save you time and improve your efficiency in Excel.

Comments

Post a Comment

Popular posts from this blog

Ajowan (Carom Seeds): A Detailed Guide

  Ajowan (Carom Seeds): A Detailed Guide Ajowan , also known as carom seeds ( Trachyspermum ammi ), is a popular spice in Indian and Middle Eastern cuisine. It has a strong, pungent flavor and is known for its medicinal and culinary benefits. The tiny, oval-shaped seeds are often used to enhance the taste of dishes and provide various health benefits due to their bioactive compounds. Botanical Overview Scientific Name : Trachyspermum ammi Family : Apiaceae (Carrot family) Common Names : Carom seeds, Omam (in Tamil), Ajwain (in Hindi), Omán (in Arabic), Ajowan Parts Used : Seeds and essential oil Origin : Native to India and the Middle East, ajowan is now grown in various parts of the world, including Africa and Europe. Nutritional Composition Ajowan seeds are highly nutritious, offering a rich source of vitamins and minerals. Here’s a breakdown of its key nutrients (per 100g of ajowan seeds): Calories : 305 Protein : 15g Fat : 22g Fiber : 40g Calcium : 24% of th...
Post a Comment
Read more

How to learn coding

Agar aap coding seekhna chahte hain, toh yeh ek behtareen aur rewarding skill hai jo aapko bohot saari opportunities de sakti hai, chahe aap website development, software development, ya data science me career banana chahte ho. Main aapko step-by-step bataunga ki aap coding kaise seekh sakte hain: Step 1: Apne Goal Ko Define Karein Sabse pehle, aapko yeh decide karna hoga ke aap coding kis cheez ke liye seekhna chahte hain. Kya aap website banaana chahte hain? Mobile apps develop karna chahte hain? Ya aapko data analysis aur machine learning mein interest hai? Web Development:** HTML, CSS, JavaScript, aur PHP/Python seekhein. Mobile App Development:** Swift (for iOS) ya Kotlin/Java (for Android) seekhein. Software Development:** Python, Java, C++, ya C# seekhein. Data Science:** Python, R, aur SQL seekhein. Step 2: Programming Language Ka Intikhab Karein Aapko pehle ek programming language choose karni hogi. Beginners ke liye kuch popular aur accessible languages hain: 1.HTML ...
Post a Comment
Read more

WHO IS LORD MAHADEV (SHIVA)

Mahadev: Shakti Aur Aastha Ka Prateek Shiv, ya Mahadev, Hindu dharm ke sabse mahan devtaon mein se ek hain, jo apne adhyatmik aur shaktimaan roop ke liye prasiddh hain. Mahadev ko Bhagwan Shiv ke naam se bhi jaana jaata hai aur unka roop, unki shakti, aur unka jeevan prithvi par jeene waale har vyakti ko ek gahra adhyatmik sandesh deta hai. Mahadev sirf ek devta nahi, balki ek aise yogi aur adhyatmik guru hain jo apne bhakton ko jeevan ki asli maayene samajhne ki prerna dete hain. Unka jeevan, unki kahaniyaan, aur unki bhakti duniya ke har kone mein logon ke dilon ko chhoo leti hain. Mahadev Ki Mahima Aur Unka Roop Shiv ka roop bhayankar aur shantipurn dono hai. Unki ek taraf, wo Neelkanth ke roop mein jaane jaate hain, jab unhone samudra manthan ke dauran vish (poison) ko apne gale mein apnaaya tha, jisse unhone apne shakti aur daya ka pradarshan kiya. Mahadev ka dusra roop Nataraj hai, jo unki tantrik shakti aur rudra roop ko darshata hai, jisme wo universe ka nritya karte hain...
Post a Comment
Read more