+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Wessel
    Guest

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

    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?

  2. #2
    Bernard Liengme
    Guest

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

    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?
    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "Wessel" <Wessel@discussions.microsoft.com> wrote in message
    news:841A31AC-436C-4020-9EFF-75BEE0D1760F@microsoft.com...
    > 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?




  3. #3
    George Gee
    Guest

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

    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



    Wessel wrote:
    > 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 Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1