General
in [Excel]
|
Can you only merge up to a certain number of cells I am working on microsoft excel 2003, I have a sheet that I merged cells starting with line 8 through 43...when I type my information in the merged area I can see all that I am typing...say it goes up to line 30 once I hit the enter key I can only see up to line 20. Even when I print it out it only prints up t... 19 May 2010 17:10
Error on text wrap pivot table Is there a limitation with wrapping text within pivot tables? I have a pivot table report that goes from column A to column BC, but find I can't wrap any text fields after column AF - my worksheet blows up after column AF and goes into repair mode. NOTE: I can wrap text for any columns from A to AF. This ... 19 May 2010 14:55
error bar cap style I am attempting to use different error bar cap types on 3 series plots on one chart. Afterselecting round or square and closing the dialog box, the cap type does not change. I only get flat caps. Is this a flaw in the software? will it be fixed? ... 19 May 2010 14:55
VBA Editor Menu Bar and Toolbar disappears Sometimes when I am using the VBA Editor, the view changes, making the Toolbars and Menu Bar disappear. What can i do to prevent this from occurring, and how can I get back to a normal view, other than closing it out? Also, if i open the VBA Editor, and then close it, it will reopen on its own. Can this be prevent... 19 May 2010 13:48
Quick formula help please Have I missed something here? =IF(E13>0,"early",E13<0,"late") Cheers!! ... 20 May 2010 09:28
formula with {} I have a formula that shows as: {=A5-INDEX(A5:A400,MATCH(TRUE,K5:K400>0,0))} It works but I want to change it to: {=A5-INDEX(A5:A400,MATCH(TRUE,J5:J400>B6,0))} Problem is that when I click to edit the formula, the {} brackets disappear and then the formula returns $VALUE!. Why do these brackets show up and... 19 May 2010 14:55
How do you hide/un-hide the grid lines I have a document that I created and want to hide the grey grid lines, but want to be able to unhide them. How do I do this? ... 19 May 2010 13:48
Invisible Black Box is Printing I have a 2007 workbook I receive from an outside vendor. I am running 2003. When I open the workbook Sheet1 looks fine, but in Print Preview and when I print the sheet several black boxes appear and obscure the data. I have tried using GoTo|Special|Objects, using Select Objects from the Drawing Toolbar, and del... 19 May 2010 14:55
Time difference across midnight I have read all the other threads on this subject and they work fine for me untill I need to cross midnight and the value is the time subtracted from 24 here are the cells: Date Store Actual Arrival Time Est Arrival Time Variance 4/6/2010 33369 11:26:00 PM 12:27:00 AM -22:59 Can someone let me know what I have m... 19 May 2010 22:42
SUM IF: How do I sum the data in a column based on 2 other columns Can someone help me? I would like to know how to total the # of persons who have "Scheduled Appointments" and need "Housing Assistance. I am extracting this data from a separate spreadsheet in the same work book titled "May" & would like it to appear on my Calculation SS. ColD ColE ... 19 May 2010 16:03 |