software

How do you add dates to the top of each column in Excel? I want each column
to represent a day. I could write the date in manually, but so far, I have
been starting from the top of each column (in Line 1), so I would have to
move the data in each column down by one cell to make room to write in the
date. Is there any way to do that automatically?

Not sure if I understand the bit about quot;move the data in each column down)
but ....
If in A1 you enter a date such as 10/Jan/2006, and in B1 enter =A1 1 then
B1 will show 11-Jan-2006
any help?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Wesselquot; gt; wrote in message
...
gt; How do you add dates to the top of each column in Excel? I want each
gt; column
gt; to represent a day. I could write the date in manually, but so far, I have
gt; been starting from the top of each column (in Line 1), so I would have to
gt; move the data in each column down by one cell to make room to write in the
gt; date. Is there any way to do that automatically?
Do you need a blank row at the top of your sheet?
To insert a row.
Click cell A1
On the top toolbar click gt; Insert gt; Rows

Does this help?

George Gee
Wessel wrote:
gt; How do you add dates to the top of each column in Excel? I want each
gt; column to represent a day. I could write the date in manually, but so
gt; far, I have been starting from the top of each column (in Line 1), so
gt; I would have to move the data in each column down by one cell to make
gt; room to write in the date. Is there any way to do that automatically?