Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

AutoFill Options in MS Excel

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
4,643
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Aug 5, 2008

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:
http://thecompanyrocks.com/excels

Category:

Howto & Style

Tags:

License:

Standard YouTube License

  • likes, 0 dislikes

Link to this comment:

Share to:

Uploader Comments (DannyRocksExcels)

  • 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!!

  • @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

  • 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 ;)

  • @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

see all

All Comments (7)

Sign In or Sign Up now to post a comment!
  • learn from you again. Thank you!

  • Excellent instructional video

  • you are the best, thanks for the excellent explaination.

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more