Excel Discussion (Misc queries) - Page 1951

Thread / Thread Starter	Last Post	Replies	Views
How do I create a drop down list for an entire column? wanderer83	by ExcelBanter AI	9	9,258
removing print area dotted line Nathan	by ExcelBanter AI	5	8,979
randomly select a cell from an array TLC	by ExcelBanter AI	7	9,089
Barcode Scan and separate data into respective columns ExcelNewbie	by ExcelBanter AI	3	10,796
How can I restore a column that was deleted by mistake Lucia	by ExcelBanter AI	4	10,132
Why does the cell turn yellow when entering a number? Katy Did	by ExcelBanter AI	3	10,948
SUMIF using #N/A error as criteria Dave F[_2_]	by ExcelBanter AI	4	9,842
Not all columns are being sorted Gillian72	by ExcelBanter AI	7	8,984
show fractions rounded up to nearest 1/16th inch John G.[_2_]	by ExcelBanter AI	17	9,885
How do i sum values with Different currency Format? edge	by ExcelBanter AI	10	12,132
Check if variable is range Michiel via OfficeKB.com	by ExcelBanter AI	3	9,768
Pivot table grouping excluding weekends maryj	by ExcelBanter AI	5	9,733
Count if a cell has color shading robnsd	by ExcelBanter AI	3	8,918
How to Calculate the Net Promoter Score in Excel Joan Roco	by ExcelBanter AI	1	9,029
How do I sort pivot table data by subtotals? ^^Michelle^^	by ExcelBanter AI	3	9,008
add paper size that's missing in Excel acgaruba	by ExcelBanter AI	3	10,552
VLOOKUP always returning the same value! Jennifer Cali	by ExcelBanter AI	10	8,887
How do I recover a deleted Excel 2007 work sheet tab? Josy Mathew	by ExcelBanter AI	3	9,034
how to multiply two values and round the result PirateJoe	by ExcelBanter AI	6	9,481
how do I identify statistical outliers with excel? [email protected]	by ExcelBanter AI	8	8,947
what is 11" X 17" paper size called in excel page setup? Jeremy	by ExcelBanter AI	4	8,936
Toggle show / hide group outline symbols with shortcut Ted M H	by ExcelBanter AI	7	8,964
IF a cell contains specific text Christine	by ExcelBanter AI	6	8,955
VBA how to check if entire row is selected? Jack Sons	by ExcelBanter AI	6	9,259
How do I make one column or row always visible? Ao	by ExcelBanter AI	8	9,089
'07 Large Operation Error (Delete / Insert Rows and/or Columns) Elgee	by ExcelBanter AI	4	9,399
set area in excel not giving me option to set print area? J Littlebear	by ExcelBanter AI	4	8,889
Formula for the LESSER of 2 Calculations Bonnie	by ExcelBanter AI	5	8,974
I press "enter" but it doesn't move to next row down. NickDewees	by ExcelBanter AI	2	8,935
Mystery text box I can't edit GaudiGill	by ExcelBanter AI	6	9,194
no row numbers or column letters DISPLAYED RagDyer	by ExcelBanter AI	4	8,801
How can I insert rows BELOW, in Excel Scott	by ExcelBanter AI	2	8,726
remove macros, ActiveX controls, XML expansion pack info, or web c Justin	by ExcelBanter AI	2	8,742
Automatically convert Text with 2-digit year juniper810	by ExcelBanter AI	3	8,978
record macro "That name is not valid." highlifesipper	by ExcelBanter AI	5	9,537
Data Validation - allowing only negative numbers or converting Courtney	by ExcelBanter AI	14	9,380
AVERAGE using LOOKUP, INDEX, or MATCH DoooWhat	by ExcelBanter AI	5	8,888
How to I filter one list based on another list? Erlend	by ExcelBanter AI	3	8,795
Abbreviate [Number] Billions to [#] Bn Jarod	by ExcelBanter AI	4	9,172
VBA check if date is in future Horatio J. Bilge, Jr.	by ExcelBanter AI	6	8,743
Removing spaces from middle of cell TJAC	by ExcelBanter AI	6	8,636
how do I hide part of a column Wayne	by ExcelBanter AI	6	9,223
How to hide and show a grouped column via VBA code? Michiel via OfficeKB.com	by ExcelBanter AI	3	8,886
how to change when week starts on excel Savio	by ExcelBanter AI	2	8,726
Is it possible to change the default number format in Excel? Andrew	by ExcelBanter AI	5	8,640
I want to replace all "<br" with a new line character. Balaji	by ExcelBanter AI	3	9,724
VBA to hide a row in different worksheet TDC	by ExcelBanter AI	3	8,996
Filter seems locked SShelton	by ExcelBanter AI	3	8,578
Merge vertically ? bbelly	by ExcelBanter AI	9	8,642
Keyboard Shortcut to move to top of column in worksheet? piddilin	by ExcelBanter AI	6	8,782
Align Left and Right in Same Cell Sloth	by ExcelBanter AI	6	10,093
What does the exclamation point on my MS-Excel file icon mean? JS Puskar	by ExcelBanter AI	2	9,152
MATCH() on a 2D array? Geoff Lambert	by ExcelBanter AI	7	8,710
Print titles must be contiguous and complete rows or columns Michelle	by ExcelBanter AI	4	8,626
Quartile and multiple if jhicsupt	by ExcelBanter AI	8	9,871
Copy Visible Cells in Sheet with Merged and Hidden Cells rtwiss	by ExcelBanter AI	5	9,185
Converting Identification Number to Birthday WildWill	by ExcelBanter AI	5	8,607
Centering a picture in a worksheet jfg	by ExcelBanter AI	5	9,502
how to keep track of work hours and my tips kmh11	by ExcelBanter AI	3	9,056
how can I calculate chronological age in excel Mike New	by ExcelBanter AI	7	8,685
Average Every Second Column Killer	by ExcelBanter AI	16	9,546
How to get rid of embedded grey squares over cells crossroads	by ExcelBanter AI	3	9,379
I want to print comments and the section is greyed out CRUGER	by ExcelBanter AI	3	8,681
using countif function to add only a half of a number ryanjh79	by ExcelBanter AI	9	9,559
Get cell's number format category in VBA? dyowee	by ExcelBanter AI	8	8,484
Subtotals not grouping? dlw	by ExcelBanter AI	4	9,512
Today's Date in MS Query Lambi000	by ExcelBanter AI	4	8,867
Can I split 1 cell into 2 cells in Excel? Chalky	by ExcelBanter AI	6	8,513
Generate date on Semi-Monthly Basis debinnyc	by ExcelBanter AI	6	9,810
Select text before carriage return jellyroller	by ExcelBanter AI	3	9,602
Using IF statements with a drop-down list Steve Jamison	by ExcelBanter AI	3	8,426
Cannot get VBA to Change PageSetup.FitToPagesWide = 1 EagleOne@microsoftdiscussiongroups[_2_]	by ExcelBanter AI	6	9,257
Turn off "Format as Table"? RNW	by ExcelBanter AI	4	8,464
I am looking for formula to calculate escalation on construction Ronnie	by ExcelBanter AI	2	8,853
Subtract 12 hours from date/time Cindy	by ExcelBanter AI	8	8,350