I've lost my link the the Mac Office / Mac Excel discussion group, can anyone
point me in the right direction?
TIA

Does anyone know if there is a shortcut key on the MAC which duplicates the
F9 key when one is in the Edit mode - On the PC this key converts the formula
or portion of the formula to a value.  For example, if you highlight the
TODAY() portion of the formula =TODAY()+7*ROW(A1)-7 ...

Is there a formula I can put on a worksheet that picks up the values from the
last row entered in the previous sheet, changing as rows are added.
In other words, this forumla in A1 of sheet 2 would show the value of A20 in
sheet 1 until values were put into A21, then they would ...

I frequently get large spreadsheets (1000's of rows) where a few rows here
and there will be highlighted by changing the background color to something
other than white.  Is there a way to filter the rows on background color,
analogous to the way rows can be filtered by cell ...

Column A:        Column C:
row1:   V001                Done
row2:   V001                O  1234
row3:   V001                O  2345

This problem involves more of algebra and geometry. I rely on excel to
perform some calculations.
I have two parallel slopes (+'ive) and two slopes which is
perpendicular to these two slopes (-'ive). This design makes a

I find the dark gray page number indicators (Page 1, Page 2, etc.) that
appear on spreadsheets visually obstructive. Is there any way to remove them,
or at least change their appearance, say to a lighter shade of gray, if they
can't be removed?

Good afternoon, I tried most of all that was posted on double VLOOKUP but had
no sucess.
My Chart Looks Like this:
Sheet 1,

PLEASE
Could some one direct me to where I could find Excel keyboard shortcuts
With appreciation
Jerry

I have the following file:
Sheet1
    February to
Style #    date Revenue ($)

Does anyone know if it is possible to allow predetermined users to open an
Excel file without them having to use a password?
I've password protected a file and given out the password to a select few.  
Unfortunutly, some people shared the password with others making the security

I have office 2007. Today I opened a templete made some changes and saved it
with an updated name. Now every time I try to open the file I get the message
"Excel cannot open the file 'Estimator 5.22.07.xltm' because the file format
of file extension is not valid. Verify that the ...

Hello out there
I'm using the following code which works really well except that each time
it loops around it keeps adding the next attachment. What I want it to do is
to send one email with the first attachment, then send the second email with

I have a series of forms that gather information and save it to various sheets.
Each form needs to save this information to protected sheets, I use
       ActiveSheet.Unprotect "xxx"
When I open the form and then close it with

Most macros I have created (and set up a button for on my toolbar) work just
fine.  However, occasionally I create a macro that will only work by opening
the specific file I was working in when I created it.  I cannot figure out
the distinction between the two scenarios, nor can ...