Sunday, May 20, 2012
Login

AutoFill Options in MS Excel

Posted by admin in Data Entry Monday, 19 September 2011 06:45 7 Comments


Learn how to save time and ensure accuracy when entering data into your Excel spreadsheet. Excel’s AutoFill feature has many options to explore. Want to fill workdays only? Watch to see how? To see all of my MS Excel “Tips & Timesavers” vist my website: thecompanyrocks.com

Tags: , ,
This entry was posted on Monday, September 19th, 2011 at 6:45 am and is filed under Data Entry. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

7 Comments

  1. September 19, 2011 7:17 am
    posted by DannyRocksExcels

    @Yankitt
    Hello – Sorry for the delay in responding. In order to AutoFill 1a, 1b,1c, etc. you first need to add these values as a “Custom List” in Excel. If you have a “numeric value” as the 1st or last character in a cell, Excel automatically increments the number (Area 1m Area 2 or 1st Grade, 2nd Grade, etc.
    “Custom Lists” are easy to create – I have several videos that show you how – and they are available to all Excel workbooks on your computer.

    Danny Rocks

  2. September 19, 2011 8:08 am
    posted by Yankitt

    Is there a way to autofill letters & numbers? Such as 1a, 1b, 1c…or 1/3/11a, 1/4/11b…

    Thanks! This video really helped me!!

  3. September 19, 2011 8:09 am
    posted by DannyRocksExcels

    @cnunez2008
    I am so pleased that I could help you to save time and keystroks. Thank you for writing to tell me this!

    Danny Rocks
    The Company Rocks

  4. September 19, 2011 8:41 am
    posted by cnunez2008

    wow thank u for that sooo much i had been typing in one by one for about 1 yr now………………no more thnx 2 u ;)

  5. September 19, 2011 9:17 am
    posted by 338win

    learn from you again. Thank you!

  6. September 19, 2011 10:06 am
    posted by leaderhelper

    Excellent instructional video

  7. September 19, 2011 10:34 am
    posted by user41017

    you are the best, thanks for the excellent explaination.

 

Powered by Yahoo! Answers