TheMSsForum.com: The Microsoft Software Forum
TheMSsForum.com
The MSS Forum
‹
Archive Home
‹
Excel Misc Archive
‹
Page 19
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
6301:
Convert number to text with proper accounting for Cheque Printing
6302:
can you format a cell so that formulas will be turned off
6303:
Pivot Table - Simultaneous Drill-Down
6304:
conditional Reminder
6305:
Generating a random 17-character alphanumeric string
6306:
Selecting cells of a specific color only.
6307:
Excel changed into Word
6308:
Having problems with static positioning
6309:
how macro or vba to print
6310:
Link Macros Excel 2007
6311:
Excel encryption
6312:
Adding numbers in multiple rows
6313:
Conditional Formatting
6314:
Radio button not working for duplicate worksheets
6315:
Automatically put AutoShape in certain spots
6316:
I have two IF
6317:
Nested IF Function
6318:
Forms Control
6319:
worksheets
6320:
Hyperlinks
6321:
How can I add the OneNote 2007 icon to the ribbon in Excel 2007?
6322:
Vlookup to look up multiple fields?
6323:
Entering Data
6324:
Workbook
6325:
copy conditional formatting, paste format without conditions
6326:
Remove leading zeros
6327:
showall not working
6328:
Problem with Autorecovery in Excel 2003 (over RDC)
6329:
Excel 2007 Pivot Table Filter Issue
6330:
Excel 2007 Pivot Table Multi Value Filter
6331:
Excel 2007 Pivot Table Filter (multi value)
6332:
Pivot Table Styles limitation?
6333:
rearrange date
6334:
Conditional format when autofilter engaged
6335:
Excel background changes when cell has content
6336:
HEADERS HELP PLEASE!
6337:
apostrophes
6338:
Conditional formatting based off cell with text? (i.e. "less than
6339:
How can I get information from 1 page to be separated into two line
6340:
Dynamic count on an Autofiltered list
6341:
How do I turn off Static values
6342:
Setting an Icon Set conditional format for a single cell???
6343:
VBA Cell Ref "$A$1" versus "$A1"
6344:
Cell References
6345:
copy chart to another worksheet - crashes
6346:
cannot start the source application for this object
6347:
Calculate Transaction Time Over Days
6348:
How create a new Project in VBA
6349:
Searching for a request form
6350:
Excel protection & macros
6351:
if command
6352:
SUMPRODUCT calcs correctly on one PC, but incorrectly on another
6353:
Do I use a VLOOKUP or MATCH?
6354:
TextBox linked to a ComboBox?
6355:
Reset button code for Radio Buttons
6356:
not allowing duplicates if 2 criteria are met
6357:
Paste special not working
6358:
Paste special not working
6359:
How do I lock a boarder from being changed or removed?
6360:
Installation of Excel and other MS Applications
6361:
Add-In Visibility
6362:
pivot table shortcut key
6363:
Page numbering on one page
6364:
Pivot Totals: Group totals different from Grand totals
6365:
Friday date of next week..
6366:
Linking OptionButton and Text field
6367:
copy a worksheet to new one with repeat rows 5 times
6368:
Possible to add a Line break in a formula ?
6369:
Change line spacing in template
6370:
Error Message in 2007
6371:
sum 12 numbers
6372:
How do I add the contents of two cells, containing text.
6373:
Identify the Current Cell
6374:
Share 2007 files on SBS 2003 server - read-only doesn't display us
6375:
counting of names
6376:
Upload worksheer?
6377:
COUNTING UNIQUE ENTRIES IN FILTERATION
6378:
lookup data betwaeen two date
6379:
Looking of formula of a values
6380:
Excel or database program calculation?
6381:
EXCEL FUNCTION OR FORMULA
6382:
Loan amortization template
6383:
Concatenate error
6384:
macros and file size
6385:
Mode function
6386:
Does anyone know how to convert 07 template to 03 in excel?
6387:
Cell Data not recognized by Formulas
6388:
Drop down list
6389:
Drop Down List
6390:
grouping rows
6391:
Create Status Chart for projects
6392:
Can't Open a Read-Only file in Excel 03
6393:
Search for Upper Case
6394:
Color Pallete Not Resetting Properly
6395:
Cell formatting and if statement
6396:
How do you print 2 graphs on 1 page
6397:
Opening Excel Document - "CD-ROM ERROR"??
6398:
Trouble with worksheet layout.
6399:
Improving the Discussion Boards
6400:
INDEX function
6401:
Import only certain cell values into a new work book
6402:
where did the blogs go?
6403:
Synchronizing multiple worksheets in a workbook (Excel 2003)
6404:
Same row conditional logic (count help)
6405:
How to fix an array or range
6406:
Inconsistent notification of read-only status of Excel file on ser
6407:
Adding area codes only to phone numbers missing an area code
6408:
Excel Work Book Copied Into Word With Paste Special, Excel Workboo
6409:
2003 Office Excel .tmp files not deleted upon file save
6410:
How would you go about...
6411:
How do I insert page breaks in a huge EXCEL file?
6412:
Don't print cell colors, Print font colors.
6413:
Col to Rows Formula?
6414:
Help
6415:
Worksheets in a formulae
6416:
Challeging Calculation
6417:
how do i copy the subtotal lines only without the details?
6418:
Need Help Tabbing between controls
6419:
If column = value sum another column and place result in cell
6420:
Sumproduct question
6421:
Help with calculating data from different fileds
6422:
Macro
6423:
what is a label
6424:
Need help building a macro
6425:
Adding "Work" to Excel menu
6426:
Using Worksheet names in formulae
6427:
IF Statement not working after pasting data
6428:
Help with Macro
6429:
Need help editing a macro
6430:
Removing Special characters in Excel
6431:
About IF and summing IF over multiple spreadsheets
6432:
Excel Error Message
6433:
Unhiding multiple sheets at a time
6434:
Count Text In Column
6435:
Saving a copy without incrementing number
6436:
Multiple address lines in an 'if'
6437:
Text Box
6438:
Trace dependents for multiple cell
6439:
most efficient way to filter out and iterate through datasets in X
6440:
Does office 2007 still use the routing recipient feature?
6441:
Excel 2007 - Switch vertical and horizontal axis?
6442:
Sumproduct
6443:
Text file to excel
6444:
Removing an Advanced Filter
6445:
"IF" formula gives wrong answer
6446:
How can I change the default fill colour in excel 2007
6447:
Import of text file - numbers destroyed!
6448:
1 icon per workbook
6449:
Subtraction from a column.
6450:
COUNT UNIQUE ENTRIES IN FILTERED DATA
6451:
progressive dinner dilema
6452:
Count from Blank & Non-Blank Cells
6453:
Is there a way to subtract a column of numbers?
6454:
employee
6455:
Difference between Currency and Accounting number format.
6456:
Keyboard shortcut for Page Setup in excel 2007
6457:
DATES ARE SCRAMBLED!
6458:
Consolidating data from multiple spreadsheets...
6459:
How do I autofill data in a column?
6460:
CONDITIONAL FORMATTING FOR MORE THAN 3 CRITERIA
6461:
Copying data from Web Site to Excel spreadsheet
6462:
Formula for subtracting multiple meter readings for usage totals?
6463:
Uploading Excel to web site
6464:
duplicates
6465:
Using Excel 2007 created Spreadsheets in Excel 2003
6466:
pivot consolidated range question
6467:
Missing Graphing Functionality
6468:
Countcells if they match certain criteria from other cells
6469:
HELP
6470:
Excel Speed Performance help
6471:
Reverse Time Series Order
6472:
Making a Database
6473:
Error - message help please
6474:
Customizing Menus in Excel 2007
6475:
IF Function
6476:
Sumproduct for YTD with text filter
6477:
Absolute Cell Reference Click
6478:
PivotTable Totals
6479:
page setup won't allow entering "rows to repeat at top"
6480:
fill series formulas
6481:
The Boss Is Ticked - Problems Copying Formula - Help??
6482:
COpy formulas from one workbook to another workbook
6483:
PivotTable Charts
6484:
Count date occurences within a year
6485:
2nd and 3rd last number in a column - how to get it?
6486:
Linking an excel worksheet to Quicken
6487:
#Div/0!
6488:
Tabbed worksheets missing after conversion to 2007
6489:
Compile error in hidden module
6490:
Save formatting for re-use with new data?
6491:
Help With Conting In A List
6492:
Calculating frequency
6493:
Sorting/Filtering
6494:
Save generates unprotect sheet dialog box
6495:
Help again
6496:
sorting and adding cells in different work sheet? (hard stuff)
6497:
SUMPRODUCT
6498:
Pattern not printing in Excel
6499:
Multiple sheet Pivot table
6500:
Display error message if a cell is left blank
6501:
vlookup with range reference
6502:
Command Buttons
6503:
trying to automatic fit large amount of text in cell
6504:
custom footers in excel 2003
6505:
Counting If
6506:
IF a cell contains specific text
6507:
Sale Taxes
6508:
IF AND OR Formula Help
6509:
Data from rows into columns
6510:
Macro changes formulas
6511:
IF AND Formula Help Needed
6512:
Selecting number of hours per subgroup
6513:
Changing cell contents
6514:
filters
6515:
do away prompt when protected cell is being written
6516:
Counting, 2 criteria
6517:
copy & paste from Excel to Word
6518:
Copying pivot table
6519:
MACRO & FUNCTION
6520:
Prompt to Open or Save the downloaded file
6521:
getting the dates??
6522:
horizontal lines to vertical
6523:
Excel Screen Refresh Issue in Terminal Server
6524:
how to change text color using keyboard shortcut?
6525:
CONDITIONAL SUMMING
6526:
Copy cell contents in empty rows below it till any unempty row com
6527:
function to make a running total
6528:
VBA Code help
6529:
Automation to Excel from Access
6530:
Change email icon in Excel 2007 to point to Winmail
6531:
Help opening pictures from hyperlinks
6532:
legal download of MS-Excel 2003
6533:
Can Excel track document editing time?
6534:
Can Excel track document editing time?
6535:
Cut and paste to a new documet in 2007
6536:
IF Function
6537:
Sumproduct using date
6538:
Spell check when worksheet is protected
6539:
Links only work with both workbooks open...
6540:
Excel 2007: How do I create a hovering (detatched) toolbar?
6541:
number alpha list w/duplications
6542:
CAPITALISE GLOBALLY
6543:
CAPITALISE
6544:
How do I get worksheet to print same font and size as file
6545:
add ins.com- worth it or not
6546:
2007 XL Delete Range Name
6547:
configuration progress message
6548:
Screen Scrambles
6549:
Real Protection
6550:
Grouping on key word
6551:
Opening Excel 2003 in Excel 2007
6552:
Calculate Range
6553:
transpose horizantal basing on cellvalue
6554:
copy and transpose basing on cell values
6555:
Updating macros with copied worksheet information
6556:
Go to a cell that contains the data entered in another cell
6557:
Rearranging and organizing data imbedded in rows
6558:
how can i repeat one thing to a row?
6559:
Day and Time Format
6560:
Alternative to SUMif when linking to closed workbooks
6561:
Email notification of answer posted
6562:
Macro Help Please
6563:
DV message linked
6564:
Sort "text" numbers with and without leading zeros as numbers
6565:
Formula and Macro for issue...can it be done
6566:
Printing labels at the top of multiple pages
6567:
Is it possible for cells within the same column to have diff. widt
6568:
need to delete empty pages in my worksheet
6569:
Problem displaying color
6570:
Copying to a flexible range
6571:
Can I indicate zero with a slash?
6572:
Formula or code for address list into mailing format?
6573:
Excel 2002: unexplainable difference in sum of columns
6574:
different footers on each page
6575:
Open File on PC Start Up (Office 2007)
6576:
how would I write a formula
6577:
Excel 2003 pauses after copy or paste actions
6578:
Automatically refresh sorted data
6579:
saving document
6580:
Showing formulas
6581:
macro with input msg based on cell contents
6582:
How do I change the timezones in excel spreadsheets?
6583:
IF function
6584:
Countif Cell multiple arguments
6585:
how to count number of days between 2 dates?
6586:
How do i prevent the 000's in the beginning of an entry from dropp
6587:
Is there a macro i can use to copy a cell +1
6588:
Excel 2007 and Vista
6589:
How to create references with a dropdown?
6590:
comment s
6591:
How to keep the wheel mouse from scrolling horizontally?
6592:
Formula Question
6593:
conditional formating iserror isna
6594:
Hidden comments
6595:
Formula
6596:
Sum with IF
6597:
eleminate same records in two tables
6598:
Color Pallet -- Changes when opening files
6599:
Sorting with pictures
6600:
Find Option replacement
6601:
How to use the "Range" object
6602:
Opening an Office 2003 Excel doc with Office 2000 NT
6603:
Number of Hours&Minutes between Dates and time
6604:
Excel crashes worksheet with VBA and Word with embedded worksheet
6605:
Macro To Insert Row
6606:
find and display all possible start times and days to work
6607:
Display feet inches and fraction
6608:
Select all rows on a sheet from a fixed starting point
6609:
Calculating: (1 Processor(s)): 25% MESSAGE ON STATUS BAR
6610:
Saving takes 30 Seconds
6611:
Trigonometric Trendline
6612:
How reference multiple sheets in a formula
6613:
merging lists
6614:
Couple of Questions Need Help Please.....
6615:
activate a page of a Multipage in Userform
6616:
Formula Help
6617:
Remove space at beginning of each name
6618:
Sorting by code
6619:
Tallying Votes in Excel
6620:
suspend auto increment
6621:
Need help taking columns of info and putting them into another fil
6622:
Excel 2000 file in use when opening xls file
6623:
highlighted cell includes next cell
6624:
Excel 2003 file open with no data
6625:
Need macro to find worksheet...
6626:
copy formula
6627:
Need to pivot my data from columns to rows
6628:
Need help converting notepad/txt file to Excel
6629:
Command-line switches
6630:
Calculate Percentage Based On Number
6631:
Formatting Worksheets
6632:
Vlookup returns #N/A
6633:
Scrolling to a cell in formula
6634:
Link Password Protected Workbooks
6635:
Input box
6636:
xlr Worksheets
6637:
worksheet protection
6638:
solver used with Excel french and english
6639:
File Type Conversion
6640:
Workbook Help
6641:
Changing username
6642:
xy scatter plots
6643:
Does anyone know why the g disappears if hge is typed in a cell?
6644:
Can I colour the response from a calculation?
6645:
How to perform caculations using database functions in this case
6646:
== INSTEAD OF EXACT?
6647:
vlookup issue on Mac
6648:
Format Cells Date (or any change) not working on imported data
6649:
Grouping dates in pivot table by quarters
6650:
Penultimate cell