+ Reply to Thread
Results 1 to 4 of 4

Series Fill problem

  1. #1
    Registered User
    Join Date
    04-19-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2003
    Posts
    20

    Series Fill problem

    Hi All, I hope all are safe from Covid-19.
    I can't figure how to series fill non-numeric data.
    I tried to series fill the alphabet both vertically and horizontally but the fill handle only copies the data. It works fine for numbers.
    Is there a setting I can adjust somewhere.
    Any help appreciated.

    Keep Safe
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Series Fill problem

    You need to create a custom lis
    Your profile says you're using Excel 2003 but your attachment is from a later version. As we don't know what version you're using the guide below may not be exact for you but it works this way in Excel 365.
    1) File / Options / Advanced
    2) Scroll down and click on the "Edit Custom Lists" button.
    3) From there you can either specify the list by typing it out or create a list from a range in the workbook.

    Hope that helps.

    BSB

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,603

    Re: Series Fill problem

    You could use this formula in your first cell:

    =CHAR(65+MOD(ROW()-1,2))

    then copy it down. If the cell is in an even-numbered row, then you won't need the -1 part.

    If you want to copy it across, use COLUMN rather than ROW.

    If you want lower case letters, use 97 instead of 65.

    Hope this helps.

    Pete

  4. #4
    Registered User
    Join Date
    04-19-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Series Fill problem

    Thank You both and apologies for delay in replying.
    I've upgraded to office 2016 and it auto changed to 365.
    I'm on to ask another question which will follow shortly

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Fill series to
    By stephme55 in forum Excel General
    Replies: 4
    Last Post: 05-23-2016, 01:14 PM
  2. need to fill series. three different series adjacent to each other
    By ajainwa in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-07-2013, 04:48 PM
  3. Fill Series - problem
    By Fos605 in forum Excel General
    Replies: 6
    Last Post: 01-23-2009, 06:35 AM
  4. Fill Series Problem
    By Keebs in forum Excel General
    Replies: 16
    Last Post: 07-27-2008, 01:14 PM
  5. HOW TO USE FILL SERIES
    By Wilsonzoo in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-22-2006, 09:15 PM
  6. Replies: 1
    Last Post: 01-29-2006, 08:55 AM
  7. [SOLVED] Filling in a Date Series using the Fill | Series menu command
    By Bob C in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-01-2005, 08:06 PM

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