Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Format multi-sheets

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    232
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry, I know this is being lazy but....

    I've got 10 sheets that I need the same custom headers and footers on - I know there is a way to do it one foul swoop, but have forgot... any takers?

    Thanks in advance
    Matt

  2. #2
    New Member
    Join Date
    Feb 2002
    Posts
    43
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Click on the first sheet tab, then with your SHIFT key down click on the last sheet tab. This will group the sheets. Type in the details of your header and footer.

  3. #3
    Board Regular sen_edp's Avatar
    Join Date
    Mar 2002
    Location
    Hellas
    Posts
    555
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello Matt
    You can do it.
    First you go at the sheet you have the header and footer, go to file menu -page setup and just press ok.
    then go to every other sheet you want the same setting , edit menu and press repeat page setup.
    Andreas

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •