When one of my teachers, running Windows XP Professional and Office 2003, double clicks an Excel spreadsheet file, it opens Excel but not the file. She has...

Hi I am trying to write a formula that has a few criteria and results. I need a formula in cell K7 (2005): if cell D6 = "Off" and E6 = "2005" to return a...

I have a pivot table with the date (8/1/2009 - dates always are the first of the month) currently in columns. I would like to only see the current month. I...

I am using a workbook with 60 tabs. If I do something in a cell on 1 tab & move to another tab not anywhere close to that one, is there any command that...

Is there a problem with the site at the moment as the posts that I see are all dated Oct 13th and before (not after)? Thanks in advance for any replies.

I have both Excel 2003 & 2007 on my desktop. I want Excel 2003 to open when I open an excel file but 2007 always overrides 2003. How can I reset

I am trying to enter the letter "c" in parenthese, but Excel will only show the "copyright" logo (C). How do I enter the following: ( c ) , and not end up...

I want to use a 'tick' symbol in a spread sheet recording attendance. I would like to then total the number of ticks in a row. How do I get Excel to give...

I have ten or so pages in a book. on onme page there is the headings to a sheet called photo stock (item,cat,size,stock,ordered,sold) on another page called...

I have a matrix of numbers: a1 b1 c1 d1 a2 b2 c2 d2 a3 b3 c3 d3 I'd like to divide each of the values in this matrix by a particular number that...

I have some part numbers (see examples below) that contain hypens that I need to remove for approx. 800 records. If I edit the cells and remove the hypens...

Is there any way to change the maximum amount of numbers that you can put in a particular cell. I have users that are using Excel for Tracking numbers and...

I have a workbook that contains 1 "master sheet" of Personnel data and 30 other sheets for individual line managers. The individual line manager sheets...

using 2007, I can use teh fill handle to fill in a series of days or dates. However the fill series dates does not perform any function when accessed from...

I just want to go to a certain row that contains data meeting certain criteria. (Example: =h3). How do I do this?

The format that another application spits out is one that I would like to make user friendly. Here is an example of what I am looking at: WELL: 5122110000 ...

Can someone show me how to make label where my data in excel look like NO NAME ID PHONE1 PHONE2 EMAIL ADDRESS1 ADDRESS2 ADDRESS3 1. xxxx ...

I have a text cell containing text with an apostrophe, and to the right of it another text cell containing a numeric digit. The right cell has a small green...