+ Reply to Thread
Results 1 to 2 of 2

How to use use automatic cell fill drag feature while string inside???

Hybrid View

  1. #1
    Registered User
    Join Date
    07-25-2012
    Location
    United States
    MS-Off Ver
    OpenOffice.org
    Posts
    4

    How to use use automatic cell fill drag feature while string inside???

    Sorry for the improper language in my title...not a excel master here.

    I know if I have 0 enter into cell A1, I can enter = A1+2 into cell A2, and drag the cells down to make each cell increment by two. My question is can I do this if I have the number A001 in cell A1, and want A002 in cell A2, and A003, in A3, etc. Any insights? Thanks much.

    ~Daniel

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: How to use use automatic cell fill drag feature while string inside???

    You should be able to just select your initial cell and drag down and it will update as you go - try it.

+ 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