Explore AutoFill Options

Here are the steps to follow for today’s lesson:

1) Click the drop-down arrow for AutoFill options.

2) Experiment with the different options e.g. Fill Weekdays only; Fill Formatting only, etc.

3) To increment numbers: establish the increment by typing the values in 2 cells; select both of the cells and then AutoFill

4) If you have a Formula that is adjacent to a series of numbers or text, then Double-Click the AutoFill Handle and Excel will fill the formula into all cells.

Find the video lesson that you want – Index to all Excel Topics

NEW! I invite you to view a short video introduction to The Company Rocks Excels Blog

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Speak Your Mind

*