Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Is there a time saver?

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a Workbook with multiple spreadsheets. Recently my company changed it's name and therefor I must change my email in the header.
    All my worksheets are the same with the top three lines stating the date, title of worksheet, and my email.
    Is there a quick way to change the data of the header and for it to copy to all my other header's?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Right-click any worksheet tab, choose "Select All Sheets" from the popup menu, choose the File | Page Setup... and make your header change.

  3. #3
    New Member
    Join Date
    Apr 2002
    Location
    Robert F. Cavedo
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have the same problem. But I am trying to do it to most of my workBOOKS. Is there a way to do it without typing the new header for EACH workBOOK?

    Bob

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
  •