I need to set up a footer in the following way:
File Name                             page # of #                            
Date & Time
I use this format in Excel and Word and I cannot get it set up in 2007

I have a new spreadsheet that I created entitled "Evaluation Outcomes", and
I'd like to copy and paste it into an existing spreadsheet (entitled Master
Database-different book), however when I attempt this I get a message
advising me that data on the clipboard is not of the same ...

Is it possible to open a password-protected excel spreadsheet from a link on
our website?  What I am trying to do is permit people with the proper
password to access the file from our web site link.  When you click on the
link to open the file, doesn't even open the dialog box ...

How can one derive a random number from a specifc array, for example a random
selection from {2, 4, 16, 256, 65536}

I am trying to use a formula or script to take the data from Sheet two column
C to sheet one given certain criteria in sheet one column A and sheet two
columns A and B.  Below are the two sheets along with what sheet one should
look like after.  This is for a rather large range ...

Good Morning All, XL2007
I have a basic PT summing values across a row of months
   A                    B                 C                D
Overheads         10                10               10

I have a budget set up and I want highlight the name of the bill once a
actual cost of the bill has been paid to know if the bill has been paid...
What is the best way to do this?  Please list the steps so I can duplicate
it in my spreadsheet.

I have a spreadsheet I use to assign our committee audit areas.  The same
group of people is rearranged and put into the other columns (per month).  It
is rearranged in no particular order, but I attempt to ensure that the same
person does not have to audit the same area two ...

How can I remove leading blanks from all cells in a selected column. I prefer
not to use a function because I prefer not to have to create another column.
Macro or FIND/Replace would be best if possible

when you click on a cell it puts a thick black line around the
cell.......what is that called and can the color be changed?

I need the ability to look data across multiple worksheets.  In essence, I
need something like VLookup or HLookup, but I need a 2-dimensional search
across (a) a given row or column on one worksheet and (b) the same row/column
in each worksheet in a defined group --, rather than ...

I've got a file with 700 lines and when I wanna print the selected area  in
a filter mode ,what comes out is in different pages . I can see some dashed
lines in the filtered area showing different pages.In the "page break
preview" there are also a couple of solid blue lines ...

sorry to post twice- but not sure where this question belongs...I have a
column of mixed format.... some numbers and some are brought in as
numbers stored as text.  I need to apply a date format of mmddyyy
however, when I apply to column, the values that were numbers stored as ...

I have an excel table which has old and new values for Vendors
So my excel file looks like this- It actually has about 5000+ values:
Old Vendor ID                New Vendor ID
ADPINC00                    ADPEAS00'

I tried "cpearson" Dynamic Ranges
=OFFSET(Spend Rates!$L$5,0,0,COUNTA(Spend Rates!$M:M),1)
to create a dynamic range in Column L starting at row 5.
It appeared in a list for editing, but didn't appear in the Name Box drop