![]() |
Is there a way to automatically add sequential dates in excell?
Is there a way to automatically add sequential dates to a spreadsheet? For
example, creating a spreadsheet for recording rental income, typing in each month manually or is there a function that will automatically fill the cells with the months of the year? |
Is there a way to automatically add sequential dates in excell?
genectn, select the cell with your first data, move your mouse over the
right bottom corner of the cell, where the little black box is at, you mouse will change to a + sign, RIGHT click and drag down, when you let go of the mouse you will get some options, pick fill months -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "genectn" wrote in message ... Is there a way to automatically add sequential dates to a spreadsheet? For example, creating a spreadsheet for recording rental income, typing in each month manually or is there a function that will automatically fill the cells with the months of the year? |
All times are GMT +1. The time now is 12:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com