TheMSsForum.com: The Microsoft Software Forum
TheMSsForum.com
The MSS Forum
‹
Archive Home
‹
Excel Misc Archive
‹
Page 61
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
21001:
formula result - HELP - very simple
21002:
Data Extraction
21003:
Lining up decimal points with negatives in brackets
21004:
Quick Question
21005:
web query from tim
21006:
#NAME? and other results.
21007:
vlookup to match
21008:
Conditional Sort?
21009:
Conditional Formatting - Before Page Break
21010:
IF statement help
21011:
¤p¤k¤kª±line line
21012:
hide personal.xlsb file without closing
21013:
An Excel 2007 file I had previously used, will not open
21014:
Pivot Tables
21015:
Combining complex data
21016:
Run Macro from Command line
21017:
Macro in personal.xls does not work
21018:
excel
21019:
vlookup and finding text string that's not an exact match
21020:
Excel 2007 one network file running (loading and saving) slow
21021:
Drop Down list to run Auto filter on another sheet
21022:
text boxes and shapes in excel 2007 move when printing
21023:
File Dropdown List
21024:
counting ROWS that have 2 criteria
21025:
How to have Checkbox A uncheck with checked Checkbox B
21026:
Hiding Data while printing
21027:
Yikes! Merged cells making life miserable.
21028:
How do I change the legend Series order in Excel 2007?
21029:
How do I change the Series plotting order in Excel 2007?
21030:
Analysis Toolpak
21031:
Don't Round...
21032:
restrict columns that have auto filter
21033:
Cell Boarders when printing
21034:
Updating Source List
21035:
problem with formula
21036:
Combo Box Pulls data
21037:
Conditional Formatting and pivot tables.
21038:
How to stop spreadsheets automatically updating on opening?
21039:
Hiding Various Empty Rows
21040:
Excel2007's performance over large amount of data( over 500,000 - 1M)
21041:
Find partial cell format
21042:
Convert numeric values in words.
21043:
Hi need help with RowSelection
21044:
Change default document path for all programs in Office Suite?
21045:
Cell changes
21046:
Protecting a file from Copy/Paste
21047:
Workbook Link Problems
21048:
How can I choose every nth name in a spreadsheet?
21049:
Sum values greater than x and less than y in a column
21050:
Keyboard Shortcut "Select All of the Same"
21051:
how do i fix error message 'margins do not fit page size'
21052:
Modification Date
21053:
IF formula
21054:
Date Formulas
21055:
skiping sections in a macro
21056:
How do I pull value from c8 but only if a8 = a certain value
21057:
Header copy across workbooks
21058:
formula lock
21059:
Increase date by 1 year
21060:
Changing color of a row
21061:
Sorting changes validation
21062:
Help with Auto Filter "Ends With"
21063:
Can't Save or Find
21064:
Help with formatting columns.
21065:
Invoice again
21066:
Nelp required to integrate ProgressBar
21067:
Text to Columns
21068:
How to open files in order they were selected
21069:
Checking formula type (reference to other worksheet or not)
21070:
Printing mulitple times to adobe
21071:
Hex numbers displayed in scientific notation when importing text f
21072:
Spreading Formulas across the whole document
21073:
Microsoft Query - Change the order of the fields
21074:
Compare text in cell to custom text format??
21075:
using fill handle with hidden rows
21076:
Assign macro to hotspot
21077:
hyperlink format
21078:
The Links Effect
21079:
How to change case of text without using functions?
21080:
Inexplicable VBA errors in formulas
21081:
IF take 2 (ROUNDING)
21082:
IF Formula
21083:
Worksheets alphabetical?
21084:
Changing selection color
21085:
¤¤°êª±line¤p¤k¤k
21086:
How to change column heading from numerical to alphabetical?
21087:
Transfor numerical digits to English
21088:
Is this possible
21089:
Linking worksheets
21090:
atpvbaen.xla cound not be found
21091:
Unable to use the draw function when enable Track Changes in Excel
21092:
Extracting data into another worksheet
21093:
Re: "compile error in hidden module"
21094:
I wana prepare a pay roll of employee of 1500
21095:
How to alphbetize multiple Excel Workbooks on my desktop?
21096:
Importing 750 Columns
21097:
Sorting hidden columns
21098:
how do you get excel to leave zero,s after the decimal point?
21099:
Can I write an infinite amount in a cell with expanding the cell?
21100:
port formula changes to multiple workbooks?
21101:
Match type?
21102:
Automatically change column widths?
21103:
Text To Column Question
21104:
How do I insert a watermark in Excel containing the word "draft"
21105:
Window Tool Bar - Freeze pane does not appear
21106:
Change list of cells to paragrph form
21107:
Sort box grows
21108:
Performing Action on a Range of Rows
21109:
Charts below data
21110:
Copying labels down
21111:
Unable to open Office 2007 files using Office 2002 XP
21112:
print setup -columns to repeat
21113:
How do i delete empty rows in a spreadsheet
21114:
Excel sheet into word document (2007-2003)
21115:
record a macro to update pivot table
21116:
How do I subtract time where hh:mm:ss:ff (frames = 30 frames/sec)
21117:
Copying Labels in Subtotals
21118:
formula for sumproduct
21119:
Help with tabs
21120:
How do I superimpose an "X" over a number in an Excel cell?
21121:
Tab to next control box
21122:
decap names from transferred data
21123:
Receiving font error
21124:
Cells by Week
21125:
intersection of a range
21126:
Sender's print preferences retained on .xls and .doc email attachments
21127:
formula to count commas
21128:
office 2
21129:
Performing Action on a Range of Rows
21130:
Why doesn't autofill work in Excel?
21131:
If statement propblem
21132:
manual numbers entered in formula
21133:
Insert combo box in a cell
21134:
Add-in 2007
21135:
Pricing for Duet - Software (15 numbers)
21136:
Importing External Data
21137:
Cannot move an automatic page break
21138:
Making macro
21139:
Is there a good program for excel to combine, compare, and edit bo
21140:
Top 10 Ranking again
21141:
Functions
21142:
How to avoid cell overlapping?
21143:
Passing a range to a user defined function
21144:
Pivot table -duplicate rows
21145:
Text changes to General
21146:
Pivot Table Error
21147:
Count the number of times a cell in a column is shaded green
21148:
Taking long time to save file to sub folder
21149:
Can a color background on the screen be made to print white on pap
21150:
How do I combine two Excel Workbooks and delete the duplicate colu
21151:
Check if text exists within a cell range and return logical vaule - possible?
21152:
inventory management within excel file
21153:
Configuring the number of rows printed per page
21154:
O-07 Paste Special Values icon
21155:
pivot table format
21156:
Tabs
21157:
Office 2007 issues
21158:
Create a copy with all data linked to the master
21159:
Automatic Data Entry
21160:
how to do formula
21161:
VLookup - Error Checking
21162:
Top 10 Ranking
21163:
Menu Item disappeared after double-clicking xls
21164:
punctuation marks won't appear unless character inserted after quo
21165:
Excel Calculation Tool
21166:
filter list of times Excel 2003
21167:
Calculate a date
21168:
Replace Pop-Up Problem
21169:
change font size on screen, but prints in old size
21170:
Cum fac subtotaluri intr-ul Pivot Tabel?
21171:
Show drop down icon
21172:
Conditional Formatting - Weeks VOR
21173:
Drop down sends value to another cell
21174:
vlookup
21175:
Hide columns without data
21176:
Total Revenue Percentage
21177:
Tracking Time Zone
21178:
Convert text date to general number
21179:
Excel-Macro Problem
21180:
trandline object
21181:
Scrolling in combo box
21182:
Excel changes the year from 2007 to 2003 when a file is copied
21183:
Formating Cells as Negative
21184:
Static Top Rows
21185:
How do use listed pathname to link values from another workbook?
21186:
How to change the precision for Pivot Table
21187:
Not include hidden columns in copy paste
21188:
transpose without 0's and blanks
21189:
what drive am I in
21190:
Date in a cell is before or after a date in another cell
21191:
dynamic hyperlink
21192:
Error Trying to add Calculated Items to a pivot table
21193:
Are Hidden Rows/ Columns Included in a Sort?
21194:
Recording Macro's Mini Floating Toolbar
21195:
personal workbook
21196:
How to copy and paste conditional formatting for the cell next to
21197:
Transparent Cell Borders For Formula Cells?
21198:
How do I get the average of entries in a group of columns?
21199:
VLOOKUP Formula
21200:
Switching view on/off for row & column headers?
21201:
Can I do a mail merge from within Excel?
21202:
how do I conditionally hide or show a column in Excel
21203:
Double VLOOKUP
21204:
macros, Passwords, and XP
21205:
Semi Colon Deliminated File
21206:
Trying to get a Boolean formula to work month-to-month
21207:
VB formula for Copy
21208:
Merging From One Sheet to Another
21209:
Can't see spreadsheet
21210:
Updating Charts - Excel 2003
21211:
Compiling data from many work sheets to one
21212:
Looking for alphabet tracing
21213:
Thanks
21214:
I am trying to lookup a cell based upon what is in row 3 and colum
21215:
On Microsoft Excel can I avoid duplication of names on a schedule
21216:
show to stop scientific numbers from general formating
21217:
do not show zero's in pivot chart
21218:
blank sheet
21219:
Word docs to Excel
21220:
How to put "between values" (e.g. 3-9) to the formula?
21221:
linking object to cells
21222:
Loan Amortization Schedule project
21223:
Excel2007 - More columns when importing ascii file?
21224:
Why does Excel change a date into a formula?
21225:
Compare Two Excel Workbooks & Display Discrepancies
21226:
Manipulation of Data extract from Access Database
21227:
gridlines printing over text
21228:
Invoice Numbers
21229:
Changing the TAB key
21230:
Export to View on Intranet?
21231:
two diffrant days time count
21232:
Conditional formatting and Highlighting Date Range
21233:
Conditional formatting and Highlighting Date Range
21234:
add footer to spread sheet
21235:
Match 9 to 11 digits - vlookup
21236:
Link Comment to multiple cells
21237:
Additional Rows and Columns in Excel 2007
21238:
Solar Calendar Format in Excel
21239:
Conditional format for 5 numbers
21240:
Right to Left sorting without changing language settings
21241:
Conditional formatting formula for past due dates
21242:
Conditional formatting for past due dates
21243:
2 data sets in one cell
21244:
How to change the Column Reference when working with multiply work
21245:
How to filter on highlights?
21246:
Module & Popup dialog
21247:
Page Breaks- Printing selected rows on same page
21248:
Delete "Unused names" in a batch
21249:
Performance Spreadsheet (Rates of Return)
21250:
Excel 2002: How to tranpose data to designated cells ?
21251:
How do I change the Row Reference from a seperate worksheet.
21252:
suppress zeros in a pivot chart
21253:
print blank sheet
21254:
Excel 2002: Any quick way of transposing data ?
21255:
what is vlookup?
21256:
formula for database search - is it possible?
21257:
Web Queries
21258:
Code Documentation
21259:
Vlookup on blank cells formatted with dates
21260:
Counting in a cell
21261:
how do I convert numbers to text eg 1 to one
21262:
Combining Tables
21263:
Alt+E No Longer Opens Edit menu
21264:
values in table
21265:
PLEASE I NEED HELP WITH MY QUESTION PLEASE ! ! !
21266:
Subtotals but without all the info. PLEASE HELP!
21267:
excel help
21268:
save as macro
21269:
Pivot table turning static in Excel 2007
21270:
match function
21271:
Loopfolder Macro
21272:
loopfolder macro
21273:
big string in a normal cell
21274:
Loopfolders Macro
21275:
cumulative totals
21276:
Pasting Charts into Word then resizing them
21277:
cumumlative pivot table total
21278:
COUNTIF using multiple criteria
21279:
Simple(?) Sort Problem
21280:
preventRepeated
21281:
Formular to read the last entry in a column
21282:
Fixed vlaue in the Fill handle opperation
21283:
Finding minum positive from the result of formula
21284:
saving
21285:
Excel Drop Down Menu linked?
21286:
RELOCATING A FIELD IN A PIVOT TABLE
21287:
PIVOT TABLE CUSTOM FIELDS
21288:
LoopFolder Macro Save as
21289:
summary sheet that refers to multiple sheets
21290:
loopfolder macro
21291:
Evaluating Workbook Content Impact on file Size
21292:
Need some help on some text handeling
21293:
Macro Ranges
21294:
loop folders macro - Sorry for duplicate posts
21295:
double-click opens book1 also
21296:
Loopfolder macro
21297:
Loopfolder macro
21298:
advice about most stable file structure
21299:
PROBLEM WHILE SUMMING OR INSERTING A FORMULA
21300:
Copy subtotals
21301:
conditional formatting help please
21302:
worksheet
21303:
How to Unsave
21304:
Converting database generated report to raw data
21305:
excel 2003 Command descriptions
21306:
un-editable
21307:
Save As Macro
21308:
PIVOT TABLE RELOCATING A SUB FIELD
21309:
PIVOT TABLE CUSTOM FIELD
21310:
HYPERLINK OPTION NOT SHOWING
21311:
Why won't Excel print all of my spreadsheet?
21312:
Automating Updates on Price Lists
21313:
Cell/column auto adjusts width to longest text string
21314:
Automatically Adding Rows
21315:
shorter formula / not array?: every other col..
21316:
Condtional Format
21317:
#value
21318:
Calculate to total individual lines
21319:
Summing not summing
21320:
Reset sheet count
21321:
Import with out chaning to a date 2/10/02 ends up 2/10/2002
21322:
Select Pivot Table
21323:
Data Alignment in columns
21324:
Attaching an image to a cell
21325:
How do I use hyperlinks with attachments?
21326:
Excel 2007 change pivot data source
21327:
functions greyed out/not working
21328:
Automatic conversion to scientific numbers
21329:
Need Help With My Job Report
21330:
Image behind a selection of cells??
21331:
Spell check / character cell limit
21332:
Columns A-AA Have Disappeared
21333:
Make Worksheets Given a Certain YEAR
21334:
Forms
21335:
cell format doesn't take place
21336:
Type of SUM formula ???
21337:
Excel Form / Inventory List
21338:
if & Loop
21339:
Access to sheets
21340:
waht are the cells in excel measured in? rows/columns=different
21341:
how do you open a drop down box?
21342:
Loop Column
21343:
merged cells and wrap text
21344:
Calculation - Automatic and Manual
21345:
macro-vba
21346:
Excel 2007 Bug or other problem
21347:
Macro for creating a schedule
21348:
URGENT HELP: Establishing a Training Matrix
21349:
File In Use error
21350:
How to change #DIV/0! to as 0