Search 120,491 Tips
Copy a date across a number of cells in Excel
Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Excel 2000 and other Software topics.
How can I copy a date across a number of cells
Copy a date across a number of cells in Excel
Excel's autofill feature is really useful if you want to enter one date, drag the fill handle and have it extend the series. If you just want to copy the same value into a number of cells, then dragging normally isn't an option.
One method of doing achieveing this is to select all the cells (including the one with the date in), hold down the Ctrl key and press the D key. If the cells are horizontal rather than vertical, hold down the Ctrl key and press the R key.
Not finding the advice and tips you need on this Software Tip Site? Request a Tip Now!
| Guru Spotlight |
| Lynne Christen |
