Re: Page headers/footers

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


John wrote:
In article <C144C610.5E1B%b.rey@xxxxxxxxxxxxxxxxxxx>,
Bernard Rey <b.rey@xxxxxxxxxxxxxxxxxxx> wrote:

John :

See my reply to Bob on how to reproduce the problem. I did try your Page
Layout trick and it appears to work but of course once the worksheet
gets populated I'm right back where I was - unable to further edit the
center header.

I'm at a loss...

No I have not tried the "usual voodoo". How do I "repair permissions"
(I don't think I've every done that).

Certainly a good thing to do whenever things don't work the way they should.
Find the "Disk Utility" in the "Applications/Utilities" folder and repair
the permissions. If often helps.


I will try trashing the preferences but I just installed the latest
update for Office so the preferences should be fresh and new.

Nope. Updating doesn't change anything in the user's folder. Neither
preferences nor anything else.


I am the only user of my Mac so there are no other "accounts" - I am
da main man.

Yes. That is the usual situation and this is why it is a good
troubleshooting tip to create a new account and launch Office in that brand
new fresh account, just in order to see if the problem is still there (in
which case you can think it is a system wide issue and track incompatibility
or application files corruption). If the problem's gone, then you can think
it has something to do with user's settings, preferences, etc.


--
Bernard Rey - Toulouse / France
MVP - office:macintosh http://faq.office.macintosh.free.fr

Bernard,
You're at a loss? Hey, wait a minute, MVPs aren't allowed to be at a
loss, right? (see my signature below)

OK, I tried repairing permissions (I had forgotten about the disk
utility). I ran it multiple times (i.e. check, repair, re-check, repair,
re-check). There is one permission that says is fixed but subsequent
re-check still lists it as having a problem
(./usr/share/man/man1/less.1). I remember running into that little
anomaly when I ran the disk utility some time ago. Nonetheless fixing
disk permissions didn't help.

I also trashed the Excel preferences. That also didn't help. I tried
creating a new user account complete with password. That also didn't
help. Based on the latter I have to believe it is an application or
system issue.

One other thing I notice and I don't know if it is significant. When I
type the first line into the center section of the header, the text
starts center justified and stays that way while I enter the first line.
However, after I hit return, the cursor starts in the center but as soon
as I hit the first character it appears at the far left and then fills
the width of the entry box as I type. As soon as the width of that
second line exceeds the box width, that line goes to never-never-land.

This isn't looking good. Any other suggestions? It is interesting that
Excel on Windows (I use VPC) doesn't have this problem. My current
thinking is to either do my spreadsheet in Windows or use Word, which
may be a better choice anyway since I'm just trying to put together a
sign in sheet for a meeting.

John
MS Project MVP


In article <C1440C68.5E07%b.rey@xxxxxxxxxxxxxxxxxxx>,
Bernard Rey <b.rey@xxxxxxxxxxxxxxxxxxx> wrote:

Sorry, I can't reproduce the problem you describe. Be it through the
"Headers & Footers" tab in the Print Settings or by a double-click in the
Header area in "Page layout". No problem to change font size (or any other
setting so far).

The only situation I could find somewhat misleading is when in Page layout
but with nothing at all in the sheet cells. In that case, when you modify
the text settings (which you can do) you can't see the result (but you
couldn't have a preview) as the sheet appear to be blank.

Have you tried the usual voodoo things (repairing permissions, trashing
the
preferences files, create a new Mac OS X account, log in and launch Excel
to
see if your problem still shows up) ?


--
Bernard Rey - Toulouse / France
MVP - office:macintosh http://faq.office.macintosh.free.fr

John :

People,
I have an eMac running OS 10.2.8 with Office 2004 for Mac installed. I
applied all the latest updates for Office.

I am trying to create a header for an Excel worksheet. When I go to
File/Page Setup, header/footer tab, I select "customize header" and then
select the center section. I type in my header and then select all text
to change the font style to a larger font. I do a preview to see how I
like it. Not good enough so I go back to select the center text again
however this time the text does not show up in the center section so I
can't edit it - font characteristics or otherwise. I then thought I'd
try to change the view to show page layout but alas the headers and
footers can only be changed through the headers and footers view which
takes me back to the same page setup window. How in the world do you
select it to change it if it isn't shown? There must be a simple trick
because I can't believe this is a bug that hasn't been fixed.

Help.
John

.

Relevant Pages

  • Re: Page headers/footers
    ... update for Office so the preferences should be fresh and new. ... I tried repairing permissions (I had forgotten about the disk ... type the first line into the center section of the header, ... Header area in "Page layout". ...
    (microsoft.public.mac.office.excel)
  • Re: Page headers/footers
    ... update for Office so the preferences should be fresh and new. ... Header area in "Page layout". ... No problem to change font size (or any other ...
    (microsoft.public.mac.office.excel)
  • Re: Page headers/footers
    ... It can be a font issue, ... type the first line into the center section of the header, ... update for Office so the preferences should be fresh and new. ... Header area in "Page layout". ...
    (microsoft.public.mac.office.excel)
  • Re: Dual monitor possible?
    ... effectively I found it out of internet. ... One front MIC-IN header ... layout for the motherboard. ...
    (Ubuntu)
  • Re: Getting rid of frames
    ... two-column layout with a header and footer which is a classic CSS ... I need the "box" to stretch to the entire width & height of the viewport. ...
    (comp.infosystems.www.authoring.stylesheets)