18 Most Useful Excel Shortcuts
Learning hundreds Shortcuts is intimating, but learning 18 shortcuts isn't a very difficult task. It is my conviction that if you start to use and master these 18 shortcuts in Excel, your speed of using Excel will go up atleast 3x times.
1. Insert new sheet in Excel )) Shift + F11
2. Go to previous / next sheet )) Ctrl + PageUp / Ctrl + PageDown
3. Go to a point where the next cell is blank / also select )) Ctrl +
Arrow / Ctrl + Shift + Arrow
4. Format cells dialog box open )) Ctrl + 1
5. Change Date format )) Ctrl + Shift + 3
6. Select all data / full sheet )) Ctrl + A
7. Select full column / full row )) Ctrl + Space / Shift + Space
8. Insert / Delete row or column )) Ctrl + + / Ctrl + -
9. Insert today's date )) Ctrl + ;
10. Apply All borders )) Alt - H - B - A
11. Turn on Filter )) Ctrl + Shift + L
12. Open dropdown in filter )) Alt + Down Arrow
13. Sort in ascending / descending order )) Alt - A - S - A / Alt - A - S - D
14. Sort box open )) Alt - A - S - S
15. Find / Replace )) Ctrl + F / Ctrl + H
16. Paste special )) Ctrl + Alt + V
17. Write in same cell but in next line )) Alt + Enter
18. Repeat last action )) F4
_______________
After this video, to learn in-depth about Pivot tables and charts, Enroll for an Online course conducted by me on Master Business Reporting with Pivot tables and charts in Excel
Also, as you are a KZread Viewer / Subscriber,
we would like to give out a special discount just for you -
www.udemy.com/master-business...
__________________
SUBSCRIBE NOW!
/ @excelrush
Click this link to learn more awesome functions in Excel
• Learn Excel's Tricks
Click this link to learn how to manage your personal finance using Excel
• Personal Finance
Logo Music - "Blonde" by Nctrnm
Пікірлер: 9
These are so helpful, thank you.
Keep up the good work sir
Amazing so helpful tricks ☺️
Soon you will reach more people ☺️ good work
@Excelrush
4 жыл бұрын
Thank you!
Your short trick are very awesome but some are not working as control + f11, control + page down & up etc
This is amazing!! Glad my work load reduced by hours!
hello sir, your work really I enjoy this sir, I want to make a two different colour in the same column if the number is double mins two times then it will be yellow and the other hand number will be more then two times then it will be red. please guide me on this.
@Excelrush
5 жыл бұрын
You will need to use a custom formula in conditional formatting for this.