Step 8Copying All of the Formulas
iImage Information

Highlight cells B2 through F2. You'll notice that in the lower-right corner of the selection there's a small black box; holding down your left mouse button, select the small black box and drag down (when your mouse is hovering over the correct place, it will turn into a 'plus' sign). As you drag down, you'll notice that a date will be displayed. Drag down until you get to 1/1/2036 and release the left mouse button. When you release the mouse button, all of the formulas that you wrote will be copied down to the bottom of the spreadsheet. You see some years labeled Leap. Those are the leap years.