Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
one year calender
I want to setup a spreadsheet for a year that I can post information into
weekly. I want the dates setup weekly in a vertical format. I cannot get it to work using the instructions. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
one year calender
Hi smickParisTX. Assuming you use Monday as the first day of the week, in A2
type 1/2/06. In A3 type 1/9/06. Select both cells A2 and A3 and point the cursor at the little black box on the lower right corner of the selection. When the cursor turns into a black cross, click and hold with the left button and pull down. It will populate the cells in column as far as you go in weekly increments. HTH -- Sincerely, Michael Colvin "smickParisTX" wrote: I want to setup a spreadsheet for a year that I can post information into weekly. I want the dates setup weekly in a vertical format. I cannot get it to work using the instructions. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
one year calender
This is exactly what I did, evidently I have a software problem. Thanks.
"Michael" wrote: Hi smickParisTX. Assuming you use Monday as the first day of the week, in A2 type 1/2/06. In A3 type 1/9/06. Select both cells A2 and A3 and point the cursor at the little black box on the lower right corner of the selection. When the cursor turns into a black cross, click and hold with the left button and pull down. It will populate the cells in column as far as you go in weekly increments. HTH -- Sincerely, Michael Colvin "smickParisTX" wrote: I want to setup a spreadsheet for a year that I can post information into weekly. I want the dates setup weekly in a vertical format. I cannot get it to work using the instructions. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
one year calender
Sorry about that. Good luck.
-- Sincerely, Michael Colvin "smickParisTX" wrote: This is exactly what I did, evidently I have a software problem. Thanks. "Michael" wrote: Hi smickParisTX. Assuming you use Monday as the first day of the week, in A2 type 1/2/06. In A3 type 1/9/06. Select both cells A2 and A3 and point the cursor at the little black box on the lower right corner of the selection. When the cursor turns into a black cross, click and hold with the left button and pull down. It will populate the cells in column as far as you go in weekly increments. HTH -- Sincerely, Michael Colvin "smickParisTX" wrote: I want to setup a spreadsheet for a year that I can post information into weekly. I want the dates setup weekly in a vertical format. I cannot get it to work using the instructions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
years change to current year | Excel Worksheet Functions | |||
year function and financial years | Excel Worksheet Functions | |||
Annual leave calender year 2006 - template | Excel Discussion (Misc queries) | |||
Ho to Delete "Ghost" Pivot Tables | Excel Discussion (Misc queries) | |||
How to compare current year to prior year in bar chart? | Charts and Charting in Excel |