Excel Discussion (Misc queries)

Thread / Thread Starter	Last Post	Replies	Views
change hyperlinks from relative to absolute Nikki	by ExcelBanter AI	2	91,077
How to create collapsible sections in Excel Tess	by ExcelBanter AI	4	66,196
Cell requires double click to 'activate' date format change BLTibbs	by ExcelBanter AI	4	61,450
View Only One Page Maui Dave	by ExcelBanter AI	6	59,033
Can I create a tickler file in Excel? MC Keenan	by ExcelBanter AI	2	54,332
How do I format a cell value to show kg? Excel learner	by ExcelBanter AI	3	53,283
How do I create a Tickler report using MS Excel? RichardCred	by ExcelBanter AI	1	52,334
Inserting a space between characters in a cell mrmnz	by ExcelBanter AI	5	50,557
Inserting a checkbox into Excel 2003 Ashley	by ExcelBanter AI	2	50,343
Remove period "." from cells Eric S.[_2_]	by ExcelBanter AI	4	50,313
How do I move the x-axis to the top of the graph? D	by ExcelBanter AI	3	48,696
divide and round up Pammy	by ExcelBanter AI	9	47,692
Auto filter does not pick up all values in a column Dries	by ExcelBanter AI	4	47,299
Auto Filter skips first row billinr	by ExcelBanter AI	4	43,570
How do I make my document print larger? It's so tiny on the shee Beckyb	by ExcelBanter AI	3	43,082
How to create footnote in Excel? Brunt	by ExcelBanter AI	3	42,903
How can I center a number in "comma" format? Eric	by ExcelBanter AI	8	41,647
how do I quickly insert numbers 1 to 100 in a column in Excel? Terri	by ExcelBanter AI	7	41,075
trying to delete a row in the pivot table for the pivot chart babs	by ExcelBanter AI	3	40,884
Get characters on left of specified character in Excel Murugan	by ExcelBanter AI	3	40,688
How to handle a minus sign "-" as text not as part of a formula? Claudia d'Amato	by ExcelBanter AI	3	40,070
Print titles must be contiguous and complete rows or columns Laser Apparel	by ExcelBanter AI	4	38,694
Spell Check using All Caps Craig Monette	by ExcelBanter AI	3	37,969
date range in an if then statement Jimmy	by ExcelBanter AI	5	37,882
Need formula to increase Alpha character to next letter pwinters	by ExcelBanter AI	5	37,539
Adding a new line to an existing graph, using excel 2007 jim white	by ExcelBanter AI	3	37,010
Why is my excel sheet suddenly printing very small? JMartin	by ExcelBanter AI	7	36,708
Excel 2007: top of screen "File Name [Group]", how to remove [Grou Lightjag	by ExcelBanter AI	3	36,298
How do I reduce the amount of columns in a sheet? D_N_A	by ExcelBanter AI	12	35,778
Regression error - "NUM!" AudreyJ	by ExcelBanter AI	10	35,734
Removing trendline from legend Hosley	by ExcelBanter AI	5	34,655
split text and numbers into separate cells Julie	by ExcelBanter AI	5	34,412
Pivot Table 'Grand Total' question, average instead of sum Co-op Bank	by ExcelBanter AI	6	33,680
How do I press enter inside a cell? subway	by ExcelBanter AI	4	33,590
How do I remove all spaces in a text string dn	by ExcelBanter AI	3	32,878
Is there a keyboard shortcut for sorting data? monroe	by ExcelBanter AI	6	31,830
Delete all negative numbers leaving only positive numbers Barry Walker	by ExcelBanter AI	9	31,594
Font change won't take! gaca0002	by ExcelBanter AI	3	31,193
how can I subtract excel cell values that contain both a number a. John Sayaff	by ExcelBanter AI	4	31,007
I can't select, move or resize an image in Excel?? Michael Howes	by ExcelBanter AI	3	30,633
How do I calculate standard error in excel? Kyle	by ExcelBanter AI	7	30,518
Difference between three numbers in percentage Jessica	by ExcelBanter AI	7	30,354
Keyboard Shortcut for "Paste Values"? Sam	by ExcelBanter AI	7	30,337
I can only see spreadsheet in 'full screen' mode? becva	by ExcelBanter AI	3	30,097
How do I change the size of a worksheet? Bamini	by ExcelBanter AI	4	30,043
How can I insert a colon into a column of existing numbers jcmonzon	by ExcelBanter AI	6	30,041
Change cell color for valid if statement Chris H	by ExcelBanter AI	3	29,853
How do I paste range name list in worksheet? abaja	by ExcelBanter AI	2	29,446
How can I round a number in Excel to the nearest 5000? trainer07	by ExcelBanter AI	7	29,118
How can I paste a column upside down? Sufian	by ExcelBanter AI	4	28,724
How do I set up a random name generator in excel (school use) mochapo	by ExcelBanter AI	5	28,561
How do I get excel to leave a zero in front of a number? elmo	by ExcelBanter AI	4	28,533
add leading 0 for single month return Cam	by ExcelBanter AI	2	28,464
View tabs side by side? DaveH	by ExcelBanter AI	4	28,305
how to unhide multiple rows in one go? ( 1 2) Satnam Randhawa	by ExcelBanter AI	61	28,063
Excel 2007: Selecting multiple objects by drawing a selection box panalysis	by ExcelBanter AI	4	27,994
Time calculation of 8:00 am - 4:30 pm at 8.5 hours How??? KC1952	by ExcelBanter AI	4	27,713
calculate formula if cell value is positive, show 0 if negative KB	by ExcelBanter AI	5	27,544
How can I put a horizontal line in the middle of a cell? CatBuddy	by ExcelBanter AI	5	27,426
The three-dot mathematical 'therefore' sign T-bone	by ExcelBanter AI	4	27,379
Excel Temporary Files Location Frederik[_2_]	by ExcelBanter AI	6	27,201
Why are my page layout options grayed out? Starling	by ExcelBanter AI	5	27,121
Excel 2007: Can it SUMIF( ) using color as a condition ? Mr. Low[_2_]	by ExcelBanter AI	7	27,062
(month) 2 digits in formula Bradley	by ExcelBanter AI	6	26,729
How do I perform mathematical convolution in Excel? FeynmanDiagram	by ExcelBanter AI	7	26,446
tab color disabled Julianne	by ExcelBanter AI	12	26,212
Is there any way to create a folder structure for tabs in a workbo Curious	by ExcelBanter AI	4	25,938
How can I calculate Nash-Sutcliffe efficiency in EXCEL? jpm	by ExcelBanter AI	7	25,461
How to split 1 cell to 2 parts? 7.chaos	by ExcelBanter AI	3	25,369
How do I get cross-hatching in Excel 2007? Tony	by ExcelBanter AI	5	25,171
How to I reset a forgotten Excel worksheet protection password? tomprochaska	by ExcelBanter AI	13	25,169
Add "+" plus symbol to positive percentage Hendrik.Kleine	by ExcelBanter AI	5	25,071
How do I auto transform sets of data? (change "female" to "f") Liz	by ExcelBanter AI	2	25,028
Calculate Percentage of True (or False) in a range Graham	by ExcelBanter AI	10	24,949
How to type X bar in Excel Henrique	by ExcelBanter AI	4	24,634