+ Reply to Thread
Results 1 to 4 of 4

same date and set up on complete workbook

  1. #1
    ED
    Guest

    same date and set up on complete workbook

    Is it possible to set the date only once for the complete workbook? I have
    12 pages.
    Thank you.

  2. #2
    Registered User
    Join Date
    03-17-2006
    Posts
    47

    Query

    Ed,
    Not exactly sure what you mean. If you mean, insert it onto 12 different tabs/worksheets within a workbook and they're all in the same cell (e.g. A1), you can select cell A1 in Sheet 1, and then shift click on the final tab/worksheet. This will select cell A1 in all tabs. Press Ctrl ; to insert the date and press Ctrl Enter to enter it onto all 12 cells spread across the sheets.
    Clive

  3. #3
    Registered User
    Join Date
    03-17-2006
    Posts
    47

    Query

    Ed,
    Not exactly sure what you mean. If you mean, insert it onto 12 different tabs/worksheets within a workbook and they're all in the same cell (e.g. A1), you can select cell A1 in Sheet 1, and then shift click on the final tab/worksheet. This will select cell A1 in all tabs. Press Ctrl ; to insert the date and press Ctrl Enter to enter it onto all 12 cells spread across the sheets.
    Clive

  4. #4
    Bob Phillips
    Guest

    Re: same date and set up on complete workbook

    Maybe on Sheet2 add this formula to A1

    =Sheet1!A1

    and then again on the other sheets

    --
    HTH

    Bob Phillips

    (remove nothere from email address if mailing direct)

    "ED" <ED@discussions.microsoft.com> wrote in message
    news:93DD82A5-C2FA-4E7D-8563-BE234D147AC5@microsoft.com...
    > Is it possible to set the date only once for the complete workbook? I

    have
    > 12 pages.
    > Thank you.




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1