If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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" wrote in message ... 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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sort Excel Column on Fifth Character | Dolores | Worksheet Functions | 2 | December 27th, 2005 10:59 PM |
creating a bar graph | Johnfli | General Discussion | 0 | October 26th, 2005 08:16 PM |
Help PLEASE! Not sure what answer is: Match? Index? Other? | baz | Worksheet Functions | 7 | September 3rd, 2005 03:47 PM |
WHY | General Discussion | 9 | December 16th, 2004 12:49 AM | |
QDE (Quick Date Entry) | Norman Harker | Worksheet Functions | 37 | September 5th, 2004 01:24 AM |