ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Is there a way to automatically add sequential dates in excell? (https://www.excelbanter.com/new-users-excel/137663-there-way-automatically-add-sequential-dates-excell.html)

genectn

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?

Paul B

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