![]() |
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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 02:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com