Mac Forum / Applications / Excel / January 2007

I have a Column headed "Year";  I want to create a spreadsheet in which
the first column is "Year".  As I go down the column, it will read
2000; 2001; 2002; etc.  How do I enter the year "2000" (or any year)
without Excel converting my numbers into something altogether

I have created a new template called Workbook (no extension) and placed
it in the directory called: Applications/Microsoft Office
2004/Office/Startup/Excel.  My modified default template now loads
whenever I activate Excel 2004.  It also activates when I use the

I have data linked between two worksheets in the same workbook.  When I add a
row on the 1st sheet - it does not add one on the linked one....is there a
way to do this?  Is "linking" not what I want to do?

I've created a pretty complicated workbook in Mac OS X and would like
it to be used on a Windows machine also. Of course, the problem is that
the font size on the Mac displays larger on the Windows machine and
many of the cells can't display the values in Windows. For example, the

I have a Excel worksheet with +1000 records with 10 columns across.  I
can
display the numbers in each cell by selecting "format cells, number,
decimal places 1".  However, the cells contain calculated values with

I have a Column headed "Year";  I want to create a spreadsheet in which
the first column is "Year".  As I go down the column, it will read
2000; 2001; 2002; etc.  How do I enter the year "2000" (or any year)
without Excel converting my numbers into something altogether

Sometimes, as I scroll through a worksheet, it will disappear. I can
usually recover the open worksheet by clicking on "Window / Zoom
Window". Sometimes even that doesn't work and I have to go to another
program, and then return to Excel in order to see the open worksheet.

A client as introduced new "identity standards" which mandates that all
company materials use the official company colors.
We are trying to figure out if we can adjust the font and cell fill color
options in Excel to match their PMS colors.

Way back in Nov 2002 this topic was brought up and responded to by JE
McGimpsey who kindly provided a macro for Office X (as shown below) to
keep Excel from turning all links into live hyperlinks. However, this
macro apparently doesn't work in Office 2004, because I've tried

My formatting palette has gone to the bottom of my screen when
activated and I cannot see it.  How do I scroll my desktop in order to
move it back into view?

I'm experiencing a problem with Excel and I'm pretty stumped.
I've recently installed Excel v.X and upon the initial launch, I'm
asked to personalize my copy and I enter my name and organization.

Please help!! Once we upgrade to Office 2004 I'm no longer able to
change cell sizes by entering the point size that I would like it to
be, I have to enter the size in inches. I know it sounds like a minor
inconvience, but it is truely driving me insane. It's not a preference,

This may be a relatively simple problem to solve or it might be
downright impossible.  That's the fun thing about excel... you never
know!
I have a list of information on a worksheet containing 4 columns.   In

Can we enlist all the worksheets of a excel(*.xls) file in through the
program menu? How?

In the PC versions of Excel the row and column fields have filter dropdowns
which make it easy to pick as many items as you want to display.  These
features are not available even on the 2004 MAC version.  Why is this useful
feature absent and what does one use in its stead?