Guide to Copying and Pasting Data in Excel
Amber Schmitz
|
186 steps
|
6 minutes
1
Press [[alt]] + [[tab]]
2
Press [[alt]] + [[tab]]
3
Click "I10"
4
Click "H11"
5
Press [[ctrl]] + [[C]]
6
Press [[alt]] + [[tab]]
7
Press [[alt]] + [[tab]]
8
Press [[alt]] + [[tab]]
9
Click "H15"
10
Press [[alt]] + [[tab]]
11
Press [[alt]] + [[tab]]
12
Press [[alt]] + [[tab]]
13
Click "H15"
14
Click "Values"
15
Click "More Options"
16
Click "Fill Color"
17
Click "Wrap Text"
18
Click "H"
19
Click "I"
20
Click "15"
21
Click "17"
22
Click "L9"
23
Click here:
24
Click "L"
25
Click "L12"
26
Click "P"
27
Click "M21"
28
Click "ALL_Invoices_07_28_2023"
29
Click "Rename"
30
Click "E15"
31
Press [[alt]] + [[tab]]
32
Click "ALL_Invoice Raw"
33
Click "Select All"
34
Click "I4"
35
Click "D6"
36
Press [[alt]] + [[tab]]
37
Click "Select All"
38
Press [[ctrl]] + [[C]]
39
Press [[alt]] + [[tab]]
40
Click "A1"
41
Press [[ctrl]] + [[V]]
42
Click "Select All"
43
Click "A"
44
Click "Home"
45
Press [[alt]] + [[tab]]
46
Click "D11"
47
Click "Close"
48
Click "Don't Save"
49
Click "Yes"
50
Click "E15"
51
Click "Select All"
52
Click "Font"
53
Type "CALIBRI L"
54
Click "‪07 JULY23.xlsx‬ - No Label"
55
Type " [[enter]]"
56
Click "07 JULY23.xlsx - Excel"
57
Click "G7"
58
Click "ALL_Invoice Edited"
59
Click "A3"
60
Click "B3"
61
Click "B9"
62
Click "ALL_Invoice Raw"
63
Click "07 JULY23"
64
Click "SPEND"
65
Click "ALL_Invoice Raw"
66
Click "Select All"
67
Press [[ctrl]] + [[C]]
68
Click "Sheet1"
69
Press [[ctrl]] + [[V]]
70
Click "I10"
71
Click "1"
72
Click "H11"
73
Press [[ctrl]] + [[C]]
74
Click "MATCH"
75
Press [[alt]] + [[tab]]
76
Press [[alt]] + [[tab]]
77
Click "MATCH"
78
Click "ALL_Invoice Raw"
79
Click "H11"
80
Press [[ctrl]] + [[C]]
81
Click "MATCH"
82
Click "B5"
83
Click "Values"
84
Click "A1"
85
Type "7/28/23 [[enter]]"
86
Click "Sheet1"
87
Click "J11"
88
Press [[ctrl]] + [[C]]
89
Click "SPEND"
90
Click "MATCH"
91
Click "C5"
92
Click "Values"
93
Press [[alt]] + [[tab]]
94
Press [[alt]] + [[tab]]
95
Press [[alt]] + [[tab]]
96
Press [[alt]] + [[tab]]
97
Press [[alt]] + [[tab]]
98
Press [[alt]] + [[tab]]
99
Press [[alt]] + [[tab]]
100
Press [[alt]] + [[tab]]
101
Press [[alt]] + [[tab]]
102
Press [[alt]] + [[tab]]
103
Press [[alt]] + [[tab]]
104
Click "Sheet1"
105
Click "K12"
106
Click "K11"
107
Press [[ctrl]] + [[C]]
108
Click "MATCH"
109
Click "D5"
110
Click "Values"
111
Click "A8"
112
Click "A9"
113
Click "A7"
114
Click "A8"
115
Press [[alt]] + [[tab]]
116
Press [[alt]] + [[tab]]
117
Press [[alt]] + [[tab]]
118
Press [[alt]] + [[tab]]
119
Click "Name"
120
Click "MATCH"
121
Click "ALL_Invoice Edited"
122
Press [[alt]] + [[tab]]
123
Click "Sheet1"
124
Click "1"
125
Click "Delete Cells..."
126
Click "G1"
127
Press [[alt]] + [[tab]]
128
Click "A32"
129
Click "B3"
130
Click "ALL_Invoice Edited"
131
Press [[alt]] + [[tab]]
132
Press [[alt]] + [[tab]]
133
Click "B3"
134
Press [[ctrl]] + [[C]]
135
Press [[alt]] + [[tab]]
136
Click "B1"
137
Click here:
138
Click "More Options"
139
Click "Fill Color"
140
Click "More Options"
141
Click "Fill Color"
142
Click "B"
143
Click "1"
144
Click "Select All"
145
Click "B"
146
Click "D8"
147
Click "B1"
148
Click "C2"
149
Click here:
150
Click "H1"
151
Click "1"
152
Click "Delete Cells..."
153
Click "C3"
154
Click "Position"
155
Press [[alt]] + [[tab]]
156
Press [[alt]] + [[tab]]
157
Press [[alt]] + [[tab]]
158
Press [[alt]] + [[tab]]
159
Press [[alt]] + [[tab]]
160
Press [[alt]] + [[tab]]
161
Press [[alt]] + [[tab]]
162
Press [[alt]] + [[tab]]
163
Click "A"
164
Press [[alt]] + [[tab]]
165
Press [[alt]] + [[tab]]
166
Click "E"
167
Press [[alt]] + [[tab]]
168
Press [[alt]] + [[tab]]
169
Click "G"
170
Press [[alt]] + [[tab]]
171
Press [[alt]] + [[tab]]
172
Click "Column right"
173
Click "M"
174
Click "L"
175
Press [[alt]] + [[tab]]
176
Press [[alt]] + [[tab]]
177
Click "Delete Cells..."
178
Click "G42"
179
Click "Position"
180
Click "A47"
181
Click "5"
182
Click "6"
183
Click "Delete Cells..."
184
Click "D5"
185
Press [[ctrl]] + [[z]]
186
Click "3"
