1. Welcome Guest! In order to create a new topic or reply to an existing one, you must register first. It is easy and free. Click here to sign up now!.
    Dismiss Notice

paste same word in all cells in column

Discussion in 'Microsoft Windows' started by S1L1Y1, May 4, 2009.

  1. S1L1Y1

    S1L1Y1 Guest

    I posted this question in the Office group but got no response.
    I am working in Microsoft Excel. Now I want to add to each cell in the
    column the same word. How can I do it?
    Sol
     
    S1L1Y1, May 4, 2009
    #1
  3. Mart

    Mart Guest

    Select the first cell and type the 'word'. The cell box will highlight
    Left click the bottom right hand corner 'dot'
    The cursor will change from a large + to a small +
    Drag (Up or Down) to the last required cell and release the LH mouse button.

    The 'word' will be duplicated to all the required cells.

    HTH

    Mart


    "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
    news:OjGUYNRzJHA.2084@TK2MSFTNGP02.phx.gbl...
    >I posted this question in the Office group but got no response.
    > I am working in Microsoft Excel. Now I want to add to each cell in the
    > column the same word. How can I do it?
    > Sol
    >
    >
     
    Mart, May 4, 2009
    #2
  4. Jeff Richards

    Jeff Richards Guest

    Post it in an Excel group instead of an Office group.

    Make sure your description in the subject line matches the description in
    the text - currently you use 'paste' in the subject and 'add' in the text,
    and they are two different operations.
    --
    Jeff Richards
    MS MVP (Windows - Shell/User)
    "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
    news:OjGUYNRzJHA.2084@TK2MSFTNGP02.phx.gbl...
    >I posted this question in the Office group but got no response.
    > I am working in Microsoft Excel. Now I want to add to each cell in the
    > column the same word. How can I do it?
    > Sol
     
    Jeff Richards, May 4, 2009
    #3
  5. Bill in Co.

    Bill in Co. Guest

    Try microsoft.public.excel (or any of the other variations in there)

    S1L1Y1 wrote:
    > I posted this question in the Office group but got no response.
    > I am working in Microsoft Excel. Now I want to add to each cell in the
    > column the same word. How can I do it?
    > Sol
     
    Bill in Co., May 4, 2009
    #4
  6. S1L1Y1

    S1L1Y1 Guest

    First Thanks to.Mart. I tried the microsoft.public.excel , and Office groups
    but got no answer.
    "Bill in Co." <not_really_here@earthlink.net> wrote in message
    news:eStKRsSzJHA.4272@TK2MSFTNGP06.phx.gbl...
    > Try microsoft.public.excel (or any of the other variations in there)
    >
    > S1L1Y1 wrote:
    > > I posted this question in the Office group but got no response.
    > > I am working in Microsoft Excel. Now I want to add to each cell in the
    > > column the same word. How can I do it?
    > > Sol
    >
    >
     
    S1L1Y1, May 5, 2009
    #5
  7. S1L1Y1

    S1L1Y1 Guest

    Thank You very much Mart. Now what means Fill Formatting Only or Fill
    Without Formatting?
    Sol
    "Mart" <mart(NoSpam)@nospam.nospam> wrote in message
    news:OxGxfWRzJHA.6004@TK2MSFTNGP02.phx.gbl...
    > Select the first cell and type the 'word'. The cell box will highlight
    > Left click the bottom right hand corner 'dot'
    > The cursor will change from a large + to a small +
    > Drag (Up or Down) to the last required cell and release the LH mouse
    button.
    >
    > The 'word' will be duplicated to all the required cells.
    >
    > HTH
    >
    > Mart
    >
    >
    > "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
    > news:OjGUYNRzJHA.2084@TK2MSFTNGP02.phx.gbl...
    > >I posted this question in the Office group but got no response.
    > > I am working in Microsoft Excel. Now I want to add to each cell in the
    > > column the same word. How can I do it?
    > > Sol
    > >
    > >
    >
    >
     
    S1L1Y1, May 5, 2009
    #6
  8. S1L1Y1

    S1L1Y1 Guest

    I tried it but what is happing is, in the original cell each cell has
    something else now with this process all the cells will have the same.
    Sol
    "Mart" <mart(NoSpam)@nospam.nospam> wrote in message
    news:OxGxfWRzJHA.6004@TK2MSFTNGP02.phx.gbl...
    > Select the first cell and type the 'word'. The cell box will highlight
    > Left click the bottom right hand corner 'dot'
    > The cursor will change from a large + to a small +
    > Drag (Up or Down) to the last required cell and release the LH mouse
    button.
    >
    > The 'word' will be duplicated to all the required cells.
    >
    > HTH
    >
    > Mart
    >
    >
    > "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
    > news:OjGUYNRzJHA.2084@TK2MSFTNGP02.phx.gbl...
    > >I posted this question in the Office group but got no response.
    > > I am working in Microsoft Excel. Now I want to add to each cell in the
    > > column the same word. How can I do it?
    > > Sol
    > >
    > >
    >
    >
     
    S1L1Y1, May 5, 2009
    #7
  9. Mart

    Mart Guest

    Hmm... I guess you are working with an existing worksheet rather than a
    fresh one. If so, it might depend on exactly what the author of the original
    worksheet was doing and how he'd set-up the format. The 'solution' I gave
    was for a clean worksheet.

    Try the format option, see also the Help option - there may clues there.
    Google might even help further.

    Mart



    "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
    news:uGDchgbzJHA.5032@TK2MSFTNGP05.phx.gbl...
    >I tried it but what is happing is, in the original cell each cell has
    > something else now with this process all the cells will have the same.
    > Sol
    > "Mart" <mart(NoSpam)@nospam.nospam> wrote in message
    > news:OxGxfWRzJHA.6004@TK2MSFTNGP02.phx.gbl...
    >> Select the first cell and type the 'word'. The cell box will highlight
    >> Left click the bottom right hand corner 'dot'
    >> The cursor will change from a large + to a small +
    >> Drag (Up or Down) to the last required cell and release the LH mouse
    > button.
    >>
    >> The 'word' will be duplicated to all the required cells.
    >>
    >> HTH
    >>
    >> Mart
    >>
    >>
    >> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
    >> news:OjGUYNRzJHA.2084@TK2MSFTNGP02.phx.gbl...
    >> >I posted this question in the Office group but got no response.
    >> > I am working in Microsoft Excel. Now I want to add to each cell in the
    >> > column the same word. How can I do it?
    >> > Sol
    >> >
    >> >
    >>
    >>
    >
    >
     
    Mart, May 5, 2009
    #8
  10. Franc Zabkar

    Franc Zabkar Guest

    On Mon, 4 May 2009 19:51:35 -0400, "S1L1Y1" <s1l1y1@yahoo.com> put
    finger to keyboard and composed:

    >I posted this question in the Office group but got no response.
    >I am working in Microsoft Excel. Now I want to add to each cell in the
    >column the same word. How can I do it?
    >Sol

    I'm only an occasional Excel user but here are some suggestions.

    Create a new column, say Y.

    Copy the data in the column you want to modify, say X, to the new
    column.

    Select cell X1 and add the following formula:

    =Y1&"text"

    Then r-click cell X1 and select Copy.

    Select the remaining cells in column X and select Edit->Paste (or
    Ctrl-V).

    Unfortunately you won't be able to delete the contents of column Y
    because the data in X are dependent on the contents of Y.

    One other way that is a bit more complicated is to create a new column
    to the right of the subject column. Put your "text" in each cell of
    the new column. Then save the spreadsheet as a CSV file (comma
    delimited).

    Use an editor to Search and Replace each occurrence of ...

    ,text,

    .... in the CSV file with ...

    text,

    .... and then reimport this modified CSV file into a new spreadsheet.

    You may lose any formulae doing it this way. If so, then restrict your
    work to the subject column only.

    - Franc Zabkar
    --
    Please remove one 'i' from my address when replying by email.
     
    Franc Zabkar, May 5, 2009
    #9
  11. Jeff Richards

    Jeff Richards Guest

    Copy, then RightClick, Paste Special and Values will create a new column
    that isn't dependant on the formula.
    --
    Jeff Richards
    MS MVP (Windows - Shell/User)
    "Franc Zabkar" <fzabkar@iinternode.on.net> wrote in message
    news:und105hfndobqh2v2gsm89ktahcec2vior@4ax.com...
    > snip <
    >
    > Unfortunately you won't be able to delete the contents of column Y
    > because the data in X are dependent on the contents of Y.
    >
     
    Jeff Richards, May 5, 2009
    #10
  12. Franc Zabkar

    Franc Zabkar Guest

    On Wed, 6 May 2009 11:36:50 +1000, "Jeff Richards"
    <JRichards@msn.com.au> put finger to keyboard and composed:

    >Copy, then RightClick, Paste Special and Values will create a new column
    >that isn't dependant on the formula.

    Thanks so much!

    - Franc Zabkar
    --
    Please remove one 'i' from my address when replying by email.
     
    Franc Zabkar, May 6, 2009
    #11

Share This Page