How do you add dates to the top of each column in Excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wessel - 29 Dec 2005 20:11 GMT

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?

Reply to this Message

Bernard Liengme - 29 Dec 2005 20:41 GMT

Not sure if I understand the bit about "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?

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> 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?

Reply to this Message

George Gee - 29 Dec 2005 20:52 GMT

Do you need a blank row at the top of your sheet?
To insert a row.
Click cell A1
On the top toolbar click > Insert > Rows

Does this help?

George Gee

> 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?

Reply to this Message