TheMSsForum.com: The Microsoft Software Forum
TheMSsForum.com
The MSS Forum
‹
Archive Home
‹
Excel Misc Archive
‹
Page 1
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
388
389
390
391
392
393
394
395
396
397
398
399
400
view full version:
back to formated view
1:
Text to Columns Letters and Numbers
2:
is it possible to print multiple pages with different numbers
3:
How Do I ?
4:
Paste Special
5:
REVERSE VLOOKUP
6:
Page Down
7:
Now ()
8:
Grabbing Formula Information from Another Cell
9:
Printing issue in Excel 2007
10:
Headers change on different computers.
11:
Excel & Greyscale Text
12:
Listbox Values
13:
How to convert positive figures to negative ones?
14:
How do I unmerge cells?
15:
Second to last entry
16:
Add-Ins
17:
batch SUM of LEFT and RIGHT values
18:
Making a comment using a cell?
19:
How do I prevent a text to columns while opening a csv file in Excel
20:
Formula Assistance
21:
Linking tab names to a cell in the sheet
22:
Matching Rows
23:
Compare and update spreadsheets
24:
sending email attachment from excel
25:
Printing whole workbooks on one sheet of paper
26:
Can I use Excel 2007 to generate Fr Reports in Accpac 5.0A?
27:
Extract data in a string
28:
Conditionally format cell to turn red after lookup match
29:
Macro Button
30:
How do I prevent a second personal wookbook from opening up?
31:
Why is my excel sheet suddenly printing very small?
32:
code does not copy
33:
Excel Iteration Program
34:
How to use values stored in a combo box control?
35:
SEARCH IN SUMPRODUCT
36:
Help with my VBA
37:
Create a Fuctioning Checkbox
38:
Dynamic Custom Number Format
39:
Excel Web Services 2007
40:
Shapes and Conditional Formats
41:
Excel Formula help
42:
Saving a workbook/file to a CD or DVD
43:
How can i make it so i can always see the first 2 rows?
44:
Excel 2002: Can I save entire web page ?
45:
Need help copying cells into rows with spaces between
46:
Make Forecasts - How extensive is it?
47:
Need to add 18 months to a date
48:
Using SQL>Request with Excel 2003
49:
Transfer Word labels into Excel Spreadsheet
50:
2007 Excel Auto Fill - Lower right corner
51:
Border Problems
52:
if i email my sheet & pivot to someone with ex2000 it doesnt work
53:
Drop Down List
54:
Need your help Excel Worksheet/Form
55:
Merging three cells into one
56:
Replace NA with Null - Access 2003
57:
Excel Properties Tab on Doc Save
58:
Click and drag
59:
Table Formatting in Excel 2007
60:
Opening Excel 2003 in Outlook 2007
61:
TRYING TO COMBINE FORMULAS INTO AN "OR" FORMULA
62:
Excel Spreadsheet
63:
Conditional formatting won't update until cell is selected: Excel
64:
conditional format using "OR"?
65:
is there a formula for working out vat without repeating *17.5%
66:
Excel comments unable to be edited
67:
Excel converts string in CSV file as number
68:
Word to Excel
69:
save excel file in tiff format in 2007
70:
Wildcard Character in IF formulas
71:
$ use for what
72:
Copy worksheet and rename sheet
73:
Search for data and return multiple fields
74:
excel sheet.
75:
Sheet renaming and use as data
76:
Save file as a .dwg or .dxf file
77:
Remove characters
78:
auto caps lock
79:
Identifying quarter to which a date belongs?
80:
Display text at random
81:
Precedents
82:
Prevent filldown
83:
Conditional Format a cell in time increments
84:
Find within an embedded document object
85:
Array to Populate ListBox Problem
86:
Indirect and sumif functions with multiple workbooks
87:
Formula needed for adding every nth column on another sheet
88:
Saving email addresses from excel document
89:
Create error message if number entered is greater than previous ce
90:
Adding a range with three variables
91:
Can't sum a series of numbers
92:
Labels on data points in chart
93:
auto group row and/or rows
94:
filling a single cell before the sum of the previous rows.
95:
Rounding by .05
96:
Selecting a range of cells in a macro
97:
how i can refer to cell in long formula go to another file
98:
MATCH() or VLOOKUP() across mutliple 65K sheets possible?
99:
remove spaces in front of text
100:
Pivot Table Help Needed!!!!
101:
Convertion of Star Office documents to Microsoft Office
102:
Adding values generated by "IF" Statement
103:
Tidal Times
104:
Macro for Pivot in MS Excel 2003 vs 2007
105:
how do you add cell values to drop down list for other cells
106:
Excel 2007 creating reports for diffrerent products one at a time
107:
automatically enter today's date as a static entry in Excel
108:
Manually changing a picture (shape) name property
109:
Extracting URL from Hyperlink
110:
NESTED OR FORMULAS
111:
Find if there is a matching number in another column
112:
Remove Header/Title from list
113:
Dynamic Data validation Lists
114:
Open Form when file opened
115:
Delete Hidden Named Range
116:
Determine if column contains duplicate value
117:
deleted files
118:
Protect files from deletion
119:
DISABLE AUTO CONVERT FOR GOD'S SAKE!
120:
Importing images to scale
121:
Paste Special in Excel 2003
122:
Another Lookup Question
123:
Counts based on rolling time periods
124:
Change color of row and column worksheet headers
125:
Formula only for visible Cells
126:
date sort
127:
Find account, move them to different sheet MACRO
128:
Regular expression search/replace in Excel
129:
?can I wrap displayed formulas?
130:
find a value from 1 column in another column on another sheet
131:
random merged cells
132:
How to Average elapsed time values?
133:
How to return formatting to cells rather than value for "IF" cmnd
134:
Hide/Unhide
135:
Excel graphics fill options
136:
AutoCalc
137:
How do I take ownership of a document I
138:
Copy (Formulas and Formatting ONLY) no values to other rows
139:
Tool Tips for UDFs?
140:
how do i stop my arrow keys from scrolling?
141:
Publishing a spreadsheet online
142:
How do I add a label to a macro on the quick access toolbar?
143:
Forgot Password
144:
Hide/Unhide boxes
145:
numbers overlapping in line graph
146:
Count matches within two columns
147:
Link a .DWG file?
148:
Look Up Help Needed Again
149:
Constants in Excel
150:
Combine Text Cells
151:
conditional formula with date
152:
Chart title that changes dynamically?
153:
protect formulas in locked cells from changing if data is moved
154:
how do i make a cell turn red if value is less than 0?
155:
code does not work anymore
156:
Is there a macro to...
157:
How to combine information from multiple rows into one
158:
Reassign built-in shortcut keys in excel 2007
159:
dates and conditional formatting
160:
Excel VBA Coding for Printing
161:
Graph Data not displaying
162:
print/preview problem before saving an edited excel worksheet
163:
Seperating numbers from text
164:
Correlations, Group By Type?
165:
how to activate the scrolling within the worksheet?
166:
Excel - printing specific areas
167:
How do i convert a date into 3 seperate columns?
168:
Changing column headers from alphabetical characters to numbers?
169:
fill combobox depending on selection from another combobox
170:
Lookup unsorted list
171:
Dynamic Array (multiple columns) Question
172:
Stop my references cancelling
173:
Countif and
174:
Headers and Footers in Excel 2007
175:
How can I open .wk4 file with Excel 2007?
176:
REMOVE CERTAIN LINES IN A PIVIOT TABLE
177:
Meeting 12 formatted conditions
178:
How do I Subtract 6 months off a date in excel
179:
How to calculate Average
180:
Using VB Copy Entire Row but formulas and formats only no values
181:
how can I Delete data in a spread sheet and keep formulas
182:
Excel Changes Text Cells to Number Cells When Importing XML
183:
why does the highlighter independently jump to another cell
184:
Is there a BETWEEN function?
185:
Pivot version issue-riv
186:
pivot reporting wrong info-riv
187:
Named Range Used in Formula Error
188:
View Questions and Answer to questions I created
189:
Dynamically populate a Date pulldown menu?
190:
Shading cells whenever they change Months
191:
sumproduct
192:
tying 2 Excel spreadsheets together
193:
Forecast Formula Help
194:
Disable autoformat of "true" and "false" text
195:
Look Up Help Needed
196:
Email excel file help
197:
Excel 07 - Combining Number minus the excess wording
198:
Double Conditional Formatting
199:
Set total amount for an equation.....
200:
Excel 07 - combining number
201:
Defined Names issue
202:
refering to specific cell in the formula
203:
Match, VLookup possible formula needed
204:
Edit links
205:
Why is my worksheet smaller with a blue border and movable?
206:
Pivot Table
207:
Graphs as eps or tiff
208:
How do I turn off auto color fill?
209:
Excell Countif w/ more than one criteria
210:
Formula to sum selective data.
211:
Help! How do I insert a manual page break on a change in cell contents
212:
Why the arbitrary spreadsheet size limitations?
213:
opening extensionless text files
214:
Sumif question
215:
Sl. Nos displayed in the right side
216:
Hide the formula
217:
Lookup Formula - I think?
218:
Grid Line
219:
$ sign formats
220:
Restocking spreadsheet
221:
Formula showing 0 - don't want it displayed
222:
Seniority Years Formula needed
223:
Is there a way to Alphabetize worksheets?
224:
Stop automatic data reformat when refreshing a query
225:
Input boxes
226:
error when opening a spreadsheet in Excel 2003
227:
How do I add a formula to a macro?
228:
printing a filtered selection without blank pages included
229:
INEXPLICABLE FORMULA RESULT
230:
Excel formula bar
231:
Conditional Formating or IF Function
232:
WorksheetFunction not working correctly
233:
Outlook spell check
234:
Select a coloumn or row in a Pivot table
235:
Inserting a checkable box (checks when clicked) into Excel?
236:
delete both duplicates
237:
standard deviation plotting
238:
are there any templates for a daily calendar for Excel 2003?
239:
Creating graphs from data in other files
240:
How to House, 123 Street, Somewhere, M1 23X
241:
Can't change birthdate in cell
242:
Formula function(s) to do this? Or is it a formula at all?
243:
Column heading display numbers not letters
244:
Using a Macro in Excel to send an embedded sheet via Outlook
245:
index-match and another condition
246:
Hover / Coment in Save As Web Page
247:
After merging from excel to word i now cant open the excel spreads
248:
how do you show percentage labels on a bar chart?
249:
What is the letter description for paper that is 11x17?
250:
Difference between dates
251:
Conditional Column Display
252:
Printing Embedded Word Docs
253:
What is a 8.5 x 17 paper size also called?
254:
#NAME? - is there a way to stop this error message?
255:
=?Utf-8?Q?Falta_de_espa=C3=A7o_na_c=C3=A9lula_para_a?=
256:
Moving data between columns
257:
Coditional Format
258:
how to sum up values in the date criteria
259:
Subtoatal
260:
HELP! Extra Line Printing - Multiple Pages
261:
Conditional formatting: formula not working on other pc's
262:
please explain the difference between linking data from separate .
263:
Prevent from save if...
264:
#N/A values
265:
Color formatting issue when copying excel sheet from workbook to o
266:
some text formatting may have changed in this file because the max
267:
Extracting numbers from text
268:
Data Validation List will not Fill Down
269:
counting by color
270:
how to calculate hours worked daily & minus 30 min lunch, 7am-5pm
271:
antibiotic drug ampicillin uti gram positive antibiotic ampicillin recipe ampicillin and pregnancy
272:
Change size of drop-down list?
273:
How do i set up a counter?
274:
Folder shortcuts
275:
create an "if then" formula
276:
Max/min functions similar to SUMIF
277:
Don't understand this format
278:
No Workbook at Startup
279:
Vlookup data and numeric
280:
Data translation
281:
Condition
282:
Compare EE #s & Copy Info
283:
How do I save a 689 character fixed field/record format file
284:
Conditional format a cell in time increments
285:
Is this a bug in Excel 2007?
286:
Copying (and protected worksheets)
287:
Copying and pasting tabular text data
288:
Combine 6 worksheets into 1 worksheet - Summary
289:
Custom Cell Time Format
290:
Excel lack of compatibility
291:
auto grouping.
292:
Pivot Table Calculated Field Row - (For Balance Sheet)
293:
Formula Help!
294:
Conditional Formating
295:
Excel - Printing a page that contains an Embedded Word Document
296:
How to put save date in the header (or footer)
297:
Can I write my own help files (.hlp) for Excel workbooks?
298:
Validate if cell use data validation
299:
Excel Macro
300:
What's the difference between excel 2003 and 2005?
301:
Random Selection
302:
Pivot Table
303:
How do I copy a worksheet in the new Excel?
304:
Macro To Run Automatically For Any Worksheet Upon Opening Of THe F
305:
Formula to return column letters
306:
How can I hide a formula in Excel 2007 from other users seeing it
307:
Refer to adjacent cells as variables in formula
308:
Save as CSV results in an Excel file!?
309:
East Asian characters in Excel 2003 worksheet do not print.
310:
Workbook won't allow me to insert worksheet. How can I add one?
311:
questionnaire template
312:
How do I put a checkbox with no words?
313:
Data Fields in Pivot Table
314:
Page numbers appearing across spreadsheet
315:
Macro to Fit AutoShape over Range?
316:
Default Save Extension
317:
Error message - Errors were detected while saving FILENAME
318:
Cells not included in formulas
319:
Database problem
320:
excel spreadsheet compare
321:
Exporting Quickbooks Data into Excel
322:
Form a sublist from a list using lookup
323:
Formatting text within merged cell
324:
Unprotect workbook
325:
Commas drop off of number in mail merge to into Word
326:
Dating a file.
327:
Protecting Cells from changing or modifying long formulas
328:
Why does my cell content display as '############'?
329:
Sorting by name but ignore the word The
330:
Displaying BOTH formulas and values
331:
Timestamp for changes in any row of cells?
332:
Place zeros in blank cells
333:
Cells won't automatically update --- urgent!
334:
Count
335:
Print Landscape/Portrait based on level of grouped data selected
336:
Integrity of Column Headers
337:
Rotating on-call schedule M-F for 13 people?
338:
I am unable to unhide rows through the format menu.
339:
HOW DO I CREATE A SERIES INVOLVING CELLS ACROSS ROWS?
340:
Preserved cell formatting
341:
Need to find the name of the command buttons
342:
splitting my cell
343:
List Dependent Worksheet Functions
344:
LIST BOXES TOO WIDE
345:
Date value conditional formatting or Macro
346:
Multiple "IF"
347:
Import/export netCDF files to Excel
348:
Multiple "If"
349:
Creating a Macro? V2
350:
Balance of pivot table data