Excel: Overtime Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

Begin with the Labels There are three parts to a spreadsheet: labels, data, and formulas. Let’s begin with the labels.   Type “Monday” in cell A1. See the little AutoFill handle in the bottom right hand corner of the cell? Hover the cursor over that AutoFill handle until it changes into a small, black plus sign. Now, hold your left mouse button and drag to the right. Excel will fill in the series. OK. We’ve got Monday through Saturday. Type “Total” in the cell next to Saturday. That’s it for labels. Monday, Monday! Can’t Trust That Day.

AutoFill Handle