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 -           After that if it’ll ask for repair than cancle it -           Wait for some time it’ll take some time.( minimum 10 to  15 minutes. ) -           Click on view problem detail -           Scroll down and click on last link which one ends on “.txt” extention. -           One notepad file pops out -           Do not mess with it. -    
Read more

HOW TO INSTALL WINDOWS

-
Image
 Here i'm going to show you how to install windows 7 in your computer , here is 3 steps by following them you can easily install windows in your computer or laptop. 1) Download iso file  2) Bootable pendrive 3) Installing process    Notice : Create back up of your data on cloud storage or other storage devices.  1. Download iso file  first you have to go this website and download window's iso file , i have widows 7 iso file , you can download it from here... https://appsforpcfree.net/download-windows-7-iso-from-microsoft/ method is same to install any windows in your computer .  2. Bootable pendrive  Now you need a pen drive and format it. (Make sure you have back up). Install that software to make bootable pendrive. download it from here :  https://www.poweriso.com/download.php install this software. plug in pendrive in your computer. open that software. here it's looks... open tools option and click on create bootable pendrive. Select that iso file witch one you downloade
Read more