TheMSsForum.com: The Microsoft Software Forum
TheMSsForum.com
The MSS Forum
‹
Archive Home
‹
Excel Misc Archive
‹
Page 55
Archive
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
view full version:
back to formated view
18901:
Sorting
18902:
Strange Excel error
18903:
About this website - When I click on things nothing happens.
18904:
Data Validation to restrict blank value in adjacent field
18905:
Excel 2007 crash when trying to add macro button to QAT
18906:
Worksheet protection question
18907:
How do I reduce an Excel with Pivot Tables file size?
18908:
Referencing a tab NUMBER rather than the tab NAME in a formula
18909:
Filter or sort a macro result
18910:
Shortcut to change view so that column widths are all wide enough to show all data?
18911:
How to deal with a growing dataset...
18912:
Chart Influencing Data
18913:
Excel Printing
18914:
VLOOKUP using two worksheets?
18915:
Consolidating Text Info
18916:
Populating a second worksheet
18917:
Excel formula / Macro ?
18918:
Row Shading
18919:
Aborting save
18920:
How do I delete items out of my "recent documents" list?
18921:
Audio warning when cells change
18922:
Saving in Compatibility mode
18923:
Multiple info on one cell needs to be seperated????
18924:
How can I split contents of cell with no delimiter
18925:
Assigning a Value
18926:
Excel Shared Workbooks
18927:
Excel 2002: Why the first row of the subtotal table always not add
18928:
Sorting values generated by a formula...
18929:
when starting excel 2007 i get a preview page
18930:
Cannot Open Pivot Table Source
18931:
TWO DIFFERENT FILL COLOURs ON MENU BAR
18932:
saved over wanted file need to find it
18933:
Acending descending filter screwed my spreadsheet...
18934:
Using wildcards in Array formulae
18935:
#Div/0!
18936:
2nd split
18937:
Customized Find/Replace to Update Numbers Using Specified Criteria
18938:
Why doesn't Excel 2007 record charting and office art macro code?
18939:
Macro - protection with filter
18940:
SUMIF and SUMPRODUCT with INDIRECT formula problem
18941:
Attach Excel File to Word
18942:
Multiple auto sum functions on status bar
18943:
=?Utf-8?Q?=C3=87OK_SATIRLI_B=C4=B0R_EXCELL_TABLOSUND?=
18944:
SUMIF
18945:
How can i create a form linked to a database
18946:
Excel 2007 to pdf - hyperlink from excel does not work
18947:
Cells
18948:
Sharing WB & saving changes question
18949:
Weird conditional formatting bug
18950:
Validation & Combo
18951:
Formula Problem
18952:
How do I not print the title on the last page of an excel doc?
18953:
searching for similar text
18954:
Cells to show zero
18955:
Cells to show zero
18956:
reconciliation in different currencies
18957:
Formula problem
18958:
List of dates for month from start date
18959:
Autofilter COUNTA formula not taking into account hidden cells
18960:
Returning Text
18961:
Pivot Table Counta formula and sum for unhidden cells only
18962:
Excel 2007 access to SQL2005 Analysis Server under Vista
18963:
Default Print Quality in Excel 2007
18964:
Formula problem
18965:
how to get a macro to work
18966:
Auto fil in
18967:
Formula for adding minutes to a time cell
18968:
Finding Latest Variable
18969:
Multiple Conditional Formatting
18970:
Formula for average of a top 12 numbers in a column of 24 total nu
18971:
How to valid the date with given condition?
18972:
display to thousand
18973:
Auto Count for Auto Filter Doesn't Function under certain circumst
18974:
Seperate digits of a number by columns and back again
18975:
Send as Attachment - Change Default Mailbox?
18976:
Does anyone know the code to put a number in the right header...
18977:
Template will not automatically refresh data
18978:
How to determine the number of months between 2 periods?
18979:
Workbook
18980:
help with a formula
18981:
How can I refresh data in pivot tables lcoated in separate tabs?
18982:
Excel 2003 - change columns to rows and rows to columns
18983:
How to make cells decend by date
18984:
How to open a csv file without auto converion
18985:
Macro that won't go away!
18986:
copy drop down lists from desktop excel to pocket excel
18987:
Stock symbols in XL 2007
18988:
Info from Word form into Excel cells
18989:
PIcture Help
18990:
Save workbook with a name mentioned in a cell
18991:
paste special
18992:
unknown #value error
18993:
How to locate the error files?
18994:
If + ISTEXT + SEARCH
18995:
Help appreciated
18996:
Claim template
18997:
Print output does not contain entire range
18998:
after entering a text in one cell, next cell should disp the entd
18999:
Updating links in Excel 2002
19000:
IFstatement OR VBA
19001:
Range quest.
19002:
Red Numbers Print out Dotted
19003:
How to quickly check any error for opening excel files?
19004:
Any microsoft links for Interest Rate?
19005:
AutoFilter
19006:
How do I insert a ' } ' into excel so that I can adjust its size?
19007:
set default directory for saving files
19008:
Populate one cell with specific figure
19009:
Auto fill in cells
19010:
Multiple "IFAND"
19011:
Print Quality setting in Excel
19012:
Excel 2007 Save As HTML?
19013:
External Data Tracking in Excel 2007?
19014:
XML elements in Excel
19015:
Pivot table problem
19016:
Extract alpha from a cell
19017:
Cut A sheet
19018:
Back tracking dates
19019:
Excel to Outlook reminders
19020:
AutoUpdate
19021:
Can't open Excel 07 document I just created
19022:
Control Toolbox and Private Sub Worksheet_Change(ByVal Target As R
19023:
sharing macros with other users
19024:
XL 2007: Conditional formatting not saved properly
19025:
Why are some subtotals missing from my pivottable?
19026:
File opens slower on different machines
19027:
Deleting Duplicates
19028:
lockout changes
19029:
Excel 2002: How to sum up in batches ?
19030:
Editing data on multiple worksheets
19031:
reveal unshown data in cell
19032:
Is there a comparison list of commands? (Excel 2003 vs 2007)
19033:
Protecting a 2007 Workbook continued... Bob Phillips you out there
19034:
Conditional formatting from one worksheet to another...
19035:
Date in header that is not the current date
19036:
How do I filter displayed columns when double click in a pivot tab
19037:
Using Excel as a web page
19038:
Enable Iterative Calculations
19039:
divide the cell
19040:
Access and Excel 2007 don't open
19041:
Macro- Column Insert
19042:
Read both US and European Formats
19043:
How to leave out unused cells when printing?
19044:
Using a macro to open another document
19045:
If and AND?
19046:
Macro won't select columns
19047:
How can i get alert on my pc when shared excel sheet is modified?
19048:
Excel 2002: Why could not paste to Quattro Pro Worksheet ?
19049:
Formula problem
19050:
Automation Macro for updating formula when changing cell value
19051:
VBA variables retaining their values
19052:
Dates as text in Mail merges
19053:
converting files
19054:
how do I download excel templates for office 2003?
19055:
new pivot table user with filter question
19056:
Dynamic Formula Generation
19057:
Command line switches - possible
19058:
Return cell reference as text
19059:
Code to Move Several Lines to Master Worksheet
19060:
Editing Data Validation Input Messages
19061:
Bold Font question
19062:
Data Validation Arrows NOT showing
19063:
Importing Sort Codes
19064:
Conditional formatting again
19065:
Cell formatting
19066:
Formula problem
19067:
Looking to break a large number down
19068:
PAGE TOTALS?
19069:
Increase size of a Forms Check Box (click on to enter check mark)
19070:
to clear contents of a spreadsheet
19071:
Seperate digits of a number in a cell by columns and back
19072:
NEED HELP - PICTURE
19073:
How do I display a single quote in a cell?
19074:
Getting data from a filtered list
19075:
Zeroes omitted from the end of imported currency
19076:
How can I capture the last date a file was saved in the footer
19077:
Please quickly answer
19078:
pivot table showing row field with no value
19079:
ctrl+copy not working
19080:
Separating names
19081:
Split Military time over fields
19082:
Macro Help?? Or maybe some other way to do t his
19083:
Ranking numbers
19084:
Lock worksheet, but leave one column open
19085:
=left of decimal
19086:
divinding error
19087:
Is there a way to always view the drop-down menu arrow, without h.
19088:
how do i check if a number is repeating
19089:
Calculate by Date
19090:
Annoying Replace Dialog Box
19091:
Counting Hidden Rows
19092:
How can i stop Network Login pop-up while downloading excel
19093:
Easy Question "I think" Text with funtions in it???
19094:
How can I access customer information easily on XL?
19095:
Numbers displayed in the 100th decimal instead on 1,000
19096:
Pivot Tables with Multiple ranges
19097:
how to leave column 1 and move all other colums up or down rows.
19098:
pivot table
19099:
Insert photo in Excel 2007 causes crash
19100:
Print = moving check boxes
19101:
Consolidating text information
19102:
Protect macro from stopping
19103:
Finding a maximum with VLOOKUP
19104:
Help Sorting Outline Numbers
19105:
DB4 imported data
19106:
Posting problems...again!
19107:
Need help to write formula in Excel to auto show only cells with values
19108:
Can't get ActiveSheet to work...
19109:
cell formatting ends up scientific?
19110:
Excel 2007 recording macro
19111:
Curious about "$" in formulas
19112:
Please HELP
19113:
Please HELP
19114:
Japanese Yen problem
19115:
Custom Cell Formats
19116:
PMT function
19117:
Look-Up Capability
19118:
mail merge
19119:
Issues with shared vs. non-shared formulas on somewhat wide spreadsheets
19120:
Pivot table turned flat!
19121:
Help with formulae
19122:
why is absolute hyperlink in XLS file changed when file is saved
19123:
How do I add a page to my spreadsheet?
19124:
Count of Cells Based on Format
19125:
Toolbars are grayed out
19126:
How to make my spreadsheed public
19127:
Delete "CR" at the end of a number and make the # negative?
19128:
2-level subtotals?
19129:
Filename appearing blue?
19130:
IF formula within VLOOKUP (revisited)
19131:
One workbook affects another
19132:
WHY the same macro runs so slowly on a different but faster comput
19133:
ShowDataForm
19134:
Copy & Paste Issue
19135:
How do I....
19136:
importing into excel 2003 from web
19137:
Macros Causing Workbook to Run Very Slow
19138:
Multiple chart series for PivotChart
19139:
in Excel is it possible to have header information show in a cell
19140:
If formula within Vlookup
19141:
Data Consolidation
19142:
How to change the number in a header with each print?
19143:
*HELP* Need a cell to return a column heading
19144:
Help with lookups (Index/Offset/Match/Choose???)
19145:
Making a spreadsheet calculate faster
19146:
How do I link from a master spreadsheet?
19147:
Chancing Excel worksheet
19148:
Can outdated cells transfer automatically?
19149:
locking only one cell
19150:
Cells total help.
19151:
Dynamic range using partial column?
19152:
Ahh.. so frustrated - Web Query stopped working
19153:
Formula problem
19154:
Format cell with 18 characters
19155:
Website
19156:
Counting
19157:
sharing a workbook with one editor
19158:
Insert row adds formula to cell
19159:
Find every 2 col's: SUMPRODUCT, AVERAGE..
19160:
Hide Hyperlink Address
19161:
Formulas as comments
19162:
In a range of months can I capture the most current month entry?
19163:
Filtering on a protected Sheet
19164:
Link Error
19165:
VLOOKUP best formula to use?
19166:
Highlighting cells
19167:
Setting Fill Handle Defaults
19168:
Excel as data entry form?
19169:
How do I transfer information from Exel to Word Mailings?
19170:
Excel 2007 and External Data Sources
19171:
weird thing about clear contents of a worksheet....
19172:
Navigation
19173:
Find every 2 col's: SUMPRODUCT, AVERAGE..
19174:
Write in one cell & copies to another
19175:
Characters in cell
19176:
Adding rows in Excel Similar to Access
19177:
Help calculating dates within a forumula
19178:
printing 2
19179:
can i electronically sign a doc or xls similar to pdf signatures?
19180:
Outlook email showing up in Excel - Would like to remove
19181:
printing
19182:
how do i get more than 256 columns
19183:
How to find out the 3 highest occurrence of number from a list?
19184:
Linking cell to different workbook
19185:
Horizontal Scroll Bar Resizes Sheet!!??
19186:
Lookup all values within multiple columns and copy to new column
19187:
how to create attachment command button
19188:
how do you create labels that hyperlink on forms
19189:
Count Number or words in Cell
19190:
ISNA function
19191:
Spreadsheet is locked???
19192:
How to determine the value?
19193:
Can rights to run but not create a query in excel an option?
19194:
Getting PERSONEL.xls to open on startup
19195:
Conditional Formating
19196:
absolute reference
19197:
Pivot Table Variance help
19198:
Convert dates to 8 digit text
19199:
pivot tables in XL 07
19200:
SUMIF linking to closed workbooks.
19201:
Grouping Totals
19202:
Formatting/calculations question
19203:
Currency identification
19204:
Linking a specific x/y position in a table
19205:
Setting Default Zoom
19206:
How to measure time for processing periods?
19207:
How to determine the minimum value with given condition?
19208:
how to specify "not equal to"?
19209:
Lost column
19210:
Froms
19211:
Excel 2003 randomly loosing database queries
19212:
Macro for Copying Worksheet to New Workbook
19213:
Formatting Cell that Contains If/Then Formula
19214:
Hyperlinks reluctant at intervals
19215:
Need some help with codes
19216:
SUMIF with ABS?
19217:
Copy Range From Multiple Worksheets to a Single Worksheet
19218:
Weird problem with conditional format
19219:
scanning excel list for invalid e-mail addresses
19220:
Wrong number displayed.
19221:
a twist on a VLOOKUP?
19222:
Is a dynamic/live link INTO Access FROM Excel possible?
19223:
Several Formulas
19224:
Combining alike cells?
19225:
Slow Excel Navigation with Up / Down Arrow and slow scrolling
19226:
capturing Data and printing line elsewhere
19227:
How do I change Excel columns from alphabetical to numeric?
19228:
Transfering Info
19229:
Creating a waterfall chart
19230:
Clearing cells takes long, long time
19231:
You've entered too many arguments for this function
19232:
Transpose function
19233:
How do I set up radio buttons in excel 2007?
19234:
Copy/Paste
19235:
merging 2 excel databases using unique identifiers
19236:
Converting full Names from 1 cell to 2
19237:
Does anyone know the code to put a number in the right header and.
19238:
How do I alpabetize the "Recent Document" list
19239:
Editing a workbook at the same time
19240:
can't copy/paste the formula
19241:
Excel 2007 Office Button
19242:
SUM & SUMIF formula problems
19243:
nested if
19244:
Posting Questions
19245:
VLOOKUP and multiple matches
19246:
Cancel opening messages/phantom link issue
19247:
Limit to string length in search@replace?
19248:
How do I put data in excel in placing order? eg first, second, th.
19249:
Combobox
19250:
Custom sorting