Step-by-Step Guide: Copy and Paste Data into Specific Cells
Amber Schmitz
|
151 steps
|
14 minutes
1
Click "A5"
2
Click "A6"
3
Type "abc"
4
Click "A6"
5
Type "SUPP CODEDATE INVOICES"
6
Click "B5"
7
Click "C4"
8
Click "B1"
9
Click "Select All"
10
Click "B"
11
Click "C"
12
Press [[alt]] + [[tab]]
13
Press [[alt]] + [[tab]]
14
Press [[alt]] + [[tab]]
15
Click "B3"
16
Press [[ctrl]] + [[C]]
17
Press [[alt]] + [[tab]]
18
Click "B"
19
Click "B1"
20
Press [[ctrl]] + [[V]]
21
Click "D"
22
Click "D"
23
Click "1"
24
Click "8"
25
Click "E4"
26
Click "C2"
27
Click "E2"
28
Click "F2"
29
Click "E2"
30
Click "E3"
31
Click "E6"
32
Click "F2"
33
Press [[alt]] + [[tab]]
34
Press [[alt]] + [[tab]]
35
Press [[alt]] + [[tab]]
36
Press [[alt]] + [[tab]]
37
Click "7."
38
Press [[alt]] + [[tab]]
39
Press [[alt]] + [[tab]]
40
Press [[alt]] + [[tab]]
41
Click "B6"
42
Click "C6"
43
Type "CDEF"
44
Click "6"
45
Click "6"
46
Click "Data"
47
Click "Filter"
48
Click "D9"
49
Click "No filter applied dropdown button"
50
Click "Cancel"
51
Click "D6"
52
Click "Home"
53
Click "Delete Cells..."
54
Click "E5"
55
Click "Select All"
56
Click "D6"
57
Type "DE"
58
Click "Position"
59
Click "Find & Select"
60
Click "Go To Special..."
61
Click "Blanks"
62
Click "A"
63
Click "F13"
64
Click "A"
65
Click "Find & Select"
66
Click "Go To Special..."
67
Click "Blanks"
68
Click "OK"
69
Click "B5"
70
Click "A6"
71
Click "Page up"
72
Click "A71323"
73
Click "A1799"
74
Click "Find & Select"
75
Click here:
76
Click "Blanks"
77
Click "OK"
78
Click "Delete Cells..."
79
Click "EDI & User Count Doc.docx - Word"
80
Click "12."
81
Click "12."
82
Press [[alt]] + [[tab]]
83
Click "A8"
84
Click "No filter applied dropdown button"
85
Click "(Select All)"
86
Click "(Select All)"
87
Click "DATE INVOICES:"
88
Click "OK"
89
Click "7"
90
Click "Delete Cells..."
91
Click "Filter applied dropdown button"
92
Click "E383"
93
Click "376"
94
Click here:
95
Click "B377"
96
Click "Filter applied dropdown button"
97
Click "Clear Filter From "DATE INVOICES""
98
Click "B11"
99
Click "464"
100
Click "B369"
101
Click "Undo"
102
Click "Undo"
103
Click "B11"
104
Click "B6"
105
Click "Filter applied dropdown button"
106
Click here:
107
Click "No filter applied dropdown button"
108
Click "(Select All)"
109
Click "23:01:37 NDC"
110
Click "Position"
111
Click "OK"
112
Click "40"
113
Click "Delete Cells..."
114
Click "Filter applied dropdown button"
115
Click "Sheet View"
116
Click "B6"
117
Click "A8"
118
Click "No filter applied dropdown button"
119
Click here:
120
Click "Page up"
121
Click "Cancel"
122
Click "A10"
123
Click "B7"
124
Click "MATCH"
125
Press [[alt]] + [[tab]]
126
Press [[alt]] + [[tab]]
127
Click "A4"
128
Press [[ctrl]] + [[C]]
129
Press [[alt]] + [[tab]]
130
Click "ALL_Invoice Edited"
131
Click "Sheet1"
132
Click "A4"
133
Click "A5"
134
Press [[ctrl]] + [[V]]
135
Press [[ctrl]] + [[Z]]
136
Click "A6"
137
Press [[ctrl]] + [[V]]
138
Press [[alt]] + [[tab]]
139
Click "C4"
140
Click "D4"
141
Click "G4"
142
Click "Kofax Touch Rate"
143
Click "MATCH"
144
Click "B7"
145
Click "C7"
146
Click "D7"
147
Click "ALL_Invoice Edited"
148
Click "E3"
149
Click "A6"
150
Click "5"
151
Click here:
