Excel Discussion (Misc queries) - Page 7

Thread / Thread Starter	Last Post	Replies	Views
Cell format for Canadian postal codes mmcstech	by ExcelBanter AI	10	10,184
copy formula up Pammy	by ExcelBanter AI	3	10,172
Toggle cell value Ken G.	by ExcelBanter AI	9	10,172
Why can't I access the footer? Renee	by ExcelBanter AI	11	10,162
Can you lock the column width? Nightshade	by ExcelBanter AI	24	10,150
Get External Data grayed out Pat Brown	by ExcelBanter AI	10	10,149
Filter by Time duketter	by ExcelBanter AI	3	10,145
How do I create a legend or key for an Excel worksheet? ditzylittlepixie	by ExcelBanter AI	2	10,143
How can I restore a column that was deleted by mistake Lucia	by ExcelBanter AI	4	10,134
Macro to send email with attachements Gaura215	by ExcelBanter AI	4	10,110
2 columns under one heading [email protected]	by ExcelBanter AI	8	10,104
Fill down visible cells only Stefi	by ExcelBanter AI	6	10,099
How do I calculate EDATE using days not months? pshift	by ExcelBanter AI	4	10,099
calculate percentage of cells that have any value JLeck	by ExcelBanter AI	8	10,095
Align Left and Right in Same Cell Sloth	by ExcelBanter AI	6	10,095
Why doesn't compare and merge work in excel? Paul Wilson	by ExcelBanter AI	3	10,081
How to avoid "insert copied cells"? [email protected]	by ExcelBanter AI	7	10,072
Can you print multiple worksheets double sided? Publisher Lyn	by ExcelBanter AI	23	10,023
Can I have revision date auto inserted when excel file is changed BJacobi	by ExcelBanter AI	3	10,019
Copy all but last 9 characters of a cell Ben	by ExcelBanter AI	6	10,003
Remove Prompt to Open File as Read-Only (Excel 2007) kerryb13	by ExcelBanter AI	3	9,999
How do I get Random pairings in Excel? bchappell	by ExcelBanter AI	7	9,953
How do I remove 10,000+ empty rows below my table? Frustrated Excel User[_2_]	by ExcelBanter AI	8	9,950
Last Refresh date for pivot table HRobertson	by ExcelBanter AI	3	9,921
How do I sort a worksheet without including the column header row Navy Neophyte	by ExcelBanter AI	3	9,905
Formula doesn't work unless hit enter again Whois Clinton	by ExcelBanter AI	7	9,904
convert number of days into years/months eileenmole	by ExcelBanter AI	2	9,891
show fractions rounded up to nearest 1/16th inch John G.[_2_]	by ExcelBanter AI	17	9,885
extract text between two spaces anthony	by ExcelBanter AI	5	9,880
Difference between Currency and Accounting number format. computerkiller	by ExcelBanter AI	3	9,874
How do I make a worksheet have unlimited lines MrLetDownByVista&Office2007	by ExcelBanter AI	8	9,873
Quartile and multiple if jhicsupt	by ExcelBanter AI	8	9,872
How to remove 0's in front of numbers? Kipurr	by ExcelBanter AI	4	9,868
SUMIF using #N/A error as criteria Dave F[_2_]	by ExcelBanter AI	4	9,842
When enter key is pressed, cursor does not move to next cell in Ex Blackie	by ExcelBanter AI	3	9,836
missing cell borders in Excel Nak	by ExcelBanter AI	8	9,832
SUMPRODUCT Can I use less than or equal to with this function Mifty	by ExcelBanter AI	5	9,824
What is the difference between VLookup and HLookup tables plc	by ExcelBanter AI	4	9,824
Generate date on Semi-Monthly Basis debinnyc	by ExcelBanter AI	6	9,811
Return position of 2nd, 3rd, ect occurrence of a character in a st jheby	by ExcelBanter AI	5	9,773
Check if variable is range Michiel via OfficeKB.com	by ExcelBanter AI	3	9,771
Stop excel from processing HTML? IE paste raw html. nick	by ExcelBanter AI	2	9,762
Subtract Min() from MAX() airgrz	by ExcelBanter AI	4	9,759
SUMIFS for rows SDMFG	by ExcelBanter AI	2	9,745
Design Mode Greyed Out ybkusz	by ExcelBanter AI	5	9,736
Pivot table grouping excluding weekends maryj	by ExcelBanter AI	5	9,733
I want to replace all "<br" with a new line character. Balaji	by ExcelBanter AI	3	9,727
change the face color of an Excel command button Chris Leah	by ExcelBanter AI	5	9,722
email hyperlink - cell value in subject line boustrophedon	by ExcelBanter AI	19	9,690
Different Margins for 2nd page? NanaG	by ExcelBanter AI	2	9,682
Why does my text appear as pound signs Dr. Darrell	by ExcelBanter AI	3	9,670
Find if value exist in array Isa	by ExcelBanter AI	6	9,612
Select text before carriage return jellyroller	by ExcelBanter AI	3	9,603
Power Fit - Trendline gsamoil	by ExcelBanter AI	3	9,600
Ruler xyalags	by ExcelBanter AI	4	9,594
How can I transpose reference cells by Auto-fill? CKK	by ExcelBanter AI	4	9,594
can I make cell "yes" equal 1, "no" equal 0 can I make cell yes equal 1, no equa	by ExcelBanter AI	4	9,587
Seed numbers for random number generation, uniform distribution darebo	by ExcelBanter AI	3	9,580
using countif function to add only a half of a number ryanjh79	by ExcelBanter AI	9	9,560
How can I open an excel .tmp file? Brad	by ExcelBanter AI	6	9,560
Average Every Second Column Killer	by ExcelBanter AI	16	9,548
Median - Ignore blanks jhicsupt	by ExcelBanter AI	5	9,540
record macro "That name is not valid." highlifesipper	by ExcelBanter AI	5	9,538
Need formula to subtract 5hrs from date/time field Ken	by ExcelBanter AI	9	9,536
How to return to previous cell? Denise	by ExcelBanter AI	5	9,534
Conditional formatting - not equal to cell above Barbara Wiseman[_3_]	by ExcelBanter AI	5	9,532
Excel #Value! Error on external link, when source file closed Erin	by ExcelBanter AI	5	9,518
Subtotals not grouping? dlw	by ExcelBanter AI	4	9,514
copy formula - keep cell same but increment sheet numbers Ali	by ExcelBanter AI	6	9,507
calculate 6 months forward from a date Eclaires	by ExcelBanter AI	9	9,507
Centering a picture in a worksheet jfg	by ExcelBanter AI	5	9,503
how to multiply two values and round the result PirateJoe	by ExcelBanter AI	6	9,482
Allow Trusted Locations on my network - Group Policy (GP) AKA Bones	by ExcelBanter AI	3	9,478
How can I paste a unique values list? jak roodi	by ExcelBanter AI	14	9,477
Fill background color automatically by typing a letter in a cell Myke	by ExcelBanter AI	5	9,476