Topics

Apr 2, 2011

Fill weekdays using the Fill handle in Excel 2007

Perform the following steps to fill the weekdays using the Fill handle:
1. In cell A1 type Mon or Monday and press the ENTER key.
2. Click cell A1. (Cell A1 will have a thick border with a tiny black square at the lower right corner. This tiny black square is called the Fill handle.)
3. Keep the right click mouse button in pressed state. Move the mouse pointer over the Fill handle and drag down till cell A10.
4. From the list of options for Auto Fill. Click Fill Weekdays.

You will see the weekdays being filled automatically. Once Tuesday, Wednesday, Thursday, Friday is filled in, you will see Monday, Tuesday and so on being filled.

0 comments:

Post a Comment