+ Reply to Thread
Results 1 to 2 of 2

Copying text

  1. #1
    Forum Contributor
    Join Date
    10-29-2004
    Posts
    291

    Question Copying text

    How can I reference a group of text so it repeats in other cells? This would be a series of cells. Basically a spreadsheet name I would like referenced in other parts of the spreadsheet without having to re-type it each time.

  2. #2
    Forum Contributor
    Join Date
    01-11-2004
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    388
    Hi!

    If I undersannd your need:
    Working on Sheet1
    Put some text in A1
    Choose any other cell on Sheet1 and put =A1.

    Choose a cell on another sheet and put =Sheet1!A1

    In both cases it will repeat the text in A1.

    Alf

+ 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