MS Excel short cut Keys

  1. Ctrl+N - Open a new workbook quickly.
  2. Ctrl+O - Opens a previously saved document.
  3. Ctrl+W  - Closes the active window, but does not Exit Excel.
  4. Ctrl+S - Saves the active document with its current file name, location and format.
  5. Ctrl+P - Prints the active file, also gives the opportunity to change print options.
  6. Alt+F4 - Closes Microsoft Excel.
  7. Ctrl+Z - Undo the last action. This selection can be repeated several times.
  8. Ctrl+Y - After an action has been undone, it can be reinstated in the document.
  9. Ctrl+X - Removes the selection from the active document and places it on the clipboard.
  10. Ctrl+C - Copies the selection to the clipboard.
  11. Ctrl+V- Inserts the contents of the clipboard at the insertion point (cursor) or whatever is selected.
  12. Ctrl+Shift+F3 - Create names form row and column labels.
  13. Ctrl+ ~   -  Displays all formulas in a worksheet, repeat to hide.
  14. Ctrl+ Shift+F6 - Move to the previous workbook or window.
  15. Ctrl+ Shift+Tab - Move to the previous workbook or window.
  16. Ctrl+ Shift+F12 - Prints the active file, also gives the opportunity to change print options..
  17. Enter - Complete a cell entry and move down in the selection.
  18. Esc - Cancel a cell entry.
  19.  Tab - Move between unlocked cells on a protected worksheet.
  20. Ctrl+; - Enter the date
  21. Ctrl+A Selects all on the active worksheet.
  22. Ctrl+F - Searches for specified text in the active document.
  23. Ctrl+B - Formats selected text; make text bold, or remove bold formatting.
  24. Ctrl+I - Formats selected text; make text italic or remove italic.
  25. Ctrl+U - Formats selected text; make text underlined or remove underline.
  26. Ctrl+Page Down-  Select the next sheet in the workbook. 
  27. Ctrl+ R -  Fill to the right.
  28. Alt+= - Insert the Auto sum formula.
  29. Ctrl+1 - Display the Format cell dialog box.
  30. Ctrl+7 - Show, or hide the Standard Toolbar.
  31. Ctrl+f+F6-  Move to the next workbook or window. 
  32. Ctrl+Tab-  Move to the next workbook or window. 
  33.  Shift+F11-  Insert a new worksheet.
  34. Alt+F1 - Create a chart that uses the current range.
  35. F11- Create a chart that uses the current range.
  36. Ctrl+k- Insert a hyperlink.
  37. Enter- In a cell with hyperlink, this activates the hyperlink.
  38. Ctrl+shift+%- Apply the percentage format.
  39. Ctrl+9- Hide rows.
  40. Ctrl+shift+( - unhide rows.
  41.  Shift+ Enter- Complete a cell entry and move up in the selection.
  42. Ctrl+Page up- Select the previous sheet in the workbook.
  43. Shift + Tab- Complete a cell entry and move to the left in the selection.
  44. Alt+Enter- Start a new line in the same cell.
  45. = - Start a formula.
  46. Alt+Shift+F1 - Insert a new worksheet. 
  47. Shift+Spacebar - Slect the entire row.
  48. Ctrl+ Spacebar -  Select the entire column.
  49. Ctrl+: - Enter the time.
  50.  Ctrl+ D - Fill down
  51. Ctrl + Shift+ &  - Apply the outline border.
  52. Ctrl + Shift+ _   - Remove the outline border.
  53.  Ctrl+ shift + $ -  Apply the currency format.
  54. Ctrl+ 0 - Hide columns.
  55. Ctrl+ Shift+ ) - Unhide column.
Let's talk more about Some Important things you need to understand  before you get into the Course:

1. Range

    
      What is Range?
Answer:- A collection of two or more cells. 
               So, it can be said as: " The collection of more than 1 cell is called Range."


2. Selecting Range

         
          How to select Range?   &   How to select an Individual range?
Answer:- 
A. To select range only, you need to click left click on the cell & drag you mouse towards the desired cells.

B. To select individual range, we need to click the left mouse         button on the desired cell & then press CTRL key on the key board & then start clicking the cell you want.

C. For all the cells either in the Column or Rows, click on the header of any column or rows.

Note:- To see this in action, please see the video from the link given below:

  https://youtu.be/TpjpPzqOKjY".


3. Filling Range ( Dragging technique) 

       A.      Enter the value you want in the cell and clicking on the lower right corner of the cell, drag it to the cells you want.

Example:-

                I enter the value 1 in the A1 and then clicking on the lower right corner of that cell, I drag it to the cell A5 and we see the copies of 1s up to cell A5. It means this way we get copies of any values (Numbers) or any Texts.  if Written "Sita", the copies of Sitas we see. But the text should not be series-like.  Series-like texts are the followings : 

January, Feburary..................................

Sunday, Monday.....................................

Sun, Mon ...............................................

Jan, Feb..................................................

etc.

 For these types of series-like words , you should drag only your mouse clicking the right lower corner of the targeted cell  towards your desired location. (either in right side or downside) and then, 

you see  the series of "January, February, March, April, May ......." 

                                             or,
                                   "Sunday, Monday, Tuesday.........................................."

If you press CTRL key in the keyboard  & clicking the cell A1, (if written 1 in the Cell A1), after you  drag it for the numbers (Value), there you can see the series of 1, 2,3,4,5.  upto Cell A5. (Not 1s).

But, if you make the difference between cells, then no need to press control key, just drag your mouse.

Examples:-

If 2, 4, then there will be series of 2, 4, and 6,8,10..... (Depends on the how much difference is there).
If 5, 10, then there will be series of 5, 10,15,20,25....... because the difference is 5.

 Note:  For more details, please see the video in youtube from the link given below:

 "https://youtu.be/Oz22KMnAqwE"


4. Move Range


How to move Range?

Answer: - Just select the range and move it to your desired location clicking & dragging the left mouse click.
Or ,
Just copy it after selecting, and then paste it on the desired location.
For more details, see in youtube form the given link below

"https://youtu.be/wemGYSHGdAQ"


5. Insert Row & Column ( Between Values or Texts)

To insert Row:- Click on the row header.  Then, right click  &  choose "Insert".

To Insert Column:- Click on the column header.  Then, Right click & choose "Insert".

For more details, see in youtube form the given link below

"https://youtu.be/Vp4GPhgHb7Y"