Microsoft Excel : 100 Shortcuts keys

By -

               

 

 



 1.Ctrl + N : To create a new workbook.


2.Ctrl + O : To open a saved workbook.

 

3.Ctrl + S : To save a workbook.

 

4.Ctrl + A : To select all the contents in a workbook.

 

5.Ctrl + B : To turn highlighted cells bold.

 

6.Ctrl + C : To copy cells that are highlighted.

 

7.Ctrl + D : To fill the selected cell with the content of the cell      right above


8.Ctrl + F : To search for anything in a workbook.

 

9.Ctrl + G : To jump to a certain area with a single command.

 

10.Ctrl + H : To find and replace cell contents.

 

11.Ctrl + I : To italicise cell contents.

 

12.Ctrl + K : To insert a hyperlink in a cell.


13.Ctrl + L : To open the create table dialog box.


14.Ctrl + P : To print a workbook.


15.Ctrl + R : To fill the selected cell with the content of the cell on the left.


16.Ctrl + U : To underline highlighted cells.


17.Ctrl + V : To paste anything that was copied.


18.Ctrl + W : To close your current workbook.


19.Ctrl + Z : To undo the last action.

 

20.Ctrl + 1 : To format the cell contents.

 

21.Ctrl + 5 : To put a strikethrough in a cell.


22.Ctrl + 8 : To show the outline symbols.


23.Ctrl + 9 : To hide a row.


24.Ctrl + 0 : To hide a column.


25.Ctrl + Shift + :  To enter the current time in a cell.


26.Ctrl + ; : To enter the current date in a cell.


27.Ctrl + `: To change the view from displaying cell values to formulas.


28.Ctrl + ‘: To copy the formula from the cell above.


29.Ctrl + - : To delete columns or rows.


30.Ctrl + Shift + = : To insert columns and rows.


31.Ctrl + Shift + ~ : To switch between displaying Excel formulas


32.Ctrl + Shift + @ : To apply time formatting.


33.Ctrl + Shift + ! : To apply comma formatting.


34.Ctrl + Shift + $ : To apply currency formatting.


35.Ctrl + Shift + # : To apply date formatting.


36.Ctrl + Shift + % : To apply percentage formatting.


37.Ctrl + Shift + & : To place borders around the selected cells.


38.Ctrl + Shift + _ : To remove a border.


39.Ctrl + - : To delete a selected row or column.


40.Ctrl + Spacebar : To select an entire column.


41.Ctrl + Shift + Spacebar : To select an entire workbook.


42. Ctrl + Home : To redirect to cell A1.


43. Ctrl + Shift + Tab : To switch to the previous workbook.


44. Ctrl + Shift + F : To open the fonts menu under format cells.

 

45. Ctrl + Shift + O : To select the cells containing comments.


46. Ctrl + Drag : To drag and copy a cell or to a duplicate worksheet.


47. Ctrl + Shift + Drag : To drag and insert copy.


48. Ctrl + Up arrow : To go to the top most cell in a current column.


49. Ctrl + Down arrow : To jump to the last cell in a current column.


50. Ctrl + Right arrow : To go to the last cell in a selected row.


51. Ctrl + Left arrow : To jump back to the first cell in a selected row.


52. Ctrl + End : To go to the last cell in a workbook.


53. Alt + Page down : To move the screen towards the right.


54. Alt + Page Up : To move the screen towards the left.


55. Ctrl + F2 : To open the print preview window.


56. Ctrl + F1 : To expand or collapse the ribbon.


57. Alt : To open the access keys.


58. Tab : Move to the next cell.


59. Alt + F + T : To open the options.


60. Alt + Down arrow : To activate filters for cells.


61. F2 : To edit a cell.


62. F3 : To paste a cell name if the cells have been named.


63. Shift + F2 : To add or edit a cell comment.


64. Alt + H + H : To select a fill colour.


65. Alt + H + B : To add a border.


66. Ctrl + 9 : To hide the selected rows.


67. Ctrl + 0 : To hide the selected columns.


68. Esc : To cancel an entry.


69. Enter : To complete the entry in a cell and move to the next one.


70. Shift + Right arrow : To extend the cell selection to the right.


71. Shift + Left arrow : To extend the cell selection to the left.


72. Shift + Space : To select the entire row.


73. Page up/ down : To move the screen up or down.


74. Alt + H : To go to the Home tab in Ribbon.


75. Alt + N : To go to the Insert tab in Ribbon.


76. Alt + P : To go to the Page Layout tab in Ribbon.


77. Alt + M : To go to the Formulas tab in Ribbon.


78. Alt + A : To go to the Data tab in Ribbon.


79. Alt + R : To go to the Review tab in Ribbon.


80. Alt + W : To go to the View tab in Ribbon.


81. Alt + Y: To open the Help tab in Ribbon.


82. Alt + Q : To quickly jump to search.


83. Alt + Enter : To start a new line in a current cell.


84. Shift + F3 : To open the Insert function dialog box.


85. F9 : To calculate workbooks.


86. Shift + F9 : To calculate an active workbook.


87. Ctrl + Alt + F9 : To force calculate all workbooks.


88. Ctrl + F3 : To open the name manager.


89. Ctrl + Shift + F3 : To create names from values in rows and columns.


90. Ctrl + Alt + + : To zoom in inside a workbook.


91. Ctrl + Alt + : To zoom out inside a workbook.


92. Alt + 1 : To turn on Autosave.


93. Alt + 2 : To save a workbook.


94. Alt + F + E : To export your workbook.


95. Alt + F + Z : To share your workbook.


96. Alt + F + C : To close and save your workbook.


97. Alt or F11 : To turn key tips on or off.


98. Alt + Y + W : To know what's new in Microsoft Excel.


99. F1: To open Microsoft Excel help.


100. Ctrl + F4: To close Microsoft Excel.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Comments

Post a Comment

Popular posts from this blog

A-Z List Of Windows CMD Commands

By -
Image
CMD Commands and their Function : A   addusers :  Used to add and list users in a CSV file.   admodcmd :  Used for bulk modifying contents in an active directory   arp : Address Resolution Protocol is used to map IP address to  the hardware address   assoc : Used to change associations for file extensions   associat: One step file association   at: Run a command at a specific time  atmadm: Display connection info of the ATM adapter   attrib: Used to change file attributes B  bcdboot: Used to create and repair a system partition   bcdedit:  Used to manage boot configuration data bitsadmin : Used to manage the Background Intelligent  Transfer  Service  bootcfg: Used to edit boot configuration in Windows   break: Enable/Disable break capability (CTRL+C) in CMD C  cacls: Used to change permissions of files   call: Used one batch program to call another  certreq: Used to reques...
Read more

Top 10 upcoming Google projects do you know...

By -
Image
Nowadays, Google is much more required in everyone’s life. It is like a synonym to our searches and wing to our devices. Google brought up a lot many useful devices in past and also has the plan to launch more of the user devices in the future. In addition to this, here are top 10 upcoming google projects which you must know. 1. Boston Dynamics The Boston dynamic project of Google (now been sold) had another definition of what Robots can do. It includes the following Robots. Handle: It has legs and wheels to provide high strength mobility. Spotmini : It’s a small package of big advancements. It can handle objects, climb stairs and can be operated for home and office purpose. Atlas: It is believed to be the most dynamic robot and it achieves whole-body human skills. Spot: It’s a four-legged robot with super mobility and human abilities. For better understanding click 2. Google fiber Google fiber provides absolute high internet speed that is used according to the location as a free inte...
Read more

25 Best Root Apps For Android (updated 2020)

By -
Image
                             Best Root Apps For Android (updated 2020) Android Root apps — a special set of applications to enhance and open new possibilities to your rooted Android devices. A rooted Android device allows us to easily tweak our phone to the next level by installing some special apps and also can do some hacking by installing some Android hacking apps. Moreover rooting helps you to change your stock ROM to some custom ROM with a stylish interface. That we will discuss later. With below mentioned top root apps for Android, you can do some heavy lifting with your phone. Because root apps help to improve android battery life, eradicate bloatware and provide more room for new apps, get your Android work better. And also keep in mind there are also some bad root apps that will do exactly the opposite. Best Root Apps For Android: 1. Greenify Greenify — one of the best root apps for Android to identify a...
Read more