100 Excel Shortcuts You Must Know for Faster Work

-

 100 Excel Shortcuts You Must Know for Faster Work 

MS Excel is very powerful and useful.  Top 100 Excel shortcuts blew. They can save your time and increase your work efficiency.

✅ Basic Excel Shortcuts

  1. Ctrl + N – Create a new workbook

  2. Ctrl + O – Open an existing workbook

  3. Ctrl + S – Save the workbook

  4. F12 – Save As

  5. Ctrl + P – Print workbook

  6. Ctrl + C – Copy selected cells

  7. Ctrl + X – Cut selected cells

  8. Ctrl + V – Paste

  9. Ctrl + Z – Undo

  10. Ctrl + Y – Redo

✅ Navigation Shortcuts

  1. Ctrl + → – Move to the last column with data

  2. Ctrl + ← – Move to the first column with data

  3. Ctrl + ↑ – Move to the top row with data

  4. Ctrl + ↓ – Move to the bottom row with data

  5. Home – Move to the beginning of a row

  6. Ctrl + Home – Go to cell A1

  7. Ctrl + End – Go to last used cell

  8. Page Up – Scroll up one screen

  9. Page Down – Scroll down one screen

  10. Alt + Page Up/Page Down – Move one screen left/right

✅ Selection Shortcuts

  1. Shift + Arrow Keys – Extend selection by one cell

  2. Ctrl + Shift + Arrow – Select entire row/column until last filled cell

  3. Ctrl + A – Select entire sheet

  4. Ctrl + Shift + Space – Select entire column

  5. Shift + Space – Select entire row

  6. Ctrl + Space – Select column of active cell

  7. Ctrl + Shift + End – Select to last used cell

  8. Ctrl + Shift + Home – Select to A1

  9. F8 – Extend selection mode

  10. Shift + F8 – Add to selection

✅ Formatting Shortcuts

  1. Ctrl + 1 – Format cells dialog box

  2. Ctrl + B – Bold

  3. Ctrl + I – Italic

  4. Ctrl + U – Underline

  5. Alt + H + H – Fill color

  6. Alt + H + F + C – Font color

  7. Ctrl + Shift + $ – Apply currency format

  8. Ctrl + Shift + % – Apply percentage format

  9. Ctrl + Shift + # – Apply date format

  10. Ctrl + Shift + @ – Apply time format

✅ Row & Column Shortcuts

  1. Ctrl + Shift + “+” – Insert new cell/row/column

  2. Ctrl + “-” – Delete selected cells

  3. Ctrl + 9 – Hide selected rows

  4. Ctrl + Shift + 9 – Unhide rows

  5. Ctrl + 0 – Hide selected columns

  6. Ctrl + Shift + 0 – Unhide columns

  7. Shift + Space – Select entire row

  8. Ctrl + Space – Select entire column

  9. Alt + I + R – Insert row

  10. Alt + I + C – Insert column

✅ Formula Shortcuts

  1. = (Equal sign) – Start a formula

  2. Alt + = – AutoSum

  3. Ctrl + ` – Show formulas

  4. F2 – Edit cell

  5. Shift + F9 – Calculate active sheet

  6. F9 – Calculate all worksheets

  7. Ctrl + Shift + Enter – Enter array formula

  8. Ctrl + Shift + “ – Copy value from cell above

  9. Ctrl + ‘ – Copy formula from cell above

  10. Alt + Enter – Insert line break in cell

✅ Data Handling Shortcuts

  1. Ctrl + T – Create table

  2. Ctrl + L – Create list/table

  3. Alt + A + T – Filter

  4. Alt + Down Arrow – Open filter menu

  5. Alt + E + S + V – Paste Special → Values

  6. Alt + E + S + T – Paste Special → Formats

  7. Alt + H + S – Sort menu

  8. Alt + D + F + F – Add/remove filter

  9. Alt + N + V – Insert PivotTable

  10. F11 – Create chart from selection

✅ Workbook & Window Management

  1. Ctrl + Tab – Switch between workbooks

  2. Ctrl + F4 – Close workbook

  3. Ctrl + W – Close window

  4. Ctrl + N – New workbook

  5. Ctrl + Shift + N – New workbook (template)

  6. Alt + Tab – Switch between apps

  7. Ctrl + F2 – Print preview

  8. Alt + F1 – Create chart in same sheet

  9. Alt + F8 – Macro dialog box

  10. Alt + F11 – Open VBA editor

✅ Search & Replace

  1. Ctrl + F – Find

  2. Ctrl + H – Replace

  3. Ctrl + Shift + F – Advanced find

  4. Ctrl + Shift + H – Advanced replace

  5. Alt + Enter – Insert new line in a cell

  6. Ctrl + Shift + L – Toggle filter

✅ Miscellaneous Shortcuts

  1. F4 – Repeat last action

  2. F7 – Spell check

  3. F1 – Help

  4. Ctrl + ; – Insert current date

  5. Ctrl + Shift + : – Insert current time

  6. Ctrl + K – Insert hyperlink

  7. Shift + F2 – Insert/edit comment

  8. Ctrl + Shift + U – Expand formula bar

  9. Ctrl + Alt + V – Paste special dialog

  10. Alt + E + S + F – Paste formula

  11. Alt + E + S + W – Paste column width

  12. Ctrl + Shift + “+” – Insert cell

  13. Ctrl + - – Delete cell

  14. Ctrl + Shift + & – Apply outline border

Apply these shortcut keys in your daily life for practice.

Comments

Post a Comment

Popular posts from this blog

5 Passive Income Ideas That Actually Work

-
5 Passive Income Ideas That Actually Work Do you know what passive income means? It’s like planting a tree. At first, you work hard to plant it and water it. But after some time, it gives you fruits without much work. Sounds cool, right? That’s what passive income does – you work once and keep earning money later. Here are 5 passive income ideas that really work in 2025 : 1. Start a YouTube Channel Imagine making videos about games, toys, or fun stories. People watch them, and YouTube gives you money for ads. You just make the video once, and it can earn for years! 2. Write an eBook If you love stories or know something interesting, write a small book and sell it on Amazon Kindle. People can buy it even when you are sleeping. 3. Make an Online Course Are you good at drawing, coding, or even solving puzzles? Make a video course and put it on websites like Udemy. Every time someone buys it, you get money! 4. Start a Blog Write about things you like—games, cartoons, or tips. La...
Read more

How to Make Money With Affiliate Marketing as a Beginner

-
  How to Make Money With Affiliate Marketing as a Beginner Do you know what affiliate marketing is? It’s like telling your friends about a cool toy, and when they buy it, the shop gives you a gift. In affiliate marketing, you share links to products online, and when someone buys through your link, you earn money. Simple, right? Let’s see how beginners can start making money with affiliate marketing in 2025: 1. Understand Affiliate Marketing Affiliate marketing means promoting someone else’s product. You don’t make the product, you just recommend it. When someone buys using your link, you get a commission (money for helping them sell). 2. Pick a Niche A niche means your topic. It can be gadgets, fashion, fitness, or even gaming. Choose something you love because you’ll talk about it a lot. 3. Join Affiliate Programs Sign up for programs like: Amazon Associates – for almost everything Flipkart Affiliate – in India ClickBank – for digital products CJ Affiliate ...
Read more

What is Print-on-Demand (POD) and How Can You Make $500/Month?

-
Image
  1. Introduction – What is Print-on-Demand (POD) and How Can You Make $500/Month? Imagine you have a magic shop. In this shop, you don’t keep any products ready — instead, when someone buys a t-shirt, mug, or bag from you, a special company makes (manufactures) it only after they place their order. That’s what Print-on-Demand means — You design it → The customer buys it → The company prints it → The company sends it to the customer. You don’t have to make, store, or send anything yourself. 2. Benefits of POD - No big money needed to start — You don’t need to buy 100 t-shirts in advance. Low risk — You only make a product when someone has already paid for it. Fun and creative — You can put your own funny quotes, pictures, or ideas on products. Easy- It's easy to start POD. 3. Setting a $500/Month Goal – Breaking Down the Numbers Let’s do some easy math. Suppose you earn $5 profit from each product you sell. To make $500 in a month , you need to sell: ...
Read more