50 Shortcut keys of MS Office Excel.

-



    Here is some shortcut keys of MS Office Excel. It will make your work easy and fast.

1.Ctrl + N : Open new work book.

2.Ctrl + A :  Select entire workbook.

3.Ctrl + B : Turn highlighted cells Bold.

4.Ctrl + C : Copy cell.

5.Ctrl + V : Paste value in cell.

6.Ctrl + U : Turn highlighted cells Underline.

7.Ctrl + I : Turn highlighted cells Italic.

8.Ctrl + D : To fill upper cell value in current cell.

9.Ctrl + S : Save workbook.

10.Ctrl + O : Open saved workbook.

11.Ctrl + K : To insert hiperlink in cell.

12.Ctrl + P : Print workbook.

13.Ctrl + Space : Select entire column.

14.Ctrl + W : Close workbook.

15.Ctrl + ; : Enter current date.

16.Ctrl + Shift + :  : Enter current time. 

17.Ctrl + Shift + $ : To apply currency formating in cell or selected cells.

18.Ctrl + Shift + @ : Time Formating.

19.Ctrl + Shift + = : Insert columns or rows.

20.Ctrl + 1 : Formate cell contents.

21.Ctrl + 5 : Put a strikethrought in cell.

22.Ctrl + 8 : Show outline symbols.

23.Ctrl + 9 : Hide a row.

24.Ctrl + 0 : Hide a column.

25.Ctrl + Z : Undo changes.

26.Ctrl + Y : Redu changes.

27.Ctrl + Shift + # : Date formaing.

28.Ctrl + Shift + 0 : Select cell containing comments.

29.Ctrl + Up Arrow : To go to the top most cell in current column.

30.Ctrl + Down Arrow : To jump to the last most cell in current column.

31.Ctrl + Left Arrow : To jump back in most cell in current row.

32.Ctrl + Right Arrow : To go to the last most cell in current column.

33.Esc : Clear contents during editing situation in cell.

34.Alt + H + B :  Add a border.

35.Alt + H + H : Add a colour.

36.F2 : Edit cell.

37.Ctrl + End : Go last cell in workbook.

38.Ctrl + Home : Jump back first cell in workbook.

39.Ctrl + W : Close current workbook.

40.Ctrl + Shift + _(Underline) : Remove border.

41.Ctrl + Shift + & : Place border around selected cells.

42.Shift + Tab :  To go back previouse cell.

43.Tab : Move next cell.

44.Alt + 1 : Turn on auto save.

45.Alt + F + Z : Share workbook.

46.Ctrl + - : Delete column or row.

47.Ctrl + F : Find contents or values.

48.Shift + Right Arrow : Select current cell to further cells.

49.Shift + Left Arrow : Select current cell to previouse cells.

50.Ctrl + F4 : Close Excel.


Bonus trick 

press Alt button on your key-board and you'll see some alphabets on menu bar. like this..



Simply press that alphabet which menu you wan to go.


This 50 shortcut keys will make your work easy and faster.

I hope this will be worth it for you.

For more tech related gadgets , tips and tricks click on subscribe button "It's Free"  after that you'll get notification for my next post. 


KEEP SMILING....

☺

Comments

Post a Comment

Popular posts from this blog

How to Connect 'Xender' to your Computer...

-
Image
Xender In Your Computer you can share files or anything from your phone to Computer by using Xender Step 1 :- First open your internet browser (Google Crome) Search 'Web xander' Open first link....   OR Click on it 👉  http://web.xender.com/  👈 You will see QR Code something like this... Step 2 :- Open Xender on your Phone.. tap on profile icon..You will see 'Connect to PC' option, tap on it. Step 3:- Here you will see 'Scan' option tap on it and Scan that QR Code from your PC. You Xender will be successfully  connected to your PC. Enjoy..   :D
Read more

How to change your computer password...

-
Image
How  to unlock your computer Or How to reset windows 7 password. (it will work for all operating system..but i'm going to show you windows 7 method.) If you forgot your computer password than it will help you to unlock your computer. Method : - -           Restart your computer and suddenly turn it off by using power button -           Press and hold few seconds to turn it off -           Do that same thing again and again until your computer don’t shows “Startup Repair” options. -           3 rd or 4 th try you will get start up repair option -            -           Click on launch startup repair option -           Wait for this process -    ...
Read more

How to Connect Xender to Jio Phone

-
Image
Are you want to  upload some file, music, video etc..in Jio phone by using Xender... Here is very easy method to connect Xender in Jio phone... Step 1 :- Open Xender in your smart phone..click on profile or menu  icon ... and select "Connect  to Jio phone"  option, and click on "CREATE HOTSPOT",  After that you will see URL Like this.... Step  2 :- Open settings in your JioPhone and select Wi-fi option.  Turn it on then you will  see 'Available Networks' option, click on it then you will something "android share" like this..  click on it and enter your password as it saw in your android phone's Xender. Step 3 :- Open internet browser and type that URL.and Press OK button in Jio phone.. After that your Xender successfully connect to  Jio phone... Here is video link for batter understanding.... 👉👉   VIDEO ENJOY...
Read more