Positioning Page Numbers

  • Thread starter Thread starter Kathy in Cincinnati
  • Start date Start date
K

Kathy in Cincinnati

We are trying to print page numbers in the upper right
hand corner of the page. The Excel charts will be
included as part of a Word report so we want the page
setups to look the same. In Excel we cannot find a way
to move the page numbers even with the margin of the page
as they are in Word. I can do this with numbers on the
left hand side of the page by inserting spaces before the
number in the set up box, but I cannot find a way to move
the page numbers in from the right hand side.

Any ideas? seems so simple, but......
 
Kathy

the only way I can think of that gets close is as follows:

Select View
Select Header and Footer...
Select Custom Header
Click in Right Section
Press the Page Number icon followed by a full stop.
Now put as many spaces as you need between the Page Number and the full stop
The full stop helps you position the Page Number where you want it.

Now the clever bit.

Position the cursor in front of the full stop
Press and hold the left Alt key while you press 032 on the numeric key pad.
(This inserts a non-printing character)
Now delete the full stop

In my test I found I could position the Page Number wherever I wanted.
Worked for me on a LaserJet 4000. Hope it works for you.

Regards

Trevor
 
Trevor and Dave -- Thank you for the tip, it works on my
computer as well. I have never heard of a full stop
before. Can you explain them in two sentences or does
this belong somewhere else? Kathy
 
Kathy,

it's the character that you put at the end of a sentence; in the UK, we call
it a full stop. It is also the decimal point in a number; for example,
12.34.

I guess a picture paints a thousand words; it's the character between the
chevrons >>> . <<<

On the basis that you delete the character once you've positioned the
number, I wish I'd just opted for "x" ;-)

Glad the suggestion worked for you.

Regards

Trevor
 
My gawd!

What's a chevron?

<<gd&r>>



Trevor said:
Kathy,

it's the character that you put at the end of a sentence; in the UK, we call
it a full stop. It is also the decimal point in a number; for example,
12.34.

I guess a picture paints a thousand words; it's the character between the
chevrons >>> . <<<

On the basis that you delete the character once you've positioned the
number, I wish I'd just opted for "x" ;-)

Glad the suggestion worked for you.

Regards

Trevor
Click to expand...
 
I just went back and read your tip.

Alt-032 is the same as the space character

I think you'd want the alt-0160 character (non-breaking space in HTML, too).

But even better, when I tried it in xl2002, adding the space character without
the extra dot/period/full stop <bg>, moved the page number to the left.

It didn't look like it in the "right section" dialog, but it did in both the
header/footer dialog (after hitting ok to the custom header/right section
dialog) and in print preview itself.
 
http://www.hyperdictionary.com/dictionary/chevron



CHEVRON



Pronunciation: 'shevrun



Matching Terms: Chevroned, Chevronel, Chevronwise, chevrotain



WordNet Dictionary



Definition: [n] an inverted V-shaped charge

[n] V-shaped sleeve badge indicating military rank and service



Synonyms: grade insignia, stripe, stripes



See Also: armorial bearing, badge, bearing, charge, heraldic bearing



Webster's 1913 Dictionary



Definition: \Chev"ron\, n. [F., rafter, chevron, from ch['e]vre

goat, OF. chevre, fr. L. capra she-goat. See {Cheveril}.]

1. (Her.) One of the nine honorable ordinaries, consisting of

two broad bands of the width of the bar, issuing,

respectively from the dexter and sinister bases of the

field and conjoined at its center.



2. (Mil.) A distinguishing mark, above the elbow, on the

sleeve of a non-commissioned officer's coat.



3. (Arch.) A zigzag molding, or group of moldings, common in

Norman architecture.



{Chevron bones} (Anat.), The V-shaped subvertebral arches

which inclose the caudal blood vessels in some animals.



Thesaurus Terms



Related Terms: achievement, alerion, angle, animal charge, annulet, apex,
argent, armorial bearings, armory, arms, aviation badge, azure, badge,
bandeau, bar, bar sinister, baton, bearings, bend, bend sinister,
bifurcation, bight, billet, blazon, blazonry, bordure, broad arrow, cadency
mark, cant, canton, chaplet, charge, chicken, chief, coat of arms,
cockatrice, coin, corner, coronet, crank, crankiness, crescent, crest,
crook, crookedness, cross, cross moline, crotchet, crown, deflection,
device, difference, differencing, dogleg, eagle, elbow, ell, epaulet,
ermine, ermines, erminites, erminois, escutcheon, falcon, fess, fess point,
field, file, flanch, fleur-de-lis, flexuosity, fork, fret, fur, furcation,
fusil, garland, griffin, gules, gyron, hairpin, hash mark, hatchment,
helmet, heraldic device, Hershey bar, honor point, hook, impalement,
impaling, inescutcheon, inflection, insignia of branch, knee, L, label,
lion, lozenge, mantling, marshaling, martlet, mascle, metal, motto, mullet,
nombril point, nook, oak leaf, octofoil, or, ordinary, organization
insignia, orle, overseas bar, pale, paly, parachute badge, patch, pean,
pheon, pip, point, purpure, quarter, quartering, quoin, rose, sable,
saltire, scutcheon, service stripe, shield, shoulder patch, shoulder sleeve
insignia, spread eagle, star, stripe, submarine badge, subordinary, swerve,
switchback, tenne, tincture, torse, tressure, unicorn, vair, veer, vert,
vertex, wreath, yale, zag, zig, zigzag, zigzaggery





<gd&r>

Like all terms sandwiched between less-than and greater-than signs, this is
used to show emotions in online postings or chat--in this case, to show that
a preceding comment should be interpreted as the kind of cheekiness that
provokes a good-natured whack upside the head.

;-))


Amazing what you can find on the Internet
 
Dave

think you're probably correct ... I was just looking for a non printing
character, whatever. Surprisingly alt-032 seemed to work and keep the
position. The trick also appeared to be limited to two lines in the box,
however, you could actually move the page number as far as you wanted.

Anyway, seemed to solve the problem!

Regards

Trevor
 
Back
Top