Excel Discussion (Misc queries) - Page 18

Thread / Thread Starter	Last Post	Replies	Views
How do I make the drop-down portion of a list wider than the cell? jtjlindsey	by Gord Dibben	2	5,757
Print "freeze panes" on succeeding pages? kdhelm	by OneCosmicGuy	8	5,755
Sorting: Sorting by the First Character dzuy	by Kevin B	2	5,755
How to remove password protect to open Excel 2007 workbook JoWrobs	by Gord Dibben	3	5,755
A formula in this worksheet contains one or more invalid reference Feejo	by Feejo	5	5,748
How to create "stop lights" as drop down box options? Secretary	by L. Howard Kittle	3	5,746
Setting default pivot table field setting to "sum" Mr. Moose	by Mr. Moose	2	5,745
Excel 2007 - Can't scroll thru worksheet aadmora	by GS[_6_]	21	5,744
Formula omits adjacent cells error message Nevets	by Gord Dibben	4	5,740
move data that occupies multiple rows/columns into one row LizE	by [email protected]	5	5,739
A Bank Statement Reconciliation template slidergirl1	by RagDyeR	1	5,737
Problems between Hyperion Smart View Add-in and Excel Wes	by Wes	0	5,733
Can't see cell information in excel but it is in the formula bar MPTL06	by MPTL06	5	5,726
Excel 2007 AutoFit Row Height not working KristinQ	by Gord Dibben	5	5,726
create a message box when opening a file in word or excel 2007 David	by Jacob Skaria	1	5,715
Setting of input cells as blue font and formula cells as black fon Sunnyskies	by Florida User	2	5,715
What does a blue row number means? Turquoise_dax	by Gord Dibben	2	5,715
Sort on column that uses countif function Rookie_User	by Rookie_User	4	5,713
Text Import Wizard (use for large files) Traci	by Jim Cone	2	5,706
Named Range Limitations Bagia	by Gord Dibben	8	5,705
Dependent Data Validation with Illegal Characters hjneedshelp	by GS[_6_]	10	5,703
Run VBScript from Excel Amy M	by Amy M[_2_]	4	5,703
1 Page for every CELL!! Naomi	by Dave Peterson	5	5,703
create a formula to muliply hours times dollars per hour? sirrafs	by Biff	1	5,702
F9 vs. Calculate Sheet No Name	by Earl Kiosterud	3	5,699
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis Graham	by daddylonglegs	2	5,698
How do I encode data in Excel to make it anonymous? Aiso	by DennisS	2	5,697
How to put + sign in cell, not formula? slp2b	by David Biddulph[_2_]	1	5,690
lost auto sum button Achelle	by OssieMac	2	5,689
how to use the IF formula with a range of cells JohnD	by CC	4	5,687
remove all characters before a certain one Imajica12345	by Jacob Skaria	7	5,684
Group adjacent columns independently Tigerxxx	by Tigerxxx	3	5,678
PivotTable field name is not valid - cannot create shineOn	by Debra Dalgleish	1	5,671
Hoping to disable Protection Warning message NFaye	by Eagle1468	4	5,669
How to Reduce value in a column by 5%? capxc	by capxc	11	5,666
First Derivative Chetan	by Chetan	4	5,665
Funciton to subtract and add a digit to an IP address format? mcmilja	by Ron Rosenfeld	6	5,661
How to insert page break after every 10 rows? kativa	by kativa	2	5,659
Wingding character map David	by James Silverton[_3_]	4	5,657
Is there a loan amortization schedule with balloon at final pmt? Dommerdog	by Fred Smith[_4_]	4	5,657
how do i calculate a 4 week rolling average Charliechoo	by Dave O	1	5,655
Insert Hyperlink button disabled in Excel [email protected]	by Gord Dibben	4	5,653
Make Cell behave Like Word Ian8276	by Gord Dibben	2	5,651
How can I make random selection from excel list? DD	by Biff	2	5,650
convert julian date to gregorian date ammaravi	by Frank Kabel	1	5,649
how do I create qif files from Excel for import into Quicken? pb	by David McRitchie	2	5,647
How to format a phone number in Excel tfanatik	by CLR	4	5,645
Auto fill column with sequential numbers with decimals Dogstar	by Mike H	2	5,645
CountIf using every other column duketter	by T. Valko	3	5,640
How do i remove "mark as final" Shane Devenshire[_2_]	by Shane Devenshire[_2_]	0	5,637
Macro to run on selected sheets terilad	by Stefi	18	5,632
transfer data from one column into another column Wessel	by Gord Dibben	5	5,629
How can I remove the tax from a total to get the pre tax value ? David	by David	5	5,629
Bar chart with broken or jagged line on Y-Axis [email protected]	by [email protected]	2	5,626
Apply different color themes to worksheets withing a workbook kdarrow	by GS[_2_]	2	5,626
Sequential dates across worksheets Mick B	by Gord Dibben	4	5,624
unlinking formulas from cells jcontrer	by James[_4_]	2	5,623
Clear Option Button Selections Jenny B.	by Jenny B.	3	5,622
How do I calculate escalation rates using dates and a set value KenSouthfield	by KenSouthfield	0	5,622
Simple Check Box - without True/False values Lisa	by Lisa	5	5,621
Removing comments in a pivot table CMEknit	by trip_to_tokyo[_3_]	1	5,613
Insert multiple hyperlinks at same time AmyO	by jackie treehorn[_2_]	2	5,611
Cronbach Alpha Stevieray	by Stevieray	4	5,610
How do I stop auto creating .TMP files in EXCEL? Shoe70	by Dave Peterson	1	5,608
autocorrelation function MOO	by Jerry W. Lewis	3	5,605
How to convert half hourly data into hourly kippers	by kippers	5	5,602
Cursor has permanently changed to fat white plus sign and... Norman Levinson	by Earl Kiosterud	1	5,599
using OFFSET(INDEX(MATCH))) Dave F[_2_]	by Peo Sjoblom	3	5,595
Need formula to extract a numeric value from a free-format text ( 1 2) Eric_NY	by Ron Rosenfeld	47	5,595
How should I make the cell lines disappear in Excel? Ganesh	by Gord Dibben	3	5,594
WANTED: Excel template for loan payment record with random/irregular payments cassidy	by Dave O	1	5,592
How do I include a date input box in a macro? Project Mgr	by Jim Thomlinson	6	5,588
How do I start a new paragraph in a merged cell? cruzr	by KIM W	3	5,581
draw revision cloud sarvesh	by Mike H	1	5,580
Help deleting equal credits and debit columns Neo	by Pete_UK	8	5,576