Mac Forum / Applications / Excel / December 2005

I am trying to copy the formatting, mainly the column width from one
worksheet to another within one file.  I have tried select-all, then
format painter, and select all in the new sheet and paste format
painter.  This is acting funky with the bottom row expanding too much

I apologize in advance if this is contrary to list etiquette. I'm looking to
hire an Excel Mac expert to work on a project, a custom spreadsheet with a
bunch of macros. Anyone have a recommendation?
Thanks,

I cannot get exising macros to run or write new macros since installing
last update 10.1.6
Prior to that I had no problems
can anyone help?

I am trying to Group dates in a large database to summarize activity by
week. The entries in the database are for only one day each, with
multiple entries for some days and none for others. When I Group these
dates to summarize by week, Excel puts them in an order that is out of

I've got a list of several thousand names and addresses. I'm trying to
find the duplicates. I've searched the forums here and found this:
=IF(COUNTIF(Range1, FirstCellofRange)>1,"Duplicate","")
And it seems to almost be what I want. But...the first and last name

Is there a way to impart into excel my contacts from apple's mail ?

For ease of switching between the two applications, I have inserted the
Microsoft Excel icon onto my MS Word toolbar (using View / Toolbars /
Customize Toolbars / Menus).
I can not seem to locate the same functionality in MS Excel -- I can

Not sure if this is the proper forum to ask this question or not, but here's
the next place I've chosen to ask this...
In Excel 2004 for Mac, is there a way to change the tab color for the
individual pages in a workbook? In the Windowsux version, you simply click

I am trying to process sets of analytical results and am having trouble
teaching Excel how to leave out values under certain conditions.  This
process will be set up in a template spreadsheet that is then used to
correct large sets of results from a mass spectrometer.  Basically I

I can't figure out how to set the extent displayed for a worksheet.
Looking at the gallery, Home Essentials, Home Budget, for example, you
only see 1a:76h displayed.  I can't figure out how to hide the
remaining extent of a new spreadsheet to match this example.  It must

I have been doing work on my MS office for mac/excel.  When I pull the
spreadsheets up on the pc's at work, instead of pics I get a message
saying that quicktime and tiff decompressor are needed.  tiff and gif
files seem to pull open on their own on the pc, but the pictures inside

I have an excel worksheet that I have made in to a managed list, with
autofilters. I need for the formulas to be protected, but once I
protect the sheet, the autofilter function doesn't work. Is it possible
to enable autofilter on a protected sheet on a Mac (the windows version

Following code doesn't work like my idea.
====================
Sub Makro8()
' Makro8 Makro

Someone was saying to me that there is a way to take two very similar files
and have excel examine them, and let you know what is missing from one of
the files that is in the other file.
If possible, how does one do this? Thanks.

I recently switched to a MAC and trying to use spreadsheets created on
a PC.  The problem I'm having relates to the 1904 date systems used by
MAC and the 1900 used by Windows - all my dates are off by 4 years so I
can't create pivot tables because the dates are "invalid" since