+ Reply to Thread
Results 1 to 3 of 3

Copying the same value into an entire column

  1. 05-11-2013, 02:27 PM #1
    seigna
    seigna is offline
    Forum Contributor
    Join Date
    04-07-2013
    Location
    France
    MS-Off Ver
    Excel 2011
    Posts
    166

    Copying the same value into an entire column

    Hi, how do I place the same value into all cells in one column in excel?
    Reply With QuoteRegister To Reply
  2. 05-11-2013, 02:37 PM #2
    popipipo
    popipipo is offline
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,293

    Re: Copying the same value into an entire column

    A2: =A1
    pull down the formula
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong
    Reply With QuoteRegister To Reply
  3. 05-11-2013, 02:53 PM #3
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Copying the same value into an entire column

    Copy the cell. Paste where you want the copied cell. Click on the destination cell then Ctrl+Shift+down arrow, then Ctrl+D. This will fill the cells to the bottom of the column with the copied value.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1