Excel for Marketing Managers

Multiplication Tables

Multiplication

Tables

3. There is a neat trick with days or dates. If you type “Monday” into a cell
   and drag the fill handle, you will get the days of the week.


4. As a teacher, though, try this trick. Type “Monday” into a cell. Select the
   cell. Right-click the fill handle and drag.

Initially, the tooltip shows Tuesday, Wednesday, Thursday, Friday,

Saturday, Sunday, etc.. However, when you release the mouse pointer, you

are given a drop-down menu. Choose Fill Weekdays.

Figure 78

Days of the week filled in automatically

Figure 79

Selecting Weekdays from Fill

dropdown menu