How To Extract Formulas From Excel At Once

Sometimes you may need to convert formula to text string in Excel, such as =A1+B1, follow the below mentioned steps for extracting the formulas from Excel at once.

Example

For Example, we need to show the Column C with original formulas but not their calculated results in Column D, see the following screen shot.

Steps

1. select Column C.
2. Under the Data menu tab, in the Data Tools group, click the Text to Columns button.
3. In Convert Text to Columns Wizard window, do the following:
   1. In Convert Text to Columns Wizard - step 1 of 3 window, click Next.
   2. In Convert Text to Columns Wizard - step 2 of 3 window, click Next.
   3. In Convert Text to Columns Wizard - step 3 of 3 window, under Column data format, choose Text, in Destination box, enter a cell reference: D1, or click Collapse Button  to temporarily hide the dialog box, select cell D1 on the worksheet, and then press Expand Button .
   4. click Finish.

Final Results

Video

Quickly Copy Values Without Formulas in Excel

You can quickly copy values without formulas in Excel. 

The example may be easier to understand if you copy A1:C5 to a blank worksheet.

	A	B	C
1	Data	Formula	Result
2	3	=A2-1
3	4	=A3-1
4	5	=A4-1
5	6	=A5-1

Step 1: Select B2
Step 2: Press and hold CTRL then Select B3:B5
Step 3: Press CTRL C
Step 4: Select a blank cell (eg. C2) and Press CTRL V to paste the values.

Excel VBA Editor Keyboard Shortcuts

The complete list of Excel VBA Editor (VBE) keyboard shortcuts are for U.S. keyboard layout and Windows Operation system. 

#	Action	Shortcut
1	Help	F1
2	Object Browser	F2
3	Find	F3
4	Properies Window	F4
5	Run	F5
6	Switch Split Windows	F6
7	Goto Window Of Object	F7
8	Step	F8
9	Breakpoint	F9
10	Activate Menu Bar	F10
11	Toggle Insert Mode	Insert
12	Delete	Delete
13	Beginning Of Line	Home
14	End Of Line	End
15	Page Up	PgUp
16	Page Down	PgDn
17	Left	←
18	Right	→
19	Up	↑
20	Down	↓
21	Indent	Tab
22	New Line	Enter
23	Delete Prev Char	BackSpace
24	Procedure Definition	Shift F2
25	Find Prev	Shift F3
26	Find Next	Shift F4
27	Procedure Step	Shift F8
28	Quick Watch	Shift F9
29	Show Right Click Menu	Shift F10
30	Paste	Shift Insert
31	Select To Start Of Line	Shift Home
32	Select To End Of Line	Shift End
33	Select To Top Of Module	Shift PgUp
34	Select To End Of Module	Shift PgDn
35	Extend Selection Left 1 Char	Shift ←
36	Extend Selection Right 1 Char	Shift →
37	Extend Selection Up	Shift ↑
38	Extend Selection Down	Shift ↓
39	Un-indent	Shift Tab
40	Focus To Object Box	Ctrl F2
41	Close Window	Ctrl F4
42	Run To Cursor	Ctrl F8
43	Activate Menu Bar	Ctrl F10
44	Select All Text	Ctrl B
45	Copy	Ctrl C
46	Export Module	Ctrl E
47	Find	Ctrl F
48	Immediate Window	Ctrl G
49	Replace	Ctrl H
50	Turn On Quick Info	Ctrl I
51	List Members	Ctrl J
52	Show Call Stack	Ctrl L
53	Import File	Ctrl M
54	New Line	Ctrl N
55	Print	Ctrl P
56	Project Window	Ctrl R
57	Save	Ctrl S
58	Show Available Components	Ctrl T
59	Paste	Ctrl V
60	Cut	Ctrl X
61	Cut Entire Line	Ctrl Y
62	Undo	Ctrl Z
63	Copy	Ctrl Insert
64	Delete To End Of Word	Ctrl Delete
65	Top Of Module	Ctrl Home
66	End Of Module	Ctrl End
67	Top Of Current Procedure	Ctrl Page Up
68	End Of Current Procedure	Ctrl Page Down
69	Left Word	Ctrl Left Arrow
70	Right Word	Ctrl Right Arrow
71	Previous Procedure	Ctrl Up Arrow
72	Next Procedure	Ctrl Down Arrow
73	Turn On Complete Word	Ctrl Space Bar
74	Cycle Windows	Ctrl Tab
75	Delete To Start Of Word	Ctrl BackSpace
76	Close VBE	Alt F4
77	Run Error Handler	Alt F5
78	Switch Between Last 2 Windows	Alt F6
79	Step Error Handler	Alt F7
80	Return To Application	Alt F11
81	Add-Ins Menu	Alt A
82	Debug Menu	Alt D
83	Edit Menu	Alt E
84	File Menu	Alt F
85	Help Menu	Alt H
86	Insert Menu	Alt J
87	Format Menu	Alt O
88	Close & Return	Alt Q
89	Run Menu	Alt R
90	Tools Menu	Alt T
91	View Menu	Alt V
92	Window Menu	Alt W
93	System Menu	Alt Space Bar
94	Cycle Applications	Alt Tab
95	Undo	Alt BackSpace
96	Previous Position	Ctrl Shift F2
97	Clear All Breakpoints	Ctrl Shift F9
98	Turn On Param Info	Ctrl Shift I
99	Turn On List Properties	Ctrl Shift J