+ Reply to Thread
Results 1 to 2 of 2

how to drag some data in excel cloumn cells

  1. #1
    Registered User
    Join Date
    06-30-2011
    Location
    New Delhi
    MS-Off Ver
    Excel 2003
    Posts
    46

    how to drag some data in excel cloumn cells

    I am facing some problem in dragging data in cells of column B. Upon draging, column B's data should look like column C's data........
    if u have some problem in understanding the scenario or issue, reply me...........
    Attached Files Attached Files
    Last edited by meetvivek72; 08-23-2012 at 07:22 AM.

  2. #2
    Forum Contributor
    Join Date
    08-23-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    163

    Re: how to drag some data in excel cloumn cells

    Select entire column B
    GoTo (Ctrl+G)...Special....Blanks
    Type formula =B2 (upper cell)
    Ctrl+Enter
    Paste special...values

+ 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