If I put Jan11 in A1, how can I use fill right out to A12 and put Feb11 in B1 and Mar11 in C1 (etc.)?
jim
If I put Jan11 in A1, how can I use fill right out to A12 and put Feb11 in B1 and Mar11 in C1 (etc.)?
jim
Last edited by jlr4; 08-25-2011 at 11:40 AM.
I figured it out. I put Jan 2011 in A1 then held the pointer on the fill cross on the bottom right of cell A1 and pulled it to cell A12, let go and all the months filled in. (A2 = Feb11, A3 = Mar11 etc.)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks