How to Save and Format a Spreadsheet Report
Amber Schmitz
|
149 steps
|
9 minutes
1
Click "Name"
2
Click "Save As"
3
Type "9.19.23 [[enter]]"
4
Click "Name"
5
Click "Generate INVERR10 Report"
6
Click "Save"
7
Click here:
8
Click "Don't Save"
9
Click "Name"
10
Click "C"
11
Click "Comma Style"
12
Click "F"
13
Click "Number"
14
Click "Format Cell Number"
15
Type "5 [[enter]]"
16
Click "J"
17
Click "Insert"
18
Click "INVERR10_20-09-2023 - Excel"
19
Click "J1"
20
Click "K1"
21
Click "Copy"
22
Click "J1"
23
Click "Paste"
24
Click "I"
25
Click "Close"
26
Click "No filter applied dropdown button"
27
Click here:
28
Click "No filter applied dropdown button"
29
Click "(Blanks)"
30
Click "OK"
31
Click "G2"
32
Click "More Options"
33
Click "More Colors..."
34
Click "Colors:"
35
Click "D10"
36
Click "A2"
37
Click "More Options"
38
Click "Fill Color"
39
Click "No filter applied dropdown button"
40
Click "-"
41
Click "OK"
42
Click "D266"
43
Click "More Options"
44
Click "Theme Colors"
45
Click here:
46
Click "Bold"
47
Click "Sort & Filter"
48
Click "Clear"
49
Click "No filter applied dropdown button"
50
Click "(Select All)"
51
Click "OK"
52
Click "No filter applied dropdown button"
53
Click "Page up"
54
Click "(Blanks)"
55
Click "OK"
56
Click "F3"
57
Click "More Options"
58
Click "Fill Color"
59
Click "Sort & Filter"
60
Click "Clear"
61
Click "I2"
62
Type "=vlo"
63
Double-click here:
64
Click "A2"
65
Type ","
66
Click "Select All"
67
Type ",9,false) [[enter]]"
68
Click "J3"
69
Click "Value Not Available Error"
70
Click "Formula Bar"
71
Type " [[delete]] a"
72
Click "Formula Bar"
73
Type " [[delete]] 10 [[enter]]"
74
Click "Value Not Available Error"
75
Click "Formula Bar"
76
Type " [[delete]] a"
77
Click "Formula Bar"
78
Type " [[delete]] 11 [[enter]]"
79
Click "I2"
80
Click "K2"
81
Click "Position"
82
Click "Position"
83
Click "I"
84
Click "K"
85
Click "Copy"
86
Click "J"
87
Click "Values"
88
Click "No filter applied dropdown button"
89
Click "(Select All)"
90
Click "0"
91
Click "Page down"
92
Click "#N/A"
93
Click "OK"
94
Click "I2"
95
Click "Filter applied dropdown button"
96
Click "Clear Filter From "AP COMMENTS""
97
Click "No filter applied dropdown button"
98
Click "(Select All)"
99
Click "0"
100
Click "Position"
101
Click "#N/A"
102
Click "OK"
103
Click "J2"
104
Click "Filter applied dropdown button"
105
Click "Clear Filter From "LINE NUMBER""
106
Click "No filter applied dropdown button"
107
Click "(Select All)"
108
Click "0"
109
Click "Page down"
110
Click "#N/A"
111
Click "OK"
112
Click "K2"
113
Click "Filter applied dropdown button"
114
Click "Clear Filter From "PART NUMBER""
115
Click "TERMS"
116
Click "TERMS"
117
Click "TERMS"
118
Click "PIVOT AMOUNT"
119
Click "Close"
120
Click "INVERR10_20-09-2023.xlsx"
121
Click "(move to end)"
122
Click "Create a copy"
123
Click here:
124
Click "BOT"
125
Click "Position"
126
Click "R1"
127
Click "V2"
128
Click "Copy"
129
Click "Sheet1"
130
Click "Position"
131
Click "Column right"
132
Click "R1"
133
Click "Paste"
134
Click "Column right"
135
Click "V1"
136
Type "9/20 [[enter]]"
137
Click "R2"
138
Click "Formula Bar"
139
Type
140
Click "Formula Bar"
141
Type " [[enter]]"
142
Click "Ribbon"
143
Click "Position"
144
Click "No filter applied dropdown button"
145
Click "7500"
146
Click "08-23-0908"
147
Click "(Blanks)"
148
Click "OK"
149
Click "S12"
