Excel Discussion (Misc queries) - Page 18

Thread / Thread Starter	Last Post	Replies	Views
Print "freeze panes" on succeeding pages? kdhelm	by OneCosmicGuy	8	5,765
Setting default pivot table field setting to "sum" Mr. Moose	by Mr. Moose	2	5,765
Drop Down list with Code Description [email protected]	by Otto Moehrbach[_2_]	4	5,765
Calculate a date based on birthdate and future age AMcShea	by AMcShea	4	5,762
Sorting: Sorting by the First Character dzuy	by Kevin B	2	5,762
How do I make the drop-down portion of a list wider than the cell? jtjlindsey	by Gord Dibben	2	5,761
To Find Unmatched data in a Column Himani	by Himani	4	5,760
Excel 2007 - Can't scroll thru worksheet aadmora	by GS[_6_]	21	5,759
autocorrelation function MOO	by Jerry W. Lewis	3	5,757
How to substitute a comma with a newline char using Replace. edspyhill01	by Dave Peterson	9	5,757
How to remove password protect to open Excel 2007 workbook JoWrobs	by Gord Dibben	3	5,756
Formula omits adjacent cells error message Nevets	by Gord Dibben	4	5,754
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis Graham	by daddylonglegs	2	5,754
A formula in this worksheet contains one or more invalid reference Feejo	by Feejo	5	5,754
How to create "stop lights" as drop down box options? Secretary	by L. Howard Kittle	3	5,750
Dependent Data Validation with Illegal Characters hjneedshelp	by GS[_6_]	10	5,739
move data that occupies multiple rows/columns into one row LizE	by [email protected]	5	5,739
Can't see cell information in excel but it is in the formula bar MPTL06	by MPTL06	5	5,737
Excel 2007 AutoFit Row Height not working KristinQ	by Gord Dibben	5	5,736
Problems between Hyperion Smart View Add-in and Excel Wes	by Wes	0	5,735
See Data behind Pivot Table Deadnskinny	by Deadnskinny	2	5,734
Setting of input cells as blue font and formula cells as black fon Sunnyskies	by Florida User	2	5,730
Sort on column that uses countif function Rookie_User	by Rookie_User	4	5,718
create a message box when opening a file in word or excel 2007 David	by Jacob Skaria	1	5,716
What does a blue row number means? Turquoise_dax	by Gord Dibben	2	5,715
vertical scroll bar goes too far? ScottSabo	by ScottSabo	2	5,714
Text Import Wizard (use for large files) Traci	by Jim Cone	2	5,712
create a formula to muliply hours times dollars per hour? sirrafs	by Biff	1	5,711
1 Page for every CELL!! Naomi	by Dave Peterson	5	5,708
Named Range Limitations Bagia	by Gord Dibben	8	5,708
Run VBScript from Excel Amy M	by Amy M[_2_]	4	5,704
F9 vs. Calculate Sheet No Name	by Earl Kiosterud	3	5,702
lost auto sum button Achelle	by OssieMac	2	5,701
If Function with multiple variables Fritz	by Fred Smith[_4_]	2	5,700
How do I encode data in Excel to make it anonymous? Aiso	by DennisS	2	5,698
How to put + sign in cell, not formula? slp2b	by David Biddulph[_2_]	1	5,697
Group adjacent columns independently Tigerxxx	by Tigerxxx	3	5,691
remove all characters before a certain one Imajica12345	by Jacob Skaria	7	5,689
how to use the IF formula with a range of cells JohnD	by CC	4	5,688
WANTED: Excel template for loan payment record with random/irregular payments cassidy	by Dave O	1	5,679
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,671
remove advanced filter on a spreadsheet Maureen	by Mike H	1	5,668
First Derivative Chetan	by Chetan	4	5,666
How to Reduce value in a column by 5%? capxc	by capxc	11	5,666
Calculate pay periods between two dates if paid on 1st and 15th? janplan	by Joel	2	5,664
Is there a loan amortization schedule with balloon at final pmt? Dommerdog	by Fred Smith[_4_]	4	5,664
TOOLBAR button or Keyboard Shortcut FOR Center Across Selection?? RajenRajput1	by Gord Dibben	13	5,663
Funciton to subtract and add a digit to an IP address format? mcmilja	by Ron Rosenfeld	6	5,663
how do i calculate a 4 week rolling average Charliechoo	by Dave O	1	5,661
How to insert page break after every 10 rows? kativa	by kativa	2	5,661
convert julian date to gregorian date ammaravi	by Frank Kabel	1	5,658
How to convert half hourly data into hourly kippers	by kippers	5	5,658
Wingding character map David	by James Silverton[_3_]	4	5,657
how do I create qif files from Excel for import into Quicken? pb	by David McRitchie	2	5,657
Auto fill column with sequential numbers with decimals Dogstar	by Mike H	2	5,655
Insert Hyperlink button disabled in Excel [email protected]	by Gord Dibben	4	5,655
Make Cell behave Like Word Ian8276	by Gord Dibben	2	5,652
How can I make random selection from excel list? DD	by Biff	2	5,651
Arrow Keys Not Working In Excel Randy	by Randy	3	5,648
Need formula to extract a numeric value from a free-format text ( 1 2) Eric_NY	by Ron Rosenfeld	47	5,647
CountIf using every other column duketter	by T. Valko	3	5,646
How do i remove "mark as final" Shane Devenshire[_2_]	by Shane Devenshire[_2_]	0	5,643
How can I remove the tax from a total to get the pre tax value ? David	by David	5	5,639
Removing comments in a pivot table CMEknit	by trip_to_tokyo[_3_]	1	5,639
Macro to run on selected sheets terilad	by Stefi	18	5,636
Bar chart with broken or jagged line on Y-Axis [email protected]	by [email protected]	2	5,633
How can I crop the unwanted rows of a worksheet please. RORY	by Dave Peterson	2	5,630
unlinking formulas from cells jcontrer	by James[_4_]	2	5,629
Simple Check Box - without True/False values Lisa	by Lisa	5	5,629
Clear Option Button Selections Jenny B.	by Jenny B.	3	5,628
Sequential dates across worksheets Mick B	by Gord Dibben	4	5,628
Apply different color themes to worksheets withing a workbook kdarrow	by GS[_2_]	2	5,627
How do I calculate escalation rates using dates and a set value KenSouthfield	by KenSouthfield	0	5,627
Insert multiple hyperlinks at same time AmyO	by jackie treehorn[_2_]	2	5,612