Excel all shorcut key | Usefull shortcut key | Gnb classes For CPCT, CCC, NTPC, SSC, Bank Job

 

Excel All Shortcuts Keys

  

1.     Ctrl + S :- Save a workbook

2.     Ctrl + 0 :- Hide the selected columns

3.     Ctrl + 1 :- Open the Format Cells dialog box

4.     Ctrl + 5 :- Apply or remove strike through

5.     Ctrl + Shift + $ :- Apply currency format

6.     Ctrl + Shift + % :- Apply percent format

7.     Ctrl + Tab :- Switch between open workbooks

8.     Ctrl +  P :- Print / Print Preview

9.     Ctrl + Shift + # :- Apply Date format

10.                         Ctrl + Shift + @ :- Apply Time format

11.                         Ctrl + Shift + ! :- Apply Number format

12.                         Ctrl + Shift +  ~ :- Apply General format

13.                         Ctrl +  '  :- Copy Above Content to Fill below

14.                         Ctrl + X :- Cut contents of a cell, selected data, or selected cell range

15.                         Ctrl + C or Ctrl + Insert :- Copy contents of a cell, selected data, or selected cell range

16.                         Ctrl + V or Shift + Insert :- Paste contents of a cell, selected data, or selected cell range

17.                         Ctrl + Alt + V :- Open the Paste Special dialog box

18.                         Ctrl  +  D = Fill Down

19.                         Ctrl  +  R - Fill Right

20.                         Ctrl  +   +  - Insert Column / Row

21.                         Ctrl  +  - = Delete Row / Column

22.                         Ctrl + Space :- Select the entire column

23.                         Ctrl + Shift + Space :- Select the entire worksheet

24.                         Ctrl + Shift + & :- Apply outline border

25.                         Ctrl + Shift + _ (Underscore) :- Remove outline border

26.                         Ctrl + 9 :- Hide the selected rows

27.                         Ctrl  +  F9 - Minimize / Alt  +  Tab - Maximize / Switch

28.                         Ctrl  +  F11 - Insert Macro Name Sheet

29.                         Ctrl  +  F12 = Open Dialog box

30.                         Ctrl  +  Shift  +  F1 - Hide Tab and Ribbon

31.                         Ctrl  +  ; - Insert Date

32.                         CTRL  +  ~ = Show and Hide All formulas from sheet

33.                         Ctrl  +  Shift  +  ; - Insert Time

34.                         Ctrl  +  H – Replace

35.                         Ctrl  +  K – Hyperlink

36.                         Ctrl  +  Shift  +  9  :- Unhide Rows

37.                         Ctrl + F1 :- Show or hide the ribbon

38.                         Ctrl + Home :- Move to the beginning of a worksheet

39.                         Ctrl + End :- Go to the most bottom right used cell

40.                         Ctrl + Shift + U :- Expand or collapse the formula bar

41.                        Ctrl + F9 :- Minimize the workbook window

42.                         Ctrl + Z :- Undo an action

43.                         Ctrl + Y :- Redo an action

44.                         Ctrl + N :- Create a new workbook

45.                         Ctrl + O :- Open an existing workbook

46.                         Ctrl  +  F10 = Restore Window or Alt  +  Space  +  R

47.                         Ctrl  +  F3 = Name Manager

48.                         Ctrl  +  Shift  +  F3 - Create Names from Selection

49.                         Ctrl + Left/Right Arrow :- Move to the farthest cell left or right in the row

50.                         Ctrl + Page Up/Down :- Move to the previous or next worksheet

51.                         Ctrl + W / CTRL  +  F4 :- Close a workbook (Alt  +  Space  +  C)  

52.                         Ctrl + Up/Down Arrow :- Move to the top or bottom cell in the column

53.                         Ctrl + F :- Search in a spreadsheet, or use Find and Replace
---------------------------------------------------------------------------------------------------

1.     Alt  +  H  +  W - Wrap Text

2.     Alt  +  A  +  T - Apply and Remove Filter

3.     ALT  +  N  +  V - PIVOT TABLE

4.     ALT  +  =  :- Auto Sum

5.     ALT  +  H  + M  +  C - MERGE AND CENTER

6.     Alt  +  A  +  Q - Advance Filter

7.     Alt  +  H  +  O  +  I - Auto-fit Column Width

8.     Alt  +  H  +  E  +  F - Clear Format

9.     Alt  +  I  +  R - Insert Row

10.                        Alt  +  I  +  C - Insert Colum

11.                        Alt + H + B :- Add a border

12.                        Alt + F :- Open the File tab menu

13.                        Alt + H :- Go to the Home tab

14.                        Alt + F8 :- Create, run, edit, or delete a macro

15.                        Alt + F11 :- Open the Microsoft Visual Basic For Applications Editor

16.                        Alt  +  V  +  Z  :- Zoom in / Zoom Out

17.                        Alt or F10 :- Turn key tips on or off

18.                        Alt + F1 :- Create an embedded bar chart based on select data (same sheet)

19.                        Alt + Enter :- Insert a hard return within a cell (while editing a cell)

20.                        Alt + H + H :- Select a fill color

21.                        Alt + Page Up/Down :- Move one screen to the right or left in a worksheet

22.                        Alt  +  Space  +  X - Maximize or Ctrl  +  F10 - Restore

23.                        Alt  +  V  +  U - Full Screen

 -----------------------------------------------------------------------------------------------------

1.      F1 :- Open the Help pane

2.      F2 :- Edit a cell

3.      F3 :- Paste a cell name (if cells are named in the worksheet)

4.      F5 or CTRL +  G :- Go to any cell by pressing F5 and typing the cell  coordinate or cell name.

5.      F7 :- Check spelling

6.      F8  :- Extend Selection

7.      F9 :- Calculate all worksheets in all open workbooks

8.      F11 :- Create a bar chart based on selected data (on a separate sheet)

9.      F12 :- Open the Save As dialog box

10.                         Shift + F3 :- Insert a function

11.                         Tab = Go to the Next cell & Shift + Tab :- Go to the previous cell

12.                         Shift + F2 :- Add or edit a cell comment

13.                         Esc :- Cancel an entry in a cell or the formula bar

14.                         Enter  :- Complete the Formula / Paste Content if already copied

15.                         EXCEL Ctrl  +  E - Flash Fill

16.                         Shift + Left/Right Arrow :- Extend the cell selection to the left or right

17.                         Shift + Space :- Select the entire row

18.                         Home :- Go to the leftmost cell in the current row  

19.                         Page Up/Down :- Move one screen up or down in a worksheet

20.                         Shift + F11 :- Insert a new worksheet

Excel all shorcut key 

 Usefull shortcut key 

Gnb classes

excel notes 

Excel Formula

shortcut keys  For CPCT, CCC, NTPC, SSC, Bank Job etc