• Repeating text in several cells (Excel 2002)

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Repeating text in several cells (Excel 2002)

    Author
    Topic
    #437328

    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?

    Viewing 1 reply thread
    Author
    Replies
    • #1039311

      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

    • #1039312

      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

      • #1039318

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

    Viewing 1 reply thread
    Reply To: Repeating text in several cells (Excel 2002)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: