I have a spreadsheet that will be accessed by multiple users. Each user will fill out a row of data, save and close the spreadsheet. We do not want users to...

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...

If I have created a pivot table and later add more rows of data to the main sheet (which the pivot table was created from), is there a way to update the...

Excel2003 ... Range C7:C272 contains Dates format = mm/dd/yy (& empty cells) Looking for 3 Formulas for dates occuring as follows: Cell C275 ... Count Dates...

I am creating a calendar with a "graphical" calendar display on one tab and a list display on another. I have populated the "graphical" calendar tab by...

Apparently using Excel 2003, I have exceeded using 512 fonts. Although I have only used 1 font in the workbook containing many charts (32) in several...

We are working on an speadsheet, I was emailed a copy of it and so was two others. How do we go about update if we each have a copy of the orginal and we are...

I work in a school. I have imported data into an Excel spreadsheet which contains student courses and grades. I need to print one label for each student...

In Excel 2007, in the formulas Tab, there is an option called "Show Formulas". When I check this option all formulas in the sheet are shown. Is there a way...

You probably want something like: =Est-Actual+(EstActual) --ron Thanks Ron, That helped but I have another problem when it is a negetive it goes...

i have a data address data in 3 columns like door no. in one, street no in another & city name in another column. shall i get all these address in a single...

Hi, I have 6 different investigation area, one single name each, and I would like to set 6 different conditional formatting. But I'm not able to set more...

I have a formula that shows as: {=A5-INDEX(A5:A400,MATCH(TRUE,K5:K4000,0))} It works but I want to change it...

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...

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...

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...

I am using Excel 2002. I have defined a dynamic data range and am using it in a pivot table, which works OK. I have added a new column to the data range, but...

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...

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?