| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I enter the date and make it carry throughout?
Same date or do you want it incremented one day per cell?
Same date. select a range, type date into active cell and hit CTRL + ENTER Incremented date. Enter date in A1. In A2 enter =A1 + 1 Drag/copy that as far as you want down. Gord Dibben MS Excel MVP On Wed, 9 Jan 2008 19:43:00 -0800, Julied wrote: How do I make the date I enter in one cell appear in other cells on the spreadsheet with out needing to entr it a million times? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make the current date appear when i click 'enter' in a cell | Excel Worksheet Functions | |||
| Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
| Excel first page.. date to carry over to other TAB pages? | New Users to Excel | |||
| enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
| Make macro run when I hit the enter key | Excel Discussion (Misc queries) | |||
Threaded Mode
