Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Feb 2004
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Repeating text in several cells (Excel 2002)

    Is there a formula to repeat information in a group of cells? I know that you can use the autofill to drag and copy. I also know that you can use the Ctrl/Enter to copy. Is there a formula to copy very quickly if I want to put a number in cells A1 though A1000?

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Repeating text in several cells (Excel 2002)

    Here's a macro that would enter the number 1 into the range A1:A1000


    Sub numbers()
    Range("A1:A1000").Select
    Selection.FormulaR1C1 = "1"
    End Sub

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Repeating text in several cells (Excel 2002)

    Another way not using formulas or VB is to use the name box

    Copy the value you need to the clipboard and then in the name box type on A1:A1000 and then press Enter and then Ctrl + V....all the cells take that value
    Jerry

  4. #4
    Lounger
    Join Date
    Feb 2004
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Repeating text in several cells (Excel 2002)

    Jezza - that is a good one. I like that. I think that is what they were looking for. Thank you to all for responding.

Posting Permissions

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