On 1/7/07, Jim Robertson <[EMAIL PROTECTED]> wrote:
I've run into an Excel question, and while investigating it discovered I
need a cross platform answer. I used the "List Wizard" to create a table of
First, the list wizard can't accommodate multiline cells that grow into the
bottom of a page margin (you'd think the wizard would be smart enough to
change page break locations to deal with this, but it doesn't; it just hides
the data in the last row on a page with a single line of ####### characters,
and once it's done so, those cells remain obscured no matter how their
sorted or where they appear on the page after subsequent
edits/additions/deletions to the list database).
In any event, I need pointers from someone who knows both Mac and Windows
Excel who can tell me how to create this table with page headers that
display on each page, flexible page breaks for the data rows, and multi-user
capability so that edits can be made by me and the developers and we know
who's done what.
Can someone tell me where to go for a few pointers?
Mac only--that explains why I don't know this feature. I've been using
Excel for Windows for years, and am now on a Mac platform. I looked up
the list wizard:
http://www.microsoft.com/mac/resources/resources.aspx?pid=resourcekits&rk=officex&article=/mac/officex/ork/File_Formats_Excel.xml
Can you save it into an earlier version of Excel? That might convert
it to a normal document.
To get repeating headers, go to File > Page Setup > Sheet > Click in
Rows to Repeat > Click or drag across the header rows > Click OK.
For a page break, click in a cell and choose Insert > Page Break. Or
go to View > Page Break Preview and drag your page breaks around.
Would Track Changes take care of the third concern?
Jane
--
To unsubscribe:
<mailto:[EMAIL PROTECTED]>
archives:
<http://www.mail-archive.com/entourage-talk%40lists.letterrip.com/>
old-archive:
<http://www.mail-archive.com/entourage-talk%40lists.boingo.com/>
