I've saved three worksheets and know their passwords but Excel won't let me
in.  Please can you tell me a route?

Hi,  Does anyone know who to resolve this problem?   Every time I do a
formula it automatically adds a $ to the column and row reference so that
the formula looks like this:  =sum$H$7.   I am having to use the “replace” to
remove the $.     Somehow I turned on this method and I ...

I am trying to calculate how much time it takes, in hours and minutes, to
process a transaction when the start time occurs on one day and time and the
end-time occurs a day or two later. The processing time needs to exclude
weekends and non-working hours.

Is Excel 2007 smart enough to do this?
I have an instance where I need conditional formatting set up for a cell
whose condition is based off of another cell.
But the second cell with the condition is a not a simple number or percentage.

I have a work sheet that has 4 radio buttons that help users choose one of
the following:
=IF(B12=TRUE,I8,0)
=IF(B13=TRUE,I8,0)

I have a 2003 spreadsheet that lists these column headers
LastName Firstname Grade NumberOfTardies
Each student has a row for each quarter, regardless of the number of
tardies the student received.  So, Billy Thompson's would look like

I'm stuck.  I want to have a procedure which will use data from one
page and write it on another page in different relative locations
I have page 1 looks like this:
Name   Job Desc.  Status ......  Reg Base  ...  RegFringeBenefit

Can anyone advise me how to best lay out my worksheet. I need to record
daily, weekly & monthly figures & times . Each days info takes up alot of
space so I have given every day a new sheet & made a weekly summary sheet at
the beginning , but that only gives me 1 week out the ...

I've written a user-defiend function, meant to be called from a cell via "=",
have put it in an .xla file, have loaded the .xla via Tools | Add-Ins, but it
is not visible to the cell unless I include the module's name.  The formula
box "sees" it but doesn't interact with it:

I have autofilter engaged.  When I choose a filter from one of the columns,
I'd like to conditionally format the column to show in a color to further
denote it is the one currently on filter option.
Formula?

I somehow lost me Personal Macro collection. I am wondering how to create a
new project so I can name it and start creating modules.
Thank you.

Is VLOOKUP function capable of looking at two criteria in the fields and
return the value? If yes, how to put in the code or if not is there any other
way to achieve this? Thanks
Sample:

I have a worksheet that I use every week at work that requires a column to
have either a + or a - in it.  I've changed the formatting for this column to
general, text and even special.  It always wants to add or subtract from
whatever cell I click next.  I've spoken to a couple ...

Is there a way to have the grand total do something different than group
totals? For example:
ClockNo    Target               Date
040                                  02/02/08     04/02/08     05/02/08    

Is there a shortcut key assigned to creating a pivot table?
Example the chart can be created by selecting the data and pressing F11 key
which takes all the default settings and creates a new column chart in a new
sheet!!