Assume that Sunday is entered in cell A1. Click cell A1 and place the mouse cursor over the Fill handle and drag down. Monday will be entered in cell A2. Further dragging will have Tuesday in cell A3, Wednesday in cell A4 and so on. You have filled the data series with AutoFill.
If you do not want Monday, Tuesday, and Wednesday to appear but instead you want Sunday to appear in cells A2, A3, A4 and so on then press the CTRL key. Place the mouse cursor over the Fill handle. The mouse cursor will change to a double plus (a big plus and a small plus at top right). Keeping the CTRL key in pressed state, drag the mouse cursor. You will see Sunday in cells A2, A3, and so on.
Apr 2, 2011
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment