Super Advance 239 Formula Excel For all folks

Super Advance 239 Formula Excel For Students & Professional

 

 

Developed by- Tech BrowSoft Solutions (T@BS)

 

Co –Founder &CEO

Er. Ravi Singh

 

Action (General)	Shortkey
1.      Open help	F1
2.      Undo last action	Ctrl+z
3.      Redo last action	Ctrl+y
4.      Copy selection	Ctrl+c
5.      Repeat last action	F4
6.      Cut selection	Ctrl+x
7.      Paste content from clipboard	Ctrl+v
8.      Display the paste special dialog box	Ctrl+alt+v
9.      Display nd  and replace with find tab selected	Ctrl+f
10.  Display nd and replace with replace tab selected	Ctrl+h
11.  Find Previous Match	Ctrl+shift+f4
12.  Insert embedded chart	Alt+f1
13.  Insert chart in new sheet	F11
14.  Toggle auto glter
15.  Active xlter	alt+down
16.  Create table	Ctrl+t
17.  Select table row	Shift+space
18.  Select table column	Ctrl+space
19.  Select table (when active cell is in table)	Ctrl+A
20.  Clear slicer ulter	Alt+c
21.  Run spellcheck	F7
22.  Open thesaurus	Shift+f7
23.  Open macro dialog box	Alt+f8
24.  Open VBA editor	Alt+f11
25.  Duplicate object	Ctrl+d
26.  Snap to grid (whilst dragging)	alt
27.  Hide or show object	Ctrl+6
28.  Open modify cell style dialog box	Alt+”
29.  Show right click menu	Shift+f10
30.  Display control menu	Alt+space
31.  Print	Ctrl+p
32.  Open print preview window	Ctrl+f2
33.  Set print area	Alt+prs
34.  Clear print area	Alt+prc
35.  Zoom in	Ctrl+mouse wheel up
36.  Zoom out	Ctrl+mouse wheel down
37.  Protect sheet	Alt+rps
38.  Create new work book	Ctrl+n
39.  Open workbook	Ctrl+o
40.  Save workbook	F12
41.  Save as	F12
42.  Go to next workbook	Ctrl+tab
43.  Go to previous workbook	Ctrl+shift+tab
44.  Minimize current workbook window	Ctrl+f9
45.  Maximize current workbook  window	Ctrl+f10
46.  Protect workbook	Alt+rpw
47.  Close current workbook	Ctrl+f4
48.  Close excel	Alt+f4
49.  Expand or collapse ribbon	Ctrl+f1
50.  Active access keys	alt
51.  Move through ribbon tabs and groups	Righ+left+upper+down
52.  Activate open selected control	Space or enter
53.  Conorm control change	enter
54.  Get help on selected control	F1
55.  Drag and copy	Ctrl+drag
56.  Drag and insert	Shift+drag
57.  Drag and insert copy	Ctrl+shift+drag
58.  Drag to worksheet	Alt+drag
59.  Drag to duplicate worksheet	Ctrl+drag
60.  Create pivot table	Alt+n+v
61.  Select entire pivot table	Ctrl+a
62.  Group pivot table items	Alt+shift+left
63.  Ungroup pivot table item	Alt+shift+right
64.  Hide (iter out) pivot table item	Ctrl+-
65.  Unhide (clear Iter on) pivot table item	Alt+hsc
66.  Insert pivot chart	Alt+nszc
67.  Move to next control	tab
68.  Move to previous control	Shift+tab
69.  Move to next tab	Ctrl+tab
70.  Move to previous tab	Ctrl+shift+tab
71.  Accept and apply	enter
72.  Check and uncheck box	space
73.  Cancel and close the dialog box	Esc
74.  Display insert dialog box	Ctrl++
75.  Insert selected number of columns	Ctrl++
76.  Insert selected no. of columns	Ctrl++
77.  Display delete dialog box	Ctrl+-
78.  Deleted selected no. of rows	Ctrl+-
79.  Delete selected no. of columns	Ctrl+-
80.  Delete contents of selected cells	delete
81.  Hide columns	Ctrl+0
82.  Hide rows	Ctrl+9
83.  Unhide rows	Ctrl+shift+9
84.  Group rows and column	Alt+shift+left
85.  Ungroup rows and columns	Alt+shift+right
86.  Open group dialog	Alt+shift+left
87.  Open group dialog box	Alt+shift
88.  Hide or show outline symbols	Ctrl+8
89.  Move left between  non-adjacement selections	Ctrl+alt+right
90.  Toggle( add to selection mode)	Shift+f8
91.  Exit (add to selection mode)	Esc
92.  Extend selection right	Shift+left
93.  Extend selection left	Shift+right
94.  Extend selection up	Shift+upper
95.  Extend selection down	Shift+down
96.  Extend the selection to the last cell on the right that 97.  Contains data, or to the text cell that contains data , or to the last column
98.  Extend the selection to the last cell on the left that contains data, or to the nest cell that contains data or to the rst column	Ctrl+shift
99.  Extend the selection to the cell up that contains data or to the next cell that contains data or to the rst row	Ctrl+shift+upper
100.                      Extend the selection to the last cell down that contains data or, to the next cell that contains data or to the last row	Ctrl+shift+down
101.                      Extend selection up one screen	Shift+pgup
102.                      Extend selection down one screen	Shift+pgdn
103.                      Extend selection right one screen	Alt+shift+pgdn
104.                      Extend selection left one screen	Alt+shift+pgup
105.                      Extend selection to start of row	Shift+home
106.                      Extend selection to last cell in worksheet	Ctrl+shift+find
107.                      Toggle (extend selection mode)	F8
108.                      Cancel (extend selection mode)
109.                      Begin entering a formula	= or +
110.                      Toggle absolute and relative reference (in cell edit mode)	F4
111.                      Open the insert function dialog box	Shift+f3
112.                      autosum	Shift+f3
113.                      autosum	Alt+=
114.                      Toggle display formula on and o	Ctrl+.
115.                      Insert function arguments	Ctrl+shift+A
116.                      Enter array formula	Ctrl+shift+enter
117.                      Calculate worksheets	F9
118.                      Calculate active worksheet	Shift +f9
119.                      Force calculate all worksheet	Ctrl+alt+f9
120.                      Evaluate part of a formula	F9
121.                      Expand or collapse the formula bar	Ctrl+shift+U
122.                      Display function arguments dialog box	Ctrl+A
123.                      Open name manager	Ctrl+f3
124.                      Create name from value in rows and columns	Ctrl+shift+f3
125.                      Paste name into formula	F3
126.                      Accept function with auto complete	tab
127.                      Apply general format	Ctrl+shift+~
128.                      Apply no format	Ctrl+shift+!
129.                      Apply time format	Ctrl+shift+@
130.                      Apply date format	Ctrl+shift+#
131.                      Apply currency format	Ctrl+shift+$
132.                      Apply percentage format	Ctrl+shift+%
133.                      Apply scientific uc format	Ctrl+shift+^
134.                      Open list o border styles from ribbon	Alt+H
135.                      Add border around selected cells	Ctrl+shift+&
136.                      Add and remove right border	Alt+hbr
137.                      Add and remove left border	Alt+hbl
138.                      Add and remove top border	Alt+hbr
139.                      Add and remove bottom border	Alt+hbr
140.                      Add all border to all cells in selection	Alt+ha
141.                      Remove borders	Ctrl+shift+-
142.                      Insert current date	Ctrl+;
143.                      Insert current time	Ctrl+shift+:
144.                      Fill down from cell above	Ctrl+D
145.                      Fill right from cell on left	Ctrl+R
146.                      Copy formula from cell above	Ctrl+”
147.                      Insert hyperlink	Ctrl+K
148.                      Display autocomplete list	Alt+down
149.                      Flash	Ctrl +’
150.                      Apply or remove bold	Ctrl+B
151.                      Apply or remove italics	Ctrl+I
152.                      Apply or remove under core	Ctrl+U
153.                      Apply or remove strikethrough	Ctrl+5
154.                      Align center	Alt+hac
155.                      Align left	Alt+har
156.                      Indent	Alt+h6
157.                      Remove indent	Alt+h5
158.                      Wrap text	Alt+hw
159.                      Align top	Alt+hat
160.                      Align middle	Alt+ham
161.                      Align bottom	Alt+hab
162.                      Increase font size one step	Alt+hfg
163.                      Decrease font size one step	Alt+hfk
164.                      Select cells with comments	Ctrl+shift+0
165.                      Select current region	Ctrl+a
166.                      Select direct precedents	Ctrl+[
167.                      Select all precedents	Ctrl+shift+{
168.                      Select direct dependents	Ctrl+]
169.                      Select all dependents	Ctrl+shift+}
170.                      Select visible cells only	Alt+;
171.                      Edit the active cell	F2
172.                      Insert or edit comments	Shift+f2
173.                      Delete comment	Shift+f10
174.                      Cancel editing	Esc
175.                      Select one character right	Shift+left
176.                      Select one character left	Shift+right
177.                      Move one word right	Ctrl+left
178.                      Move one word left	Ctrl+right
179.                      Select one word right	Ctrl+shift

 

Note

Simply guys, 239 all formula for excel. But our database is not available 239 excel commands

.