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,177
copy formula up Pammy	by ExcelBanter AI	3	10,171
Toggle cell value Ken G.	by ExcelBanter AI	9	10,162
Why can't I access the footer? Renee	by ExcelBanter AI	11	10,152
Can you lock the column width? Nightshade	by ExcelBanter AI	24	10,149
Get External Data grayed out Pat Brown	by ExcelBanter AI	10	10,146
Filter by Time duketter	by ExcelBanter AI	3	10,139
How do I create a legend or key for an Excel worksheet? ditzylittlepixie	by ExcelBanter AI	2	10,138
How can I restore a column that was deleted by mistake Lucia	by ExcelBanter AI	4	10,126
Macro to send email with attachements Gaura215	by ExcelBanter AI	4	10,106
How do I calculate EDATE using days not months? pshift	by ExcelBanter AI	4	10,098
Fill down visible cells only Stefi	by ExcelBanter AI	6	10,098
2 columns under one heading [email protected]	by ExcelBanter AI	8	10,097
calculate percentage of cells that have any value JLeck	by ExcelBanter AI	8	10,094
Align Left and Right in Same Cell Sloth	by ExcelBanter AI	6	10,083
How to avoid "insert copied cells"? [email protected]	by ExcelBanter AI	7	10,065
Why doesn't compare and merge work in excel? Paul Wilson	by ExcelBanter AI	3	10,065
Can you print multiple worksheets double sided? Publisher Lyn	by ExcelBanter AI	23	10,014
Can I have revision date auto inserted when excel file is changed BJacobi	by ExcelBanter AI	3	10,004
Copy all but last 9 characters of a cell Ben	by ExcelBanter AI	6	10,001
Remove Prompt to Open File as Read-Only (Excel 2007) kerryb13	by ExcelBanter AI	3	9,996
How do I remove 10,000+ empty rows below my table? Frustrated Excel User[_2_]	by ExcelBanter AI	8	9,947
How do I get Random pairings in Excel? bchappell	by ExcelBanter AI	7	9,943
Last Refresh date for pivot table HRobertson	by ExcelBanter AI	3	9,918
How do I sort a worksheet without including the column header row Navy Neophyte	by ExcelBanter AI	3	9,899
Formula doesn't work unless hit enter again Whois Clinton	by ExcelBanter AI	7	9,897
convert number of days into years/months eileenmole	by ExcelBanter AI	2	9,886
show fractions rounded up to nearest 1/16th inch John G.[_2_]	by ExcelBanter AI	17	9,880
extract text between two spaces anthony	by ExcelBanter AI	5	9,877
Difference between Currency and Accounting number format. computerkiller	by ExcelBanter AI	3	9,871
How do I make a worksheet have unlimited lines MrLetDownByVista&Office2007	by ExcelBanter AI	8	9,871
How to remove 0's in front of numbers? Kipurr	by ExcelBanter AI	4	9,865
Quartile and multiple if jhicsupt	by ExcelBanter AI	8	9,864
SUMIF using #N/A error as criteria Dave F[_2_]	by ExcelBanter AI	4	9,836
When enter key is pressed, cursor does not move to next cell in Ex Blackie	by ExcelBanter AI	3	9,834
What is the difference between VLookup and HLookup tables plc	by ExcelBanter AI	4	9,817
SUMPRODUCT Can I use less than or equal to with this function Mifty	by ExcelBanter AI	5	9,812
missing cell borders in Excel Nak	by ExcelBanter AI	8	9,809
Generate date on Semi-Monthly Basis debinnyc	by ExcelBanter AI	6	9,806
Return position of 2nd, 3rd, ect occurrence of a character in a st jheby	by ExcelBanter AI	5	9,770
Stop excel from processing HTML? IE paste raw html. nick	by ExcelBanter AI	2	9,759
Check if variable is range Michiel via OfficeKB.com	by ExcelBanter AI	3	9,758
Subtract Min() from MAX() airgrz	by ExcelBanter AI	4	9,747
SUMIFS for rows SDMFG	by ExcelBanter AI	2	9,744
Design Mode Greyed Out ybkusz	by ExcelBanter AI	5	9,731
Pivot table grouping excluding weekends maryj	by ExcelBanter AI	5	9,723
change the face color of an Excel command button Chris Leah	by ExcelBanter AI	5	9,721
I want to replace all "<br" with a new line character. Balaji	by ExcelBanter AI	3	9,718
email hyperlink - cell value in subject line boustrophedon	by ExcelBanter AI	19	9,689
Different Margins for 2nd page? NanaG	by ExcelBanter AI	2	9,678
Why does my text appear as pound signs Dr. Darrell	by ExcelBanter AI	3	9,659
Find if value exist in array Isa	by ExcelBanter AI	6	9,602
Select text before carriage return jellyroller	by ExcelBanter AI	3	9,596
Power Fit - Trendline gsamoil	by ExcelBanter AI	3	9,595
How can I transpose reference cells by Auto-fill? CKK	by ExcelBanter AI	4	9,592
Ruler xyalags	by ExcelBanter AI	4	9,590
can I make cell "yes" equal 1, "no" equal 0 can I make cell yes equal 1, no equa	by ExcelBanter AI	4	9,576
Seed numbers for random number generation, uniform distribution darebo	by ExcelBanter AI	3	9,572
How can I open an excel .tmp file? Brad	by ExcelBanter AI	6	9,554
using countif function to add only a half of a number ryanjh79	by ExcelBanter AI	9	9,553
Average Every Second Column Killer	by ExcelBanter AI	16	9,542
Median - Ignore blanks jhicsupt	by ExcelBanter AI	5	9,533
Need formula to subtract 5hrs from date/time field Ken	by ExcelBanter AI	9	9,532
How to return to previous cell? Denise	by ExcelBanter AI	5	9,530
Conditional formatting - not equal to cell above Barbara Wiseman[_3_]	by ExcelBanter AI	5	9,527
record macro "That name is not valid." highlifesipper	by ExcelBanter AI	5	9,523
Excel #Value! Error on external link, when source file closed Erin	by ExcelBanter AI	5	9,514
Subtotals not grouping? dlw	by ExcelBanter AI	4	9,507
calculate 6 months forward from a date Eclaires	by ExcelBanter AI	9	9,506
Centering a picture in a worksheet jfg	by ExcelBanter AI	5	9,498
copy formula - keep cell same but increment sheet numbers Ali	by ExcelBanter AI	6	9,491
how to multiply two values and round the result PirateJoe	by ExcelBanter AI	6	9,476
Allow Trusted Locations on my network - Group Policy (GP) AKA Bones	by ExcelBanter AI	3	9,472
Fill background color automatically by typing a letter in a cell Myke	by ExcelBanter AI	5	9,471
How can I paste a unique values list? jak roodi	by ExcelBanter AI	14	9,466